package utils; import java.io.IOException; import java.io.InputStream; import java.sql.*; import java.util.Properties; public class jdbcutils { private static String driver = null; private static String url = null; private static String username = null; private static String password = null; static { try{ InputStream in=jdbcutils.class.getClassLoader().getResourceAsStream("db.properties"); Properties properties=new Properties(); properties.load(in); driver =properties.getProperty("driver"); url =properties.getProperty("url"); username =properties.getProperty("username"); password =properties.getProperty("password"); Class.forName(driver); }catch(IOException e){ e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } } //获取连接 public static Connection getConnection() throws SQLException{ return DriverManager.getConnection(url,username,password); } //释放连接 public static void release(Connection conn, Statement st, ResultSet rs){ if(rs!=null){ try{ rs.close(); }catch (SQLException e){ e.printStackTrace(); } } if(st!=null){ try{ st.close(); }catch (SQLException e){ e.printStackTrace(); } } if(conn!=null){ try{ conn.close(); }catch (SQLException e){ e.printStackTrace(); } } } }
增
package utils; import java.sql.Statement; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; public class TestInsert { public static void main(String[] args) { Connection conn = null; Statement st = null; ResultSet rs = null; try{ conn =jdbcutils.getConnection();//获得数据库连接 st = conn.createStatement();//获得sql的执行对象 String sql = "INSERT INTO users(id,`NAME`,`PASSWORD`,`email`,`birthday`)\n"+ "VALUES(4,'shuiguozai','123456','29167035@qq.com','2020-01-01')"; int i = st.executeUpdate(sql); if (i>0){ System.out.println("插入成功"); } }catch(SQLException e){ e.printStackTrace(); }finally { jdbcutils.release(conn,st,rs); } } }
删
package utils; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestDelete { public static void main(String[] args) { Connection conn = null; Statement st = null; ResultSet rs = null; try{ conn =jdbcutils.getConnection();//获得数据库连接 st = conn.createStatement();//获得sql的执行对象 String sql = "DELETE FROM users WHERE id = 4"; int i = st.executeUpdate(sql); if (i>0){ System.out.println("删除成功"); } }catch(SQLException e){ e.printStackTrace(); }finally { jdbcutils.release(conn,st,rs); } } }
改
package utils; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestUpdate { public static void main(String[] args) { Connection conn = null; Statement st = null; ResultSet rs = null; try{ conn =jdbcutils.getConnection();//获得数据库连接 st = conn.createStatement();//获得sql的执行对象 String sql = "UPDATE users SET `NAME`= 'shuiguo',`email`='263433263@qq.com' WHERE id =1"; int i = st.executeUpdate(sql); if (i>0){ System.out.println("更新成功!"); } }catch(SQLException e){ e.printStackTrace(); }finally { jdbcutils.release(conn,st,rs); } } }
c查
package utils; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestSelect { public static void main(String[] args) { Connection conn = null; Statement st = null; ResultSet rs = null; try { conn = jdbcutils.getConnection();//获得数据库连接 st = conn.createStatement();//获得sql的执行对象 String sql = "select * from users where id =1"; rs = st.executeQuery(sql); while(rs.next()) { System.out.println(rs.getString("NAME")); } } catch (SQLException e) { e.printStackTrace(); } finally { jdbcutils.release(conn, st, rs); } } }