一、连接数据库
我的数据库是SQLyog,也就是小海豚。
连接用了以下的两个方法。
private MySqlConnection UserConnection;//MySqlConnection 这个是程序集里面的一个调用
public bool ConnectMySql()
{
try
{
if (UserConnection != null)
{
UserConnection.Close();
}
string StrCon = "server=localhost;user id=root; password=123456; database=bcs; pooling=true";
UserConnection = new MySqlConnection(StrCon);
UserConnection.Open();
UserConnection.ChangeDatabase("bcs");
return true;
}
catch (Exception ex)
{
return false;
}
}
public MySqlConnection CreateMySqlCon()
{
try
{
string constr = "server=localhost;user id=root; password=123456; database=bcs; pooling=true";
MySqlConnection sqlConnection = new MySqlConnection();
sqlConnection.ConnectionString = constr;
sqlConnection.Open();
if (sqlConnection.State.ToString() == "Open")
{
return sqlConnection;
}
return null;
}
catch (Exception ex)
{
//Logger.Instance.WriteException(ex, "CreateMySql Func Err");
return null;
}
}
二、用语句操作数据库
请忽略我的方法名,hhh。
里面的语句也是很简单的,用select 去搜索表里面的数据。语句格式:select + 目标表达式列表 + from + 表名;
一个基本的select语句可以分解成三个部分:查找什么数据( select )、从哪里查找( from )、查找的条件是什么( where )。
private void btn_updateliaohao_Click(object sender, EventArgs e)
{
MySqlConnection sqlConnection = CreateMySqlCon();
string temp="", batch="", box_id = "";
try
{
bool bRet = false;
MySqlDataReader dataReader = null;
string SqlCmd = "SELECT TRW,BATCH,BOX_ID,PACEAGE_TYPE FROM config";
MySqlCommand cmd = new MySqlCommand(SqlCmd, sqlConnection);
dataReader = cmd.ExecuteReader();
if (dataReader.Read())
{
bRet = true;
textBox1.Text = dataReader.GetString(0);
textBox2.Text = dataReader.GetString(1);
textBox3.Text = dataReader.GetString(2);
comboBox1.Text = dataReader.GetString(3);
}
}
catch (Exception ex)
{
throw ex;
}
}
下面的是通过更新语句进行操作数据库。
private void btn_updatepicihao_Click(object sender, EventArgs e)
{
MySqlConnection sqlConnection = CreateMySqlCon();
string temp = "", batch = "", box_id = "";
try
{
string UpdateStr = "update config set TRW='" + textBox1.Text + "'," + "BATCH='" + textBox2.Text + "',BOX_ID='" + textBox3.Text + "',PACEAGE_TYPE='"+ comboBox1.Text+"'";
MySqlCommand cmd = new MySqlCommand(UpdateStr, sqlConnection);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
throw ex;
}
}