private void comboBox1_SelectedValueChanged(object sender, EventArgs e) { this.textBox5.Text = AddApacheWeb.rewriteValue(this.comboBox1.Text); }
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); } }