当前位置： 移动技术网 > IT编程>开发语言>.net > 计数数据存入Mysql

计数数据存入Mysql

2019年05月25日  | 移动技术网IT编程  | 我要评论

安徽省芜湖市邮编,苏州美食网,海安立发中学

引用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);
}
}

 

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网