目录
关键字
Class.forName DriverManager.getConnection prepareStatement executeQuery next getObject
数据库连接类
public static Connection getconnection() throws Exception{ Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/cgb2107"; Connection c = DriverManager.getConnection(url,"root","root"); return c; }
关闭资源类
public static void close(Connection c,PreparedStatement p,ResultSet r){ if(c!=null){ try { c.close(); } catch (SQLException e) { e.printStackTrace(); } } if(p!=null){ try { p.close(); } catch (SQLException e) { e.printStackTrace(); } } if(r!=null){ try { r.close(); } catch (SQLException e) { e.printStackTrace(); } } }
使用JDBC查询数据库中的数据
//1,定义连接返回结果、传输器、结果集的变量 Connection c = null; PreparedStatement p = null; ResultSet r = null; //2.使用数据库连接类 try { c = getconnection(); //3.准备SQL语句 String sql = "select * from emp"; //4.获取传输器 p = c.prepareStatement(sql); //5.通过传输器执行查询SQL,并返回值 r = p.executeQuery(); //6.判断得到的值有没有数据 while (r.next()){ //7.循环遍历得到的列的值 for(int i = 1; i<9;i++) { //8.用getObject()获取每个字段的值 Object object1 = r.getObject(i); System.out.println(object1); } } }catch(Exception e ){ e.printStackTrace(); }finally{ close(c,p,r); }
使用JDBC修改、删除、增加数据库中的数据
//1,定义连接返回结果、传输器、结果集的变量 Connection c = null; PreparedStatement p = null; ResultSet r = null; //2.使用数据库连接类 try { c = getconnection(); //3.准备SQL语句 String sql = "insert into dept values (null,'csc','四区')"; //4.获取传输器 p = c.prepareStatement(sql); //5.通过传输器执行查询SQL,并返回值---更改查询删除只会返回影响了几行 int s = p.executeUpdate(); System.out.println(s); }catch(Exception e ){ e.printStackTrace(); }finally{ close(c,p,r); }
判断用户是否登录成功
//1,定义连接返回结果、传输器、结果集的变量 Connection c = null; PreparedStatement p = null; ResultSet r = null; //2.使用数据库连接类 try { c = getconnection(); //3.准备SQL骨架---?为占位符 String sql = "select * from user where name = ? and password = ?"; //4.获取传输器 PreparedStatement p = c.prepareStatement(sql); //5.给SQL骨架设置参数 p.setString(1,name); p.setString(2,password); //6.执行拼接好的SQL ResultSet r = p.executeQuery(); //7.判断是否查到了数据 if(r.next()){ System.out.println("恭喜您登录成功"); }else { System.out.println("恭喜您登录失败"); } }catch(Exception e ){ e.printStackTrace(); }finally{ close(c,p,r); }