//获得数据库数据 private void GetUserData() { MySQLConnection DBConn = null; DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string type = MainWindow.wfmodel.WFModel_Type; string sql = "select name, description,type from template where type = '"+type+"'"; MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); DataTable ds = new DataTable(); mda.Fill(ds); DBConn.Close(); foreach (DataRow dr in ds.Rows) { TemplateModel um = new TemplateModel(); um.name = dr["name"].ToString(); um.desc = dr["description"].ToString(); um.type = dr["type"].ToString(); models.Add(um); } view.Source = models; this.listView1.DataContext = view; }
private static void CreateTableNumberTestType(MySQLConnection c) { using (var cmd = new MySQLCommand(@" CREATE TABLE number_type_test ( id INT NOT NULL, COL_TINYINT TINYINT , COL_U_TINYINT TINYINT unsigned, COL_SMALLINT SMALLINT , COL_MEDIUMINT MEDIUMINT , COL_INT INT , COL_BIGINT BIGINT , COL_DECIMAL DECIMAL(18,6) , COL_FLOAT FLOAT , COL_DOUBLE DOUBLE , COL_U_SMALLINT SMALLINT UNSIGNED, COL_U_MEDIUMINT MEDIUMINT UNSIGNED, COL_U_INT INT UNSIGNED, COL_U_BIGINT BIGINT UNSIGNED, COL_U_DECIMAL DECIMAL UNSIGNED, COL_BIT BIT(2) , PRIMARY KEY (id)); ", c)) { cmd.ExecuteNonQuery(); } }
public int AccountRequest(string pwd) { try { con.Open(); sql = "INSERT INTO users(user_password) VALUES(" + pwd + ")"; MySQLCommand com = new MySQLCommand(sql, con); com.ExecuteNonQuery(); sql = "SELECT LAST_INSERT_ID()"; com = new MySQLCommand(sql, con); DbDataReader reader = com.ExecuteReader(); int user_id = 0; if(reader.Read()) { user_id = Int32.Parse(reader["user_id"].ToString()); } sql = "INSERT INTO users_information VALUES(null,null,null,null)"; com = new MySQLCommand(sql, con); com.ExecuteNonQuery(); return user_id; } catch { return 0; } finally { con.Close(); } }
public void ExecuteScalarForAnyFieldType(string mySqlTypeDeclaration, string insertedLiteral, object expectedValue) { var c = CachedConnection; using (var cmd1 = new MySQLCommand("DROP TABLE IF EXISTS number_type_test", c)) cmd1.ExecuteNonQuery(); using (var cmd2 = new MySQLCommand($@"CREATE TABLE number_type_test ( id INT NOT NULL,COL_VALUE {mySqlTypeDeclaration},PRIMARY KEY (id));", c)) cmd2.ExecuteNonQuery(); using (var cmd3 = new MySQLCommand($@"INSERT INTO number_type_test ( id ,COL_VALUE)values(0,{insertedLiteral});", c)) cmd3.ExecuteNonQuery(); using (var cmd = new MySQLCommand("select COL_VALUE from number_type_test where id=0", c)) { object executeScalar = cmd.ExecuteScalar(); Assert.NotNull(executeScalar); if (expectedValue == null) { Assert.Null(executeScalar); } else { Assert.NotNull(executeScalar); Assert.IsType(expectedValue.GetType(), executeScalar); Assert.Equal(expectedValue, executeScalar); } } }
public AccountInfo AccountInfoReader(int user_id) { try { con.Open(); sql = "SELECT* FROM users_information WHERE user_id = " + user_id; MySQLCommand com = new MySQLCommand(sql, con); DbDataReader reader = com.ExecuteReader(); if(reader.Read()) { AccountInfo accountInfo = new AccountInfo(); accountInfo.Sex = short.Parse(reader["user_sex"].ToString()); accountInfo.Birthday = DateTime.Parse(reader["user_birthday"].ToString()); accountInfo.Phone = reader["uesr_phome"].ToString(); return accountInfo; } return null; } catch { return null; } finally { con.Close(); } }
/// <summary> /// 执行一条计算查询结果语句,返回查询结果(object)。 /// </summary> /// <param name="SQLString">计算查询结果语句</param> /// <returns>查询结果(object)</returns> public object ExecuteScalar(string SQLString) { using (MySQLConnection connection = new MySQLConnection(connectionString)) { using (MySQLCommand cmd = new MySQLCommand(SQLString, connection)) { try { connection.Open(); object obj = cmd.ExecuteScalar(); if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { return null; } else { return obj; } } catch (MySQLException e) { connection.Close(); throw e; } } } }
private void skinButton_DishIncrease_Click(object sender, EventArgs e) { conn1.Open(); string dishid = dataGridView2.SelectedRows[0].Cells[0].Value.ToString(); string dishquantity = dataGridView2.SelectedRows[0].Cells[1].Value.ToString(); string dishinformation = dataGridView2.SelectedRows[0].Cells[2].Value.ToString(); string dishstatus = dataGridView2.SelectedRows[0].Cells[3].Value.ToString(); string sql = "insert into dish values('" + dishid + "','" + dishquantity + "','" + dishinformation + "','" + dishstatus + "')"; MySQLCommand mys = new MySQLCommand(sql, conn1); if (mys.ExecuteNonQuery() != -1) { MessageBox.Show("新增成功!", "恭喜"); sql = "select * from dish"; MySQLDataAdapter ada2 = new MySQLDataAdapter(sql, conn1); DataSet ds2 = new DataSet(); ada2.Fill(ds2); dataGridView2.DataSource = ds2.Tables[0]; textBox_DishID.Clear(); textBox_DishQuantity.Clear(); textBox_DishInformation.Clear(); textBox_DishStatus.Clear(); } conn1.Close(); }
private void timer4_Tick(object sender, EventArgs e) { DBConn.Open(); MySQLCommand DBComm = new MySQLCommand("select * from `parkingsystem`.`login_record`", DBConn); MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn); firstCmd.ExecuteNonQuery(); MySQLDataReader DBReader = DBComm.ExecuteReaderEx(); DBReader.Read(); do { if (DBReader.GetString(2) == "帳密正確") { tSB_Exit.Enabled = true; tSB_search.Enabled = true; TSMI_help.Enabled = true; tabControl1.Enabled = true; MySQLCommand DBCom = new MySQLCommand("UPDATE `parkingsystem`.`login_record` SET `result` = '成功登入' WHERE CONVERT( `login_record`.`date` USING utf8 ) = '" + DBReader.GetString(0) + "' LIMIT 1 ;", DBConn); MySQLDataReader DBReader1 = DBCom.ExecuteReaderEx(); timer4.Enabled = false; break; } } while (DBReader.Read()); DBConn.Close(); }
private void timer5_Tick(object sender, EventArgs e) { DBConn.Open(); MySQLCommand DBComm = new MySQLCommand("select * from `parkingsystem`.`record`", DBConn); MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn); firstCmd.ExecuteNonQuery(); MySQLDataReader DBReader = DBComm.ExecuteReaderEx(); bool s = true; while (DBReader.Read()) { if (DBReader.GetString(2) == "E" || DBReader.GetString(2) == "") { tSSL_C.Text = "開啟"; s = false; break; } } if (s) { tSSL_C.Text = "關閉"; } DBConn.Close(); }
private void skinButton_DishEdit_Click(object sender, EventArgs e) { conn1.Open(); if (MessageBox.Show("确定要从数据库中修改这一行数据吗?", "数据无法恢复请慎重选择!", MessageBoxButtons.OKCancel) == DialogResult.OK) { string dishid = dataGridView2.SelectedRows[0].Cells[0].Value.ToString(); string dishquantity = dataGridView2.SelectedRows[0].Cells[1].Value.ToString(); string dishinformation = dataGridView2.SelectedRows[0].Cells[2].Value.ToString(); string dishstatus = dataGridView2.SelectedRows[0].Cells[3].Value.ToString(); string sql = "update dish set dishid=" + dishid + ",dishquantity=" + dishquantity + ",dishinformation=" + dishinformation + ",dishstatus=" + dishstatus + " where dishid=" + dishid; MySQLCommand mys = new MySQLCommand(sql, conn1); if (mys.ExecuteNonQuery() != -1) { MessageBox.Show("修改成功!", "恭喜"); sql = "select * from dish"; MySQLDataAdapter ada2 = new MySQLDataAdapter(sql, conn1); DataSet ds2 = new DataSet(); ada2.Fill(ds2); dataGridView2.DataSource = ds2.Tables[0]; } else { MessageBox.Show("修改失败!", "提示"); } } conn1.Close(); }
public PasteCode selectPasteCodeById(int id) { init(); con.Open(); string sql = "select * from paste_code where " + "id = " + id; System.Diagnostics.Debug.WriteLine(sql); MySQLCommand cmd = new MySQLCommand(sql, con); MySQLDataReader reader = cmd.ExecuteReaderEx(); PasteCode pasteCode = new PasteCode(); while (reader.Read()) { pasteCode.id = (int)reader[0]; pasteCode.poster = reader[1].ToString(); System.Diagnostics.Debug.WriteLine(pasteCode.poster); pasteCode.language = reader[2].ToString(); System.Diagnostics.Debug.WriteLine(pasteCode.language); pasteCode.languagemode = reader[3].ToString(); System.Diagnostics.Debug.WriteLine(pasteCode.languagemode); pasteCode.theme = reader[4].ToString(); System.Diagnostics.Debug.WriteLine(pasteCode.theme); byte[] buf = (byte[])reader[5]; pasteCode.code = System.Text.Encoding.UTF8.GetString(buf); System.Diagnostics.Debug.WriteLine(pasteCode.code); pasteCode.time = reader[6].ToString(); System.Diagnostics.Debug.WriteLine(pasteCode.time); } con.Close(); return(pasteCode); }
private void skinButton_MealCardEdit_Click(object sender, EventArgs e) { conn1.Open(); if (MessageBox.Show("确定要从数据库中修改这一行数据吗?", "数据无法恢复请慎重选择!", MessageBoxButtons.OKCancel) == DialogResult.OK) { string mealcardid = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); string mealcardinformation = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); string mealcardstatus = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(); string sql = "update mealcard set mealcardid=" + mealcardid + ",mealcardinformation=" + mealcardinformation + ",mealcardstatus=" + mealcardstatus + " where mealcardid=" + mealcardid; MySQLCommand mys = new MySQLCommand(sql, conn1); if (mys.ExecuteNonQuery() != -1) { MessageBox.Show("修改成功!", "恭喜"); sql = "select * from mealcard"; MySQLDataAdapter ada1 = new MySQLDataAdapter(sql, conn1); DataSet ds1 = new DataSet(); ada1.Fill(ds1); dataGridView1.DataSource = ds1.Tables[0]; } else { MessageBox.Show("修改失败!", "提示"); } } conn1.Close(); }
//获得数据库数据 private void GetUserData() { MySQLConnection DBConn = null; string connectStr = new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString; //System.Windows.Forms.MessageBox.Show(connectStr); DBConn = new MySQLConnection(connectStr); DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string sql = "select User_Id,User_Name,User_Dept,User_Job,User_Mail,User_Cell from tb_user"; MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); DataTable ds = new DataTable(); mda.Fill(ds); DBConn.Close(); foreach (DataRow dr in ds.Rows) { UserModel um = new UserModel(); um.ID = dr["User_Id"].ToString(); um.Name = dr["User_Name"].ToString(); um.Department = dr["User_Dept"].ToString(); um.Email = dr["User_Mail"].ToString(); um.PersonPosition = dr["User_Job"].ToString(); um.Telephone = dr["User_Cell"].ToString(); models.Add(um); } view.Source = models; this.listView1.DataContext = view; }
private void Del_Click(object sender, RoutedEventArgs e) { MySQLConnection DBConn = null; DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); try { DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string sql = "delete from wf_model where model_name = '"; sql += ((WFModel)listView1.SelectedItem).WFModel_Name; sql += "'"; //MessageBox.Show(sql); MySQLCommand cmd = new MySQLCommand(sql, DBConn); cmd.ExecuteNonQuery(); cmd.Dispose(); } catch (Exception e1) { MessageBox.Show("数据库连接失败,请检查网络连接或者数据库配置"); return; } GetTemplateData(); }
protected int update(string sql) { MySQLConnection conn = null; int resultCount = -1; try { conn = dbMgr.DBConns.PopDBConnection(); GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", sql), EventLevels.Important); MySQLCommand cmd = new MySQLCommand(sql, conn); try { resultCount = cmd.ExecuteNonQuery(); } catch (Exception) { LogManager.WriteLog(LogTypes.Error, string.Format("向数据库更新数据失败: {0}", sql)); } cmd.Dispose(); cmd = null; } finally { if (null != conn) { dbMgr.DBConns.PushDBConnection(conn); } } return(resultCount); }
static void Main(string[] args) { conn = new MySQLConnection(new MySQLConnectionString("10.125.103.139", "heartlink", "qwe", "123").AsString); cmd = new MySQLCommand(); da = new MySQLDataAdapter(); String pass = "******"; String sql = "select ID from students where password="******"ID = {0}", DBReader.GetString(0)); } } finally { DBReader.Close(); conn.Close(); } }
private JieriRecvKingItemData QueryRoleJieriRecvKing(DBManager dbMgr, string fromDate, string toDate, int roleID) { JieriRecvKingItemData result = null; MySQLConnection conn = null; try { conn = dbMgr.DBConns.PopDBConnection(); string cmdText = "SELECT t_roles.rid, t_roles.rname, t_roles.zoneid, x.totalrecv from t_roles, (SELECT t_jierizengsong.receiver, SUM(t_jierizengsong.goodscnt) AS totalrecv " + string.Format(" FROM t_jierizengsong WHERE t_jierizengsong.receiver={0} AND sendtime>= '{1}' AND sendtime<='{2}') x ", roleID, fromDate, toDate) + " where t_roles.isdel=0 and t_roles.rid = x.receiver "; MySQLCommand cmd = new MySQLCommand(cmdText, conn); MySQLDataReader reader = cmd.ExecuteReaderEx(); if (reader.Read()) { result = new JieriRecvKingItemData(); result.RoleID = Convert.ToInt32(reader["rid"].ToString()); result.Rolename = reader["rname"].ToString(); result.ZoneID = Convert.ToInt32(reader["zoneid"].ToString()); result.TotalRecv = Convert.ToInt32(reader["totalrecv"].ToString()); result.Rank = -1; } GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", cmdText), EventLevels.Important); cmd.Dispose(); } finally { if (null != conn) { dbMgr.DBConns.PushDBConnection(conn); } } return(result); }
//获得数据库数据 private void GetUserData() { MySQLConnection DBConn = null; DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string sql = "select distinct User_Dept from tb_user"; MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); DataTable ds = new DataTable(); mda.Fill(ds); DBConn.Close(); foreach (DataRow dr in ds.Rows) { UserModel um = new UserModel(); um.Department = dr["User_Dept"].ToString(); models.Add(um); } view.Source = models; this.listView1.DataContext = view; }
public int ExecuteNonQueryForInc(string commandStr) { connection.Open(); MySQLCommand cmdTemp1 = (MySQLCommand)connection.CreateCommand(); cmdTemp1.CommandText = "set names gbk"; cmdTemp1.ExecuteNonQuery(); command = (MySQLCommand)connection.CreateCommand(); command.CommandText = commandStr; command.ExecuteNonQuery(); MySQLCommand cmdTemp2 = (MySQLCommand)connection.CreateCommand(); cmdTemp2.CommandText = "select last_insert_id()"; MySQLDataReader readerTemp; readerTemp = (MySQLDataReader)cmdTemp2.ExecuteReader(); int LastID = -1; while (readerTemp.Read()) { LastID = readerTemp.GetInt16(0); } return(LastID); }
public GxMySQLDriverCSCursorDataReader(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, string stmt, int fetchSize, bool forFirst, int handle, bool cached, SlidingTime expiration, bool hasNested, bool dynStmt) { this.parameters = parameters; this.stmt = stmt; this.fetchSize = fetchSize; this.cache = connection.ConnectionCache; this.cached = cached; this.handle = handle; this.isForFirst = forFirst; _connManager = connManager; this.m_dr = dr; this.readBytes = 0; this.dynStmt = dynStmt; con = _connManager.IncOpenHandles(handle, m_dr.DataSource); con.CurrentStmt = stmt; con.MonitorEnter(); GXLogging.Debug(log, "Open GxMySQLCursorDataReader handle:'" + handle); MySQLCommand cmd = (MySQLCommand)dr.GetCommand(con, stmt, parameters); cmd.ServerCursor = hasNested; cmd.FetchSize = (uint)fetchSize; reader = cmd.ExecuteReader(); cache.SetAvailableCommand(stmt, false, dynStmt); open = true; block = new GxArrayList(fetchSize); pos = -1; if (cached) { key = SqlUtil.GetKeyStmtValues(parameters, stmt, isForFirst); this.expiration = expiration; } }
private static void PrepareCommand(MySQLCommand cmd, MySQLConnection conn, DbTransaction trans, string cmdText, MySQLParameter[] cmdParms) { if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.Connection = conn; cmd.CommandText = cmdText; if (trans != null) { cmd.Transaction = trans; } cmd.CommandType = CommandType.Text; if (cmdParms != null) { foreach (MySQLParameter parameter in cmdParms) { if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) && parameter.Value == null) { parameter.Value = DBNull.Value; } cmd.Parameters.Add(parameter); } } }
private void ButtonMagInfo_Click(object sender, EventArgs e) { MySQLConnection SQLconnection = new MySQLConnection(new MySQLConnectionString ("localhost", "DormitoryManage", "root", "123456").AsString); string SQLstr = "SELECT * FROM manager_info WHERE managerNumber = " + PublicValue.MAGNUM; SQLconnection.Open(); MySQLCommand SQLcommand1 = new MySQLCommand("SET NAMES GB2312", SQLconnection); SQLcommand1.ExecuteNonQuery(); //执行设置字符集的语句 MySQLCommand SQLcommand2 = new MySQLCommand(SQLstr, SQLconnection); MySQLDataReader SQLreader = (MySQLDataReader)SQLcommand2.ExecuteReader(); if (SQLreader.Read()) { this.TextBox1.Text = SQLreader["managerNumber"].ToString(); this.TextBox2.Text = SQLreader["managerName"].ToString(); this.TextBox3.Text = SQLreader["managerGender"].ToString(); this.TextBox4.Text = SQLreader["managerAge"].ToString(); this.TextBox5.Text = SQLreader["dormitoryNumber"].ToString(); this.TextBox6.Text = SQLreader["managerPosition"].ToString(); this.TextBox7.Text = SQLreader["managerPhone"].ToString(); this.TextBox8.Text = SQLreader["managerPassword"].ToString(); } SQLconnection.Close(); }
public void BuidConnections(MySQLConnectionString connStr, int maxCount) { MySQLConnection dbConn = null; for (int i = 0; i < maxCount; i++) { dbConn = new MySQLConnection(connStr.AsString); try { dbConn.Open(); } catch (Exception ex) { DataHelper.WriteFormatExceptionLog(ex, "BuidConnections", false, false); throw ex; } if (!string.IsNullOrEmpty(DBConnections.dbNames)) { MySQLCommand cmd = new MySQLCommand(string.Format("SET names '{0}'", DBConnections.dbNames), dbConn); cmd.ExecuteNonQuery(); } this.DBConns.Enqueue(dbConn); } this.SemaphoreClients = new Semaphore(maxCount, maxCount); }
public void ExecuteSqlTran(Hashtable SQLStringList) { using (DbTransaction trans = this.DbConn.BeginTransaction()) { using (MySQLCommand cmd = new MySQLCommand()) { try { foreach (object obj in SQLStringList) { DictionaryEntry myDE = (DictionaryEntry)obj; string cmdText = myDE.Key.ToString(); MySQLParameter[] cmdParms = (MySQLParameter[])myDE.Value; MyDbConnection3.PrepareCommand(cmd, this.DbConn, trans, cmdText, cmdParms); int val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); this.LogSql(cmdText); } trans.Commit(); } catch { trans.Rollback(); throw; } } } }
public Dictionary <string, object> selectCommentByArticleId(int id) { init(); con.Open(); string sql = "select a.*,b.name from comment_list a right join user b on a.user_id = b.id " + "where a.article_id = " + id; System.Diagnostics.Debug.WriteLine(sql); MySQLCommand cmd = new MySQLCommand(sql, con); MySQLDataReader reader = cmd.ExecuteReaderEx(); List <Comment> comments = new List <Comment>(); List <string> usernames = new List <string>(); while (reader.Read()) { comments.Add(new Comment((int)reader[0], (int)reader[1], (int)reader[2], encode.numToString(System.Text.Encoding.UTF8.GetString((byte[])reader[3])), reader[4].ToString())); usernames.Add((string)reader[5]); } Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("comments", comments); dic.Add("usernames", usernames); con.Close(); return(dic); }
public int contarEstudiantes() { int cont = 0; String CadenaSql = "select count(1) from estudiante "; try { MySQLDataReader ds; MySQLCommand query; cnn.Open(); query = new MySQLCommand(CadenaSql, cnn); ds = query.ExecuteReaderEx(); ds.Read(); cont = int.Parse(ds.GetValue(0).ToString()); } catch (MySQLException e) { System.Console.WriteLine(e.Message.ToString()); } finally { cnn.Close(); } return(cont); }
public int insertNewPasteCode(PasteCode pasteCode) { init(); con.Open(); string sql = "insert into paste_code value(null," + "\"" + pasteCode.poster + "\"," + "\"" + pasteCode.language + "\"," + "\"" + pasteCode.languagemode + "\"," + "\"" + pasteCode.theme + "\"," + "\"" + pasteCode.code + "\"," + "\"" + pasteCode.time + "\")"; System.Diagnostics.Debug.WriteLine(sql); MySQLCommand cmd = new MySQLCommand(sql, con); cmd.ExecuteNonQuery(); sql = "select id from paste_code where " + "poster = " + "\"" + pasteCode.poster + "\" && " + "time = " + "\"" + pasteCode.time + "\""; System.Diagnostics.Debug.WriteLine(sql); cmd = new MySQLCommand(sql, con); MySQLDataReader reader = cmd.ExecuteReaderEx(); int id = 0; while (reader.Read()) { id = (int)reader[0]; } con.Close(); return(id); }
public static List <string> Query() { List <string> ret = new List <string>(); lock (conn) { try { MySQLCommand commn; commn = new MySQLCommand("create table if not exists monsqldb (text varchar(1000))", conn); commn.ExecuteNonQuery(); commn = new MySQLCommand("select text from monsqldb", conn); MySQLDataReader mdr = commn.ExecuteReaderEx(); while (mdr.Read()) { ret.Add(mdr.GetString(0)); } } catch (Exception ex) { System.Windows.Forms.MessageBox.Show("数据库访问出错:" + ex.Message); } } return(ret); }
public static string GetAward(DBManager dbMgr, int zoneID, int roleID) { string result = ""; MySQLConnection conn = null; try { conn = dbMgr.DBConns.PopDBConnection(); string cmdText = string.Format("SELECT type,state FROM t_spread_award WHERE zoneID = '{0}' AND roleID = '{1}'", zoneID, roleID); MySQLCommand cmd = new MySQLCommand(cmdText, conn); MySQLDataReader reader = cmd.ExecuteReaderEx(); while (reader.Read()) { if (result != "") { result += "$"; } result = result + reader["type"].ToString() + "#"; result += reader["state"].ToString(); } GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", cmdText), EventLevels.Important); cmd.Dispose(); } finally { if (null != conn) { dbMgr.DBConns.PushDBConnection(conn); } } return(result); }
public void CheckPassword() { // 檢查帳密正確性 // 權限設定還沒寫 DBConn.Open(); MySQLCommand DBComm = new MySQLCommand("select * from `RFID_Project`.`user`", DBConn); MySQLCommand firstCmd = new MySQLCommand("set names big5", DBConn); firstCmd.ExecuteNonQuery(); MySQLDataReader DBReader = DBComm.ExecuteReaderEx(); bool error = true; DBReader.Read(); do { string id = ("" + DBReader.GetValue(0)); //id string passoord = ("" + DBReader.GetValue(1)); //password string enter = System.DateTime.Now.ToString("yyyy/MM/dd/ HH:mm:ss"); if (tB_Id.Text == id && tB_Password.Text == passoord) { error = false; MySQLCommand DBCom = new MySQLCommand("INSERT INTO `RFID_Project`.`login_record` (`date`,`id`,`result`)VALUES ('" + enter + "','" + tB_Id.Text + "','" + "success" + "');", DBConn); //登錄記錄 MySQLDataReader DBReader1 = DBCom.ExecuteReaderEx(); this.DialogResult = DialogResult.OK; this.Close(); } } while (DBReader.Read()); if (error) { MessageBox.Show("登錄檔作業失敗!! " + "\r\n" + "帳號或密碼有錯!請再確認"); } DBConn.Close(); }
public LateWtEl(string flag) { InitializeComponent(); string SQLstr = "\0"; MySQLConnection SQLconnection = new MySQLConnection(new MySQLConnectionString ("localhost", "DormitoryManage", "root", "123456").AsString); if (flag == "0") { this.Text = "晚归信息"; SQLstr = "SELECT studentNumber as '学号',lateReturnTime as '晚归时间' FROM late_return WHERE studentNumber = " + PublicValue.STUNUM; } else if (flag == "1") { this.Text = "水电信息"; SQLstr = "SELECT studentNumber as '学号', dormitoryNumber as '公寓号',roomNumber as '寝室号',checkMonth as '日期',electricityConsumption as '用电量',electricityBill as '电费',waterConsumption" + " as '用水量',waterBill as '水费' FROM Water_Electricity WHERE studentNumber = " + PublicValue.STUNUM; } SQLconnection.Open(); MySQLCommand SQLcommand = new MySQLCommand("SET NAMES GB2312", SQLconnection); SQLcommand.ExecuteNonQuery(); //执行设置字符集的语句 MySQLDataAdapter SQLadapter = new MySQLDataAdapter(SQLstr, SQLconnection); DataSet set = new DataSet(); SQLadapter.Fill(set); DataGridView.DataSource = set.Tables[0]; SQLconnection.Close(); }
public int validarUsuario(string u, string c) { int cont = 0; String CadenaSql = "select count(1) as cont from usuario where usuario = '" + u + "' and clave = md5('" + c + "')"; try { MySQLDataReader ds; MySQLCommand query; cnn.Open(); query = new MySQLCommand(CadenaSql, cnn); ds = query.ExecuteReaderEx(); ds.Read(); cont = int.Parse(ds.GetValue(0).ToString()); } catch (MySQLException e) { System.Console.WriteLine(e.Message.ToString()); } finally { cnn.Close(); } return(cont); }
private MySQLDataReader ExecSelect(string sql) { MySQLConnection conn = null; MySQLDataReader result; try { conn = DBManager.getInstance().DBConns.PopDBConnection(); MySQLCommand cmd = new MySQLCommand(sql, conn); GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", sql), EventLevels.Important); MySQLDataReader reader = cmd.ExecuteReaderEx(); cmd.Dispose(); result = reader; } catch (Exception ex) { LogManager.WriteException(ex.Message); result = null; } finally { if (null != conn) { DBManager.getInstance().DBConns.PushDBConnection(conn); } } return(result); }
//获得数据库数据 private void GetUserData() { MySQLConnection DBConn = null; DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string type = MainWindow.wfmodel.WFModel_Type; string sql = "select name, description,type from template where type = '" + type + "'"; MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); DataTable ds = new DataTable(); mda.Fill(ds); DBConn.Close(); foreach (DataRow dr in ds.Rows) { TemplateModel um = new TemplateModel(); um.name = dr["name"].ToString(); um.desc = dr["description"].ToString(); um.type = dr["type"].ToString(); models.Add(um); } view.Source = models; this.listView1.DataContext = view; }
protected int delete(string sql, object[] param) { MySQLConnection conn = null; int resultCount = -1; try { conn = this.dbMgr.DBConns.PopDBConnection(); GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", sql), EventLevels.Important); MySQLCommand cmd = new MySQLCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = sql; try { resultCount = cmd.ExecuteNonQuery(); } catch (Exception) { LogManager.WriteLog(LogTypes.Error, string.Format("向数据库删除数据失败: {0}", sql), null, true); } cmd.Dispose(); cmd = null; } finally { if (null != conn) { this.dbMgr.DBConns.PushDBConnection(conn); } } return(resultCount); }
/// <summary> /// 得到连接对象 /// </summary> /// <returns></returns> public void GetConn() { MySQLConnection conn = null; conn = new MySQLConnection(new MySQLConnectionString("svn.breadth.cn", "mez", "root", "breadth2009").AsString); conn.Open(); MySQLCommand comn = new MySQLCommand("set names utf-8", conn); comn.ExecuteNonQuery(); }
//�ΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡΡι��캯�� public UserManager(string name) : base(name, 560, 300) { MySQLConnection obSql; string linkStr = new MySQLConnectionString("localhost", "flox", "root", "00", 3306).AsString; linkStr += ";Character Set=GBK"; obSql = new MySQLConnection(linkStr); obSql.Open(); // ִ�в�ѯ��� MessageBox.Show(linkStr, "���ӳɹ�"); MySQLCommand obCommand = null; MySQLDataReader obReader = null; string str = ""; try { obCommand = new MySQLCommand("select username from cdb_members", obSql); obReader = obCommand.ExecuteReaderEx(); } catch (Exception ex) { MessageBox.Show(ex.ToString(), "ִ�д���"); } if (obReader != null) { try { str += obReader.FieldCount.ToString() + "\r\n"; while (obReader.Read()) { for (int i = 0; i < obReader.FieldCount; i++) { string inputStr = obReader.GetString(i); #region //note ///Encoding inputCode = Encoding.GetEncoding("GBK"); ///Encoding outCode = Encoding.Unicode; ///byte[] bta = inputCode.GetBytes(inputStr); ///byte[] bta2 = Encoding.Convert(inputCode, outCode, bta); ///string outStr = outCode.GetString(bta2); #endregion str += inputStr; } str += "\r\n"; } } finally { obReader.Close(); obCommand.Dispose(); obSql.Close(); } } MessageBox.Show(str, "�û��б�"); }
//获得数据库数据 void GetTemplateData() { models.Clear(); MySQLConnection DBConn = null; DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); try { DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string sql = "select model_name,owner,model_content,lastedit_time,model_disc,create_time from wf_model"; MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); DataTable ds = new DataTable(); mda.Fill(ds); DBConn.Close(); foreach (DataRow dr in ds.Rows) { WFModel wfm = new WFModel(); wfm.WFModel_CreateTime = dr["create_time"].ToString(); wfm.WFModel_LasteditTime = dr["lastedit_time"].ToString(); wfm.WFModel_Name = dr["model_name"].ToString(); wfm.WFModel_Owner = dr["owner"].ToString(); string test = dr["model_content"].ToString(); if (dr["model_content"] == null || dr["model_content"].ToString().Length<=0) { wfm.WFModel_Content = ""; }else wfm.WFModel_Content = Encoding.Default.GetString((Byte[])dr["model_content"]); models.Add(wfm); } view.Source = models; this.listView1.DataContext = view; } catch (Exception e) { MessageBox.Show("数据库连接失败,请检查网络连接或者数据库配置"); return; } }
/// <summary> /// 执行SQL语句,返回影响的记录数 /// </summary> /// <param name="SQLString">SQL语句</param> /// <returns>影响的记录数</returns> public int ExecuteNonQuery(string SQLString, params MySQLParameter[] cmdParms) { using (MySQLConnection connection = new MySQLConnection(connectionString)) { using (MySQLCommand cmd = new MySQLCommand()) { try { PrepareCommand(cmd, connection, null, SQLString, cmdParms); int rows = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return rows; } catch (MySQLException e) { throw e; } } } }
//执行SQL语句,返回影响的记录数 /// <summary> /// 执行SQL语句,返回影响的记录数 /// </summary> /// <param name="SQLString">SQL语句</param> /// <returns>影响的记录数</returns> public int ExecuteNonQuery(string SQLString) { using (MySQLConnection connection = new MySQLConnection(connectionString)) { using (MySQLCommand cmd = new MySQLCommand(SQLString, connection)) { try { connection.Open(); int rows = cmd.ExecuteNonQuery(); return rows; } catch (MySQLException e) { connection.Close(); throw e; } } } }
public static ToolboxCategoryItems loadTemplatebox() { MySQLConnection DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "template", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); if (DBConn != null) { try { DBConn.Open(); string sql = "select * from template"; MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); MySQLCommand mcd = new MySQLCommand(sql, DBConn); mcd.ExecuteNonQuery(); DataTable TemplateDataTable = new DataTable(); mda.Fill(TemplateDataTable); DBConn.Close(); loadSystemIcon(); ToolboxCategoryItems toolboxCategoryItems = new ToolboxCategoryItems(); ToolboxCategory templates = new System.Activities.Presentation.Toolbox.ToolboxCategory("表单模板"); foreach (DataRow dr in TemplateDataTable.Rows) { ToolboxItemWrapper Template = new ToolboxItemWrapper(typeof(Wxwinter.BPM.WFDesigner.Template), dr["NAME"].ToString()); templates.Add(Template); } toolboxCategoryItems.Add(templates); parentWindow.statusInfo.Text = ""; return toolboxCategoryItems; } catch (Exception e) { parentWindow.statusInfo.Text = "数据库连接失败,请检查网络设置和数据库连接配置"; return null; } } else { return null; } }
public static DataTable ExecuteDataTable(string SQLString) { using (MySQLConnection connection = new MySQLConnection(connectionString)) { DataSet ds = new DataSet(); try { connection.Open(); MySQLDataAdapter command = new MySQLDataAdapter(SQLString, connection); MySQLCommand commn = new MySQLCommand("set names gbk", connection); commn.ExecuteNonQuery(); command.Fill(ds, "ds"); connection.Close(); } catch (MySQLException ex) { throw new Exception(ex.Message); } return ds.Tables[0]; } }
public static DataTable ExecuteDataTable(string SQLString, params MySQLParameter[] cmdParms) { using (MySQLConnection connection = new MySQLConnection(connectionString)) { MySQLCommand cmd = new MySQLCommand(); PrepareCommand(cmd, connection, null, SQLString, cmdParms); using (MySQLDataAdapter da = new MySQLDataAdapter(cmd)) { DataSet ds = new DataSet(); try { da.Fill(ds, "ds"); cmd.Parameters.Clear(); } catch (MySQLException ex) { throw new Exception(ex.Message); } return ds.Tables[0]; } } }
public bool Login(LoginData data) { try { con.Open(); sql = "SELECT user_password from users where user_id = " + data.User_id + ""; MySQLCommand com = new MySQLCommand(sql, con); DbDataReader reader = com.ExecuteReader(); if (reader.Read()) if (reader["user_password"].ToString() == data.User_password) return true; return false; } catch { return false; } finally { con.Close(); } }
static void Main(string[] args) { try { // https://sites.google.com/a/jsc-solutions.net/backlog/knowledge-base/2014/201406/20140609/mysql // "C:\util\xampp-win32-1.8.0-VC9\xampp\mysql_start.bat" // ex = {"Authentication to host '192.168.1.211' for user 'arvo' using method // 'mysql_native_password' failed with message: Reading from the stream has failed."} var uri = new Uri("mysql://*****:*****@192.168.1.211"); // 192.168.1.211:3306 arvo xxx var myConnectionString = "server=127.0.0.1;database=test;uid=root;"; //var myConnectionString = "server=192.168.1.211;database=test;uid=arvo;password=xxx;"; // DbConnection var myConnection = new MySQLConnection(myConnectionString); string selectQuery = "show databases"; // DbCommand var myCommand = new MySQLCommand(selectQuery); myCommand.Connection = myConnection; myConnection.Open(); //var i = myCommand.ExecuteScalar(); var a = new __DbDataAdapter { SelectCommand = myCommand }; var t = new DataTable(); //var ds = new DataSet(); a.Fill(t); myCommand.Connection.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.ReadLine(); }
public void GetPeopleDate(string str) { models.Clear(); MySQLConnection DBConn = null; DBConn = new MySQLConnection(new MySQLConnectionString(Configuration.getDBIp(), "workflow", Configuration.getDBUsername(), Configuration.getDBPassword()).AsString); try { DBConn.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", DBConn); setformat.ExecuteNonQuery(); setformat.Dispose(); string sql = "select tb_per.User_Name , tb_user.User_Mail from tb_user, tb_per where tb_per.user_name = tb_user.User_Name and tb_per.user_authority = "; sql += "'" + str + "'"; //MessageBox.Show(sql); MySQLDataAdapter mda = new MySQLDataAdapter(sql, DBConn); DataTable ds = new DataTable(); mda.Fill(ds); DBConn.Close(); foreach (DataRow dr in ds.Rows) { peopleInfo wfm = new peopleInfo(); wfm.peopleName = dr["user_name"].ToString(); wfm.peopleEmail = dr["User_Mail"].ToString(); models.Add(wfm); } view.Source = models; this.peopleListView.DataContext = view; } catch (System.Exception ex) { MessageBox.Show("数据库连接失败,请检查网络连接或者数据库配置"); return; } }
public void Insert(string tableName, IDictionary<string, string> item) { MySQLCommand commn = null; try { List<string> columns = item.Keys.ToList<string>(); List<string> values = item.Values.ToList<string>(); for (int index = 0; index < values.Count; index++) { if (string.IsNullOrEmpty(values[index])) { values.RemoveAt(index); columns.RemoveAt(index); index--; } } sqlCommnBuilder = new StringBuilder(); sqlCommnBuilder.Append("INSERT INTO "); sqlCommnBuilder.Append(tableName); sqlCommnBuilder.Append(" ("); for (int index = 0; index < columns.Count; index++) { sqlCommnBuilder.Append(columns[index]); sqlCommnBuilder.Append(", "); } sqlCommnBuilder.Remove(sqlCommnBuilder.Length - 2, 2); sqlCommnBuilder.Append(") VALUES ('"); for (int index = 0; index < values.Count; index++) { sqlCommnBuilder.Append(values[index]); sqlCommnBuilder.Append("', '"); } sqlCommnBuilder.Remove(sqlCommnBuilder.Length - 4, 4); sqlCommnBuilder.Append("')"); conn.Open(); Common.Log(sqlCommnBuilder.ToString()); commn = new MySQLCommand(); commn.CommandType = CommandType.Text; commn.CommandText = sqlCommnBuilder.ToString(); commn.Connection = conn; int id = commn.ExecuteNonQuery(); int t = id; } catch (MySQLException mySQLException) { Common.Log(mySQLException.ToString()); } finally { if (commn != null) { commn.Dispose(); } if (conn != null) { conn.Close(); conn.Dispose(); } } }
static void Main(string[] args) { // while (true) // { try { StreamReader objReader = new StreamReader("setting.ini"); string sLine = ""; ArrayList arrText = new ArrayList(); while (sLine != null) { sLine = objReader.ReadLine(); if (sLine != null) arrText.Add(sLine); } objReader.Close(); // foreach (string sOutput in arrText) // dbconn = sOutput; //MySQLConnection conn = new MySQLConnection(new MySQLConnectionString("192.168.234.129", "qqnotic", "toryzen", "q1w2e3r4").AsString);//实例化一个连接对象其中myquest为数据库名,root为数据库用户名,amttgroup为数据库密码 MySQLConnection conn = new MySQLConnection(new MySQLConnectionString(arrText[0].ToString(), arrText[1].ToString(), arrText[2].ToString(), arrText[3].ToString()).AsString);//实例化一个连接对象其中myquest为数据库名,root为数据库用户名,amttgroup为数据库密码 conn.Open(); MySQLCommand commn = new MySQLCommand("set names gb2312;", conn); commn.ExecuteNonQuery(); MySQLCommand cmds = new MySQLCommand("select * from qqnotic where isok = 0 limit 1", conn); MySQLDataReader reader = cmds.ExecuteReaderEx(); while (reader.Read()) { int userid = int.Parse(reader["userid"].ToString()); //用户id int checktype = int.Parse(reader["btype"].ToString()); //业务类型 MySQLCommand cmdname = new MySQLCommand("select * from qqname where id = " + userid, conn); MySQLDataReader readername = cmdname.ExecuteReaderEx(); while (readername.Read()) { qq = int.Parse(readername["qqnum"].ToString()); //qq号码 qqname = (string)readername["qqname"]; //qq昵称 realname = (string)readername["realname"]; //用户真名 } bbtype = "光宇信息中心通知"; //通知标题 bbcontent = (string)reader["content"]; //通知内容 /* 若指定通知类型 */ if (checktype != 0) { MySQLCommand cmdtype = new MySQLCommand("select * from btype where id = " + checktype, conn); MySQLDataReader btype = cmdtype.ExecuteReaderEx(); while (btype.Read()) { bbtype = (string)btype["type"]; //通知标题 bbcontent = (string)btype["content"]; //通知内容 } } System.DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1)); int timeStamp = (int)(System.DateTime.Now - startTime).TotalSeconds; MySQLCommand excmds = new MySQLCommand("UPDATE `qqnotic`.`qqnotic` SET `isok` = '1',`extime` = " + timeStamp + " WHERE `qqnotic`.`id` =" + reader["id"], conn); excmds.ExecuteNonQuery(); //写入系统时间 notis = bbtype + ":\n" + realname + "您好," + bbcontent; Console.WriteLine(System.DateTime.Now + "向用户" + realname + "(" + qq + ") 发送一条信息!"); } conn.Close(); } catch { Exception e; } if (qq != 0 && notis != "") { try { Clipboard.Clear(); Clipboard.SetDataObject(notis,true); } catch { Exception e; } const int WM_CHAR = 0x0102; const int WM_KEYDOWN = 0x0100; const int WM_PASTE = 0x0302; const int WM_SETTEXT = 0x000C; const int WM_Close = 0x0010; string[] cmd = new string[] { "start tencent://message/?uin=" + qq + "&Site=gyyx.cn&Menu=yes" }; Cmd(cmd); Thread.Sleep(1000); EnumWindows(PrintWindow, IntPtr.Zero); string tr = notis; IntPtr hwndCalc = hander; //ShowWindow(hwndCalc,1); PostMessage(hwndCalc, WM_PASTE, 0, 0); Thread.Sleep(500); PostMessage(hwndCalc, WM_KEYDOWN, 13, 0); Thread.Sleep(500); //PostMessage(hwndCalc, WM_KEYDOWN, 27, 0); PostMessage(hwndCalc, WM_Close, 0, 0); Thread.Sleep(1000); qq = 0; notis = ""; } // else { Thread.Sleep(6000); } // } }
public void Update(string tableName, string set, string where) { MySQLCommand commn = null; try { string insertString = "UPDATE TABLE_NAME SET SET_CONDITION WHERE WHERE_CONDITION"; insertString = insertString.Replace("TABLE_NAME", tableName); insertString = insertString.Replace("SET_CONDITION", set); insertString = insertString.Replace("WHERE_CONDITION", where); Common.Log(insertString); conn.Open(); commn = new MySQLCommand(); commn.CommandText = insertString; commn.CommandType = CommandType.Text; commn.Connection = conn; commn.ExecuteNonQuery(); } catch (MySQLException mySqlException) { Common.Log(mySqlException.ToString()); } finally { if (commn != null) { commn.Dispose(); } if (conn != null) { conn.Close(); conn.Dispose(); } } }
public void Query(string tableName, string where, IDictionary<string, string> item) { MySQLCommand commn = null; MySQLDataReader mySqlReader = null; MySQLDataAdapter mySqlAdapter = null; try { conn.Open(); Common.Log("Query columns from table: " + tableName); // Query table column name string[] columns = null; commn = new MySQLCommand(); string queryString = "SELECT column_name FROM information_schema.columns WHERE table_schema = 'DB_NAME' AND table_name = 'TABLE_NAME'"; queryString = queryString.Replace("DB_NAME", databaseName); queryString = queryString.Replace("TABLE_NAME", tableName); commn.CommandText = queryString; commn.CommandType = CommandType.Text; commn.Connection = conn; mySqlAdapter = new MySQLDataAdapter(commn); DataSet myDataSet = new DataSet(); mySqlAdapter.Fill(myDataSet); columns = new string[myDataSet.Tables[0].Rows.Count]; for (int rowIndex = 0; rowIndex < myDataSet.Tables[0].Rows.Count; rowIndex++) { columns[rowIndex] = myDataSet.Tables[0].Rows[rowIndex][0].ToString(); } myDataSet.Clear(); // Query table by where condition commn.Dispose(); commn = new MySQLCommand(); string queryString2 = "SELECT * FROM TABLE_NAME WHERE CONDITION"; queryString2 = queryString2.Replace("TABLE_NAME", tableName); queryString2 = queryString2.Replace("CONDITION", where); commn.CommandText = queryString2; commn.CommandType = CommandType.Text; commn.Connection = conn; Common.Log(queryString2); mySqlAdapter = new MySQLDataAdapter(commn); myDataSet = new DataSet(); mySqlAdapter.Fill(myDataSet); for (int columnIndex = 0; columnIndex < myDataSet.Tables[0].Columns.Count; columnIndex++) { item[columns[columnIndex]] = myDataSet.Tables[0].Rows[0][columnIndex].ToString(); } } catch (MySQLException mySqlException) { Common.Log(mySqlException.ToString()); } finally { if (mySqlAdapter != null) { mySqlAdapter.Dispose(); } if (mySqlReader != null) { mySqlReader.Close(); mySqlReader.Dispose(); } if (commn != null) { commn.Dispose(); } if (conn != null) { conn.Close(); conn.Dispose(); } } }
public static object ExecuteScalar(string SQLString, params MySQLParameter[] cmdParms) { using (MySQLConnection connection = new MySQLConnection(connectionString)) { using (MySQLCommand cmd = new MySQLCommand()) { try { PrepareCommand(cmd, connection, null, SQLString, cmdParms); object obj = cmd.ExecuteScalar(); cmd.Parameters.Clear(); if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value))) { return null; } else { return obj; } } catch (MySQLException e) { throw e; } } } }
private static void PrepareCommand(MySQLCommand cmd, MySQLConnection conn, MySQLTransaction trans, string cmdText, MySQLParameter[] cmdParms) { if (conn.State != ConnectionState.Open) conn.Open(); cmd.Connection = conn; cmd.CommandText = cmdText; if (trans != null) cmd.Transaction = trans; cmd.CommandType = CommandType.Text;//cmdType; if (cmdParms != null) { foreach (MySQLParameter parameter in cmdParms) { if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) && (parameter.Value == null)) { parameter.Value = DBNull.Value; } cmd.Parameters.Add(parameter); } } conn.Close(); }
public static MySQLDataReader ExecuteReader(string strSQL) { MySQLConnection connection = new MySQLConnection(connectionString); MySQLCommand cmd = new MySQLCommand(strSQL, connection); MySQLDataReader myReader = null; try { connection.Open(); MySQLDataAdapter command = new MySQLDataAdapter(strSQL, connection); MySQLCommand commn = new MySQLCommand("set names gbk", connection); myReader = cmd.ExecuteReaderEx(); return myReader; } catch (MySQLException e) { throw e; } finally { myReader.Close(); } }
public static MySQLDataReader ExecuteReader(string SQLString, params MySQLParameter[] cmdParms) { MySQLConnection connection = new MySQLConnection(connectionString); MySQLCommand cmd = new MySQLCommand(); MySQLDataReader myReader = null; try { PrepareCommand(cmd, connection, null, SQLString, cmdParms); myReader = cmd.ExecuteReaderEx(); cmd.Parameters.Clear(); return myReader; } catch (MySQLException e) { throw e; } finally { myReader.Close(); cmd.Dispose(); connection.Close(); } }
//执行SQL语句,返回影响的记录数 //<param name="sqlString">sql语句</param> public static int ExecuteNonQuery(string SQLString) { using (MySQLConnection connection = new MySQLConnection(connectionString)) { using (MySQLCommand cmd = new MySQLCommand(SQLString, connection)) { try { connection.Open(); MySQLCommand setformat = new MySQLCommand("set names gb2312", connection); setformat.ExecuteNonQuery(); setformat.Dispose(); int rows = cmd.ExecuteNonQuery(); return rows; } catch (MySQLException e) { connection.Close(); throw e; } } } }
private bool addOneUrl(int pos) { //添加第pos条团购条目信息 string query; int link_id; MD5 md5 = new MD5CryptoServiceProvider(); ; //XmlNode oneUrl = lashouDocument.DocumentElement.ChildNodes[pos]; oneUrl oneUrl = xmlparse.getOneUrl(pos); StatisticOutput sta = staContext.statistic(oneUrl); Console.WriteLine("Insert the data to the database...."); query = "insert into links (site_id, url, title, description) values(5, \"" + sta.url + "\",\"" + sta.title + "\",\"" + sta.description + "\")"; cmd = new MySQLDriverCS.MySQLCommand(query, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); query = "select link_id from links where url = \"" + sta.url + "\""; cmd = new MySQLDriverCS.MySQLCommand(query, conn); IDataReader dt = cmd.ExecuteReader(); link_id = Convert.ToInt32(dt.GetSchemaTable().Rows[0]["link_id"]); foreach (DictionaryEntry de in sta.keywordList) { int keyword_id = 0; query = "select keyword_id from keywords where keyword = \"" + de.Key + "\""; cmd = new MySQLDriverCS.MySQLCommand(query, conn); dt = cmd.ExecuteReader(); if (dt.GetSchemaTable().Rows.Count == 0) { query = "insert into keywords (keyword) values (\"" + de.Key + "\")"; cmd = new MySQLDriverCS.MySQLCommand(query, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); query = "select keyword_id from keywords where keyword = \"" + de.Key + "\""; cmd = new MySQLDriverCS.MySQLCommand(query, conn); dt = cmd.ExecuteReader(); keyword_id = Convert.ToInt32(dt.GetSchemaTable().Rows[0]["keyword_id"]); } else keyword_id = Convert.ToInt32(dt.GetSchemaTable().Rows[0]["keyword_id"]); byte[] hash = md5.ComputeHash(System.Text.Encoding.Default.GetBytes(de.Key.ToString())); string flag; switch (hash[0] >> 4) { case 10: flag = "a"; break; case 11: flag = "b"; break; case 12: flag = "c"; break; case 13: flag = "d"; break; case 14: flag = "e"; break; case 15: flag = "f"; break; default: flag = (hash[0] >> 4).ToString(); break; } query = "insert into link_keyword" + flag + "(link_id, keyword_id, weight, time, feat, discount) values (" + link_id + "," + keyword_id + "," + de.Value + "," + sta.time + "," + sta.feat + "," + sta.discount + ")"; cmd = new MySQLDriverCS.MySQLCommand(query, conn); cmd.ExecuteNonQuery(); cmd.Dispose(); } Console.WriteLine("Write one link sucessfully!"); return true; }
private void Gbk() { MySQLCommand cmd = new MySQLCommand("set names gbk", conn); int r=cmd.ExecuteNonQuery(); }
private void Open() { //连接 conn = new MySQLConnection(connectionString.AsString); //打开 conn.Open(); //解决乱码 Gbk(); //输入命令 cmd = new MySQLCommand(sqlString, conn); }
//命令 private void Command() { cmd = new MySQLCommand(); cmd.Connection = conn; }