JDBC连接数据库
连接数据库后的增删改
1.驱动加载
Class.forName("com.mysql.cj.jdbc.Driver");
2.通过DriverManger获取连接
//URL:协议 IP 端口 目标(目标:库名)? 时区(serverTimezone=GMT)
String url = "jdbc:mysql://localhost:3306/数据库名?
String user = "root"; //用户名
String password= "123456"; //密码
//获取连接
Connection conn = DriverManger.getConnection(url,user,password);
3.执行创建SQL语句的对象
3.1创建SQL语句
String sql = " ";
3.2执行SQL语句
int ret = stm.executeUpdate(sql);
3.3判断
if(ret>0){
System.out.println(" ");
}else{
System.out.println(" ");
}
4.释放资源
stm.close();
conn.close();
连接数据库后的查询
//1.加载驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//2.获取连接
String url = "jdbc:mysql://localhost:3306/数据库名;
String user = "root"; //用户名
String password = "123456"; //密码
Connection conn = DriverManager.getConnection(url, user, password);
//3.创建SQL语句的执行对象
Statement stm = conn.createStatement();
//3.1创建SQL语句
String sql = "select * from 表名";
//3.2执行完查询的SQL语句得到一个ResultSet对象
ResultSet rs = stm.executeQuery(sql);
//3.3解析ResultSet对象
if(rs!=null) {
while(rs.next()) {
int sid = rs.getInt("sid");
String sname = rs.getString("sname");
Date birthday = rs.getDate("birthday");
String ssex = rs.getString("ssex");
String banjibianhao = rs.getString("classid");
System.out.println("ID:"+sid+",姓名:"+sname+",生日:"
+birthday+",性别:"+ssex+",班号:"+banjibianhao);
}
}
//4.释放资源
rs.close();
stm.close();
conn.close();