大致可以分为以下的几个步骤:
package JUtils;
import java.sql.*;
public class JUtilsDemo01 {
public static void main(String[] args) {
Connection con = null;
Statement stmt= null;
ResultSet rs = null;
try {
//1注册数据库驱动
Class.forName(“com.mysql.jdbc.Driver”);
//2创建数据库连接对象--url表示本地数据库的路径--user本地数据库的用户名--password本地数据库的密码
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
//3创建sql语句执行对象
stmt = con.createStatement();
//4执行sql语句
rs = stmt.executeQuery("select * from USER ");
//5处理结果集--rs一开始指向表的第一行上面
while (rs.next()){
System.out.println(rs.getInt("id")+" "+rs.getString("name")+" "+rs.getString("password"));
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
//6释放资源
if (rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
//将对象置空,让垃圾回收器回收
rs = null;
}
if (stmt != null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
//将对象置空,让垃圾回收器回收
stmt = null;
}
if (con != null){
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
//将对象置空,让垃圾回收器回收
con = null;
}
}
}
}