首先要下载Connector/J地址:http://www.mysql.com/downloads/connector/j/
这是MySQL官方提供的连接方式:
解压后得到jar库文件,需要在工程中导入该库文件。或者是将mysql-connector-java-5.1.38-bin.jar JAR包,然后放进....\Java\jdk1.8.0_73\jre\lib\ext 重启eclispe 就可以在JRE系统库中看到.
<span style="color:#ff0000;">i</span>mport java.sql.*;
public class DBHelper {
public static final String url = "jdbc:mysql://127.0.0.1/xxpt";
public static final String name = "com.mysql.jdbc.Driver";
public static final String user = "lidequan";
public static final String password = "lidequan";
public Connection conn = null;
public PreparedStatement pst = null;
public DBHelper() {
if(conn == null){
try {
Class.forName(name).newInstance();//指定连接类型
conn = DriverManager.getConnection(url, user, password);//获取连接
} catch (Exception e) {
e.printStackTrace();
}
}
}
public void query(String sql){
try{
pst=conn.prepareCall(sql);
ResultSet s=pst.executeQuery();
while(s.next()){
System.out.println(s.getString("leader_pic"));
System.out.println(s.getString(1));
System.out.println(s.getString(2));
System.out.println(s.getString(3));
}
}catch(Exception e){
e.printStackTrace();
}
}
public void close() {
try {
this.conn.close();
this.pst.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public class Student {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
DBHelper db1 = new DBHelper();
db1.query("SELECT * FROM Leader;");
db1.close();
}
}
执行结果如下:
总结: 在使用JDBC连接数据库的时候,首先获取连接对象Connection,然后执行相应的预查询获取PreparedStatement对象,最后获取结果集对象ResultSet,然后从结果集对象中读取查询的数据。
最后关闭数据库连接。