一、到mysql.com下载jdbc驱动,解压并将jar文件引入到工程中。
二、查询示例
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public static void main(String[] args) {
String sqltxt = "SELECT * FROM TABLE_TEST";
Connection connection = null;
Statement statement = null;
ResultSet rSet = null;
try{
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql//localhost:3306/test_db","root","password");
statement = connection.createStatement();
rSet = statement.executeQuery(sqltxt); executeUpdate(sqltxt);//实现更新,增删改
while(rSet.next()){
System.out.println(rSet.getInt("id"));
System.out.println(rSet.getString("name"));
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
try {
rSet.close();
} catch (Exception e2) {
}
try {
statement.close();
} catch (Exception e3) {
}
try {
connection.close();
} catch (Exception e4) {
}
}
}