JDBC简介

JDBC常用接口和类
 DriverManager
 Connection
 Statement
 PrenaredStatement
 CallableStatement
 ResultSet
 
JDBC编程步骤  6步
 加载数据库驱动（jar文件）
Class.forname();
 获得数据库连接 
Connection conn = DriverManager.getConnection("","","");
 创建语句
String sql = select * from 表名;
Statement stat = conn.createStatement();
 执行查询
ResultSet rs = stat.executeQuery();
 遍历结果集
while(rs.next()){
String id = rs.getString("id");
System.out.println("id = "+ id);
}
 关闭数据库连接
if(conn!=null){
conn.close();
}
实例
 查询用户信息


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class DBUtil {


public Connection getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
return DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root", "root");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return null;
}
public void closeConnection(Connection conn){
if(conn!=null){  
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}


import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


import com.maker.util.DBUtil;


public class Tester {
public static void main(String[] args) {
Tester test = new Tester();
test.list();
}
public void list(){
DBUtil util = new DBUtil();
Connection conn = util.getConnection();
String sql ="select * from t_student";

try {
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery(sql);
while(rs.next()){
String id = rs.getString(1);
String name = rs.getString(2);
System.out.println(id+" "+name);
}

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


}
}