Exemple #1
0
 private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
 {
     this.textBox5.Text = AddApacheWeb.rewriteValue(this.comboBox1.Text);
 }
Exemple #2
0
 public AddApacheWeb()
 {
     addApacheWeb = this;
     InitializeComponent();
 }
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                string dbname = this.textBox1.Text.Trim();
                string dbuser = this.textBox4.Text.Trim();
                string dbpass = this.textBox2.Text;
                if (dbname == null || dbname.Equals(""))
                {
                    MessageBox.Show("数据库名必须填写", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                if (dbuser == null || dbuser.Equals(""))
                {
                    MessageBox.Show("用户名不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                if (dbpass == null || dbpass.Equals(""))
                {
                    MessageBox.Show("用户密码不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                //--start 判断库里是否已经存在同名数据库信息
                StringBuilder strSql2 = new StringBuilder();
                strSql2.Append("select count(1) from mysql");
                strSql2.Append(" where dbname=@dbname ");
                SQLiteParameter[] parameters2 =
                {
                    new SQLiteParameter("@dbname")
                };
                parameters2[0].Value = dbname;
                if (DbHelperSQLite.Exists(strSql2.ToString(), parameters2))
                {
                    MessageBox.Show("此同名数据库已存在,请删除或手动添加其他名称数据库", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                //--end 判断库里是否已经存在同名数据库信息


                //--start 插入一条数据库站信息入软件Sqlite数据库
                string            sql   = "insert into mysql(dbname,dbuser,dbpass) values(@dbname,@dbuser,@dbpass)";
                SQLiteParameter[] paras = new SQLiteParameter[] { new SQLiteParameter("@dbname", dbname), new SQLiteParameter("@dbuser", dbuser), new SQLiteParameter("@dbpass", dbpass) };
                int res = DbHelperSQLite.ExecuteSql(sql, paras);


                //--end 插入一条数据库信息入软件Sqlite数据库

                if (res == 1)
                {
                    AddApacheWeb apacheWeb   = new AddApacheWeb();
                    int          mysqlCreate = apacheWeb.CreateMysqlDataBase(dbname, dbuser, dbpass);
                    if (mysqlCreate == 1)
                    {
                        MessageBox.Show("数据库添加成功");
                        Form1.form1.load_mysql_list();
                        this.Hide();
                    }
                    else
                    {
                        StringBuilder delete_strSql = new StringBuilder();
                        delete_strSql.Append("delete from mysql ");
                        delete_strSql.Append(" where dbname=@dbname ");
                        SQLiteParameter[] delete_parameters =
                        {
                            new SQLiteParameter("@dbname")
                        };
                        delete_parameters[0].Value = dbname;
                        int rows = DbHelperSQLite.ExecuteSql(delete_strSql.ToString(), delete_parameters);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("新增数据库失败:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }