JDBC(java database connectivty java)数据库连接
sun公司的一种数据库访问规范
要用jdbc需要驱动jar
创建文件夹把mysql-connector-java-5.1.7-bin.jar放入
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBC{
public static void main(){
//这里涉及要代码块的变量生命周期的问题
Connection conn;
Statement st;
ResultSet rs;
try{
//1.注册驱动
DriverManager.registerDriver(new com.sql.jdbc.Driver());
//DriverManager.getConnection("jdbc:mysql://localhost/test?user=monty&password=greatsqldb");
//2.建立 参数1:协议+访问的数据库,参数2:用户名,参数3:密码
conn = DriverManager.getConnection("jdbc:mysql://localhost/student","root","root");
//3.创建statement,根数据库打交道,一定需要这个对象
st = conn.createStatement();
//4.执行查询
String sql = "select * from t_stu";
rs = st.executeQuery(sql);
//5.遍历查询
While(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println("id="+id+"===name="+name+"==age="+age);
}
}catch(SQLException e){
e.printStackTrace();
}finally{
JDBCUtil.release(conn,st,rs);
}
}
}