110,567
社区成员
发帖
与我相关
我的任务
分享
//提交数据,将数据保存在数据库中
private void Button_Click_2(object sender, RoutedEventArgs e)
{
//InputGeneric input = new InputGeneric();
#region 获取数据
if (!string.IsNullOrEmpty(txt1.Text))
{
_goodsName = txt1.Text;
}
if (!string.IsNullOrEmpty(txt2.Text))
{
m2 = txt2.Text;
}
if (!string.IsNullOrEmpty(txt3.Text))
{
price = int.Parse(txt3.Text);
}
if (!string.IsNullOrEmpty(txt4.Text))
{
m3 = txt4.Text;
}
if (!string.IsNullOrEmpty(txt5.Text))
{
_remarks = txt5.Text;
}
if (!string.IsNullOrEmpty(txt6.Text))
{
_number = int.Parse(txt6.Text);
}
#endregion
try
{
MYSqlConn conn = new MYSqlConn();
conn.getConnection();
conn.getCommand();
MessageBox.Show("已经成功插入语句");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
#region 建立数据库连接
public MySqlConnection getConnection()
{
string setting = "server=localhost;user id=root;password=root;database=supermarket";
MySqlConnection conn = new MySqlConnection(setting);
return conn;
}
#endregion
#region 执行数据库sql命令
public void getCommand()
{
Input i=new Input();
string goods_name=i._goodsName;
int number_=i._number;
string remarks_=i._remarks;
InputHelper inputdata = new InputHelper(goods_name, remarks_, number_);//动态获取用户输入的值
string sqlstr = "insert into inputfac(goodsname,remarks,quantity) values(@goodsname,@remarks,@quantity)";
MySqlConnection mysqlconn = this.getConnection();
mysqlconn.Open();
MySqlCommand cmd = new MySqlCommand(sqlstr,mysqlconn);
cmd.Parameters.AddWithValue("@goodsname",inputdata.goodsname);
cmd.Parameters.AddWithValue("@remarks",inputdata.remarks);
cmd.Parameters.AddWithValue("@quantity", inputdata.quantity);
cmd.ExecuteNonQuery();//执行sql语句
cmd.Dispose();
mysqlconn.Close();
mysqlconn.Dispose();
}
private string Goodsname;
private int Quantity;
private string Remarks;
public InputHelper(string _goodsname,string _remarks,int _quantity)
{
this.Goodsname = _goodsname;
this.Quantity = _quantity;
this.Remarks = _remarks;
}
public string goodsname
{
get { return Goodsname; }
set { Goodsname = value; }
}
public string remarks
{
get { return Remarks; }
set { Remarks = value; }
}
public int quantity
{
get { return Quantity; }
set { Quantity = value; }
}
}