access操作mysql_Access数据库操作

classAccessDataBase

{

String connstring= null;publicAccessDataBase()

{//connstring = System.Environment.CurrentDirectory + @"\config.ini";//ini.getDataBaseString();

connstring = "Provider=Microsoft.Ace.OleDb.12.0;";

connstring+= "Data Source=" + AppDomain.CurrentDomain.BaseDirectory + @"\AccessDatabase.accdb;";//connstring += "Data Source="+System.Environment.CurrentDirectory+@"\AccessDatabase.accdb;";

connstring += "Persist Security Info=False;";

}public intbackUpDataBase()

{return 0;

}public void saveToDatabase(string sqltext,DataTable table,stringtablename)

{

}//执行没有返回值的SQL语句，如insert,update,delete

public int executeSql_NoReturn(stringstrcmd)

{

OleDbConnection conn= newOleDbConnection(connstring);

OleDbCommand oprating= newOleDbCommand(strcmd, conn);try{if (conn.State !=ConnectionState.Open)

conn.Open();object obj =oprating.ExecuteNonQuery();return 0;

}catch{return -1;

}finally{

conn.Close();

}

}//返回查询所返回的结果集中第一行的第一列或空引用(如果结果集为空)

public string executeSql_GetCell(stringstrcmd)

{

OleDbConnection conn= newOleDbConnection(connstring);

OleDbCommand oprating= newOleDbCommand(strcmd, conn);try{if (conn.State !=ConnectionState.Open)

conn.Open();object obj =oprating.ExecuteScalar();if (obj != null)returnobj.ToString();else

return null;

}catch{//MessageBox.Show("SQL数据格式错误",title,MessageBoxButtons.OK, MessageBoxIcon.Information);

return "DataFormattingError";

}finally{

conn.Close();

}

}//绑定数据源，用于输出数据集

public DataTable executeSql_GetDataSet(stringstrcmd)

{

OleDbConnection conn= newOleDbConnection(connstring);

OleDbCommand oprating= newOleDbCommand(strcmd, conn);

OleDbDataReader myDataReader= null;

DataTable table= newDataTable();try{if (conn.State !=ConnectionState.Open)

conn.Open();

myDataReader=oprating.ExecuteReader();

table.Load(myDataReader);returntable;

}catch{return null;

}finally{

conn.Close();

}

}public int ImagOper(string strcmd,byte[] Photograph,byte[] FingerPrint0,byte[] FingerPrint1)

{

StringBuilder strSql= newStringBuilder();

OleDbConnection conn= newOleDbConnection(connstring);

strSql.Append(strcmd);try{if (conn.State !=ConnectionState.Open)

conn.Open();

OleDbCommand cmd= newOleDbCommand(strSql.ToString(), conn);if (Photograph != null)

cmd.Parameters.Add("@Photograph", OleDbType.Binary).Value =Photograph;if (FingerPrint0 != null)

cmd.Parameters.Add("@FingerPrint0", OleDbType.Binary).Value =FingerPrint0;elsecmd.Parameters.Add("@FingerPrint0", OleDbType.Binary).Value = new byte[1024];if (FingerPrint1 != null)

cmd.Parameters.Add("@FingerPrint1", OleDbType.Binary).Value =FingerPrint1;elsecmd.Parameters.Add("@FingerPrint1", OleDbType.Binary).Value = new byte[1024];

cmd.ExecuteNonQuery();return 0;

}catch(Exception e)

{if( e isOleDbException)return -3;else

return -1;

}finally{

conn.Close();

}

}

}