计数数据存入Mysql
引用dll
mysql.data.dll
建一个数据连接静态类
public static class mysql
{
public static string constr = "database=test;password=密码;user id=root;server=ip地址";
public static mysqlconnection conn = new mysqlconnection(constr);
}
//定义测试字段
double countpass;
double countfail;
读取数据库数量方法
getcount();
private void getcount()
{
countfail = 0;
countpass = 0;
mysql.conn.open();//打开数据库
mysqlcommand cons = new mysqlcommand("select * from testlog where 时间 = '" + system.datetime.now.tostring("yyyy-mm-dd") + "'and 机型 = 'xxxx'and 站别='"+ combobox1 .text+ "'", mysql.conn);//
mysqldatareader readers = cons.executereader();
if (readers.read())
{
countpass = convert.toint32(readers[1].tostring());
countfail = convert.toint32(readers[2].tostring());
}
else
{
countpass = 0;
countfail = 0;
mysql.conn.close();
mysql.conn.open();
string sqlstr = "insert into testlog values('xxxx','" + 0 + "','" + 0 + "','" + 0 + "','" + system.datetime.now.tostring("yyyy-mm-dd") + "','" + combobox1.text + "')";
mysqlcommand comm = new mysqlcommand(sqlstr, mysql.conn);
comm.executenonquery();
countpass = 0;
countfail = 0;
mysql.conn.close();
}
mysql.conn.close();
label14.text = convert.tostring(countfail + countpass);
label5.text = convert.tostring(countpass);
label6.text = convert.tostring(countfail);
}
//存入数据
private void count()
{
if (constant.test == 2)
{
}
else
{
mysql.conn.open();//打开数据库
double num = countpass + countfail;
string sqlstr = "update testlog set 成功数 = '" + countpass + "', 失败数 = '" + countfail + "', 总数 ='" + num + "' where 时间='" + system.datetime.now.tostring("d") + "' and 站别='" + combobox1.text + "'and 机型 = 'xxx'";
mysqlcommand comm = new mysqlcommand(sqlstr, mysql.conn);
int iret = comm.executenonquery();
mysql.conn.close();
//label14.text = convert.tostring(countfail + countpass);
//label5.text = convert.tostring(countpass);
//label6.text = convert.tostring(countfail);
}
}