如题:vs2012中如何连接mysql数据库,求大神指教,最好有代码示例。谢谢。
string strSql="";//数据库连接字符串
SqlConnection conn = new SqlConnection(strSql);
conn.Open();
这样就连接上了
string strSql = "数据库连接字符串";
SqlConnection conn = new SqlConnection(strSql);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "sql 语句";
cmd.ExecuteNonQuery();
就是这样子了。。。。
严格地来说,首先你必须加载第三方库MySql.Data.dll,然后在对应的位置输入以下代码
MySql.Data.MySqlClient.MySqlConnection conn;
string myConnectionString;
myConnectionString = "server=127.0.0.1;uid=root;" + "pwd=12345;database=test;";
try
{
conn = new MySql.Data.MySqlClient.MySqlConnection();
conn.ConnectionString = myConnectionString;
conn.Open();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show(ex.Message);
}
若还有不清楚或需要进一步了解,请加我微信号:chipembed 进行详聊。
JDBC有C++版本的SDK,下载一份吧
public ScheduleInfo query(int count) throws Exception {
// TODO Auto-generated method stub
String className = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String password = "tiger";
Class.forName(className);
Connection connection =null;
PreparedStatement preparedStatement =null;
ResultSet resultSet = null;
String sql = "SELECT * FROM emp";
connection = DriverManager.getConnection(url, user, password);
preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery(sql);
while(resultSet.next()){
System.out.println(resultSet.getString(1));
}
return null;
}