- package cn.com.JDBC;
- import java.sql.Connection;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class CRUD {
- public static void main(String[] args) throws SQLException {
- // TODO Auto-generated method stub
- //create();
- //update();
- delete();
- read();
- }
- static void delete() throws SQLException
- {
- Connection conn=null;
- Statement st=null;
- ResultSet resultset=null;
- try {
- //2.建立连接
- conn=JdbcUtils.getConnection();
- //单例设计模式
- conn=JdbcUtilsSingle.getInstance().getConnection();
- //3.创建语句
- st=conn.createStatement();
- //4.执行语句
- String sql="delete from user where id>5";
- int i=st.executeUpdate(sql);
- System.out.println("i="+i);
- } finally
- {
- JdbcUtils.free(resultset, st, conn);
- }
- }
- static void update() throws SQLException
- {
- Connection conn=null;
- Statement st=null;
- ResultSet resultset=null;
- try {
- //2.建立连接
- conn=JdbcUtils.getConnection();
- //单例设计模式
- conn=JdbcUtilsSingle.getInstance().getConnection();
- //3.创建语句
- st=conn.createStatement();
- //4.执行语句
- String sql="update user set money=money+20";
- int i=st.executeUpdate(sql);
- System.out.println("i="+i);
- } finally
- {
- JdbcUtils.free(resultset, st, conn);
- }
- }
- static void create() throws SQLException
- {
- Connection conn=null;
- Statement st=null;
- ResultSet resultset=null;
- try {
- //2.建立连接
- conn=JdbcUtils.getConnection();
- //单例设计模式
- conn=JdbcUtilsSingle.getInstance().getConnection();
- //3.创建语句
- st=conn.createStatement();
- //4.执行语句
- String sql="insert into user(name,birthday,money) values('wy','2011-09-23','2894656')";
- int i=st.executeUpdate(sql);
- System.out.println("i="+i);
- } finally
- {
- JdbcUtils.free(resultset, st, conn);
- }
- }
- static void read() throws SQLException
- {
- Connection conn=null;
- Statement st=null;
- ResultSet resultset=null;
- try {
- //2.建立连接
- conn=JdbcUtils.getConnection();
- //单例设计模式
- conn=JdbcUtilsSingle.getInstance().getConnection();
- //3.创建语句
- st=conn.createStatement();
- //4.执行语句
- resultset=st.executeQuery("select id,name,birthday,money from user");
- //5.处理结果
- while(resultset.next())
- {
- System.out.println(resultset.getObject("id"));
- System.out.println(resultset.getObject("name"));
- System.out.println(resultset.getObject("birthday"));
- System.out.println(resultset.getObject("money"));
- }
- } finally
- {
- JdbcUtils.free(resultset, st, conn);
- }
- }
- }
- package cn.com.JDBC;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class JdbcUtils
- {
- private static String url="jdbc:mysql://localhost:3306/jdbc";
- private static String user="root";
- private static String password="123";
- private JdbcUtils()
- {
- }
- static
- {
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- }
- catch(ClassNotFoundException e)
- {
- throw new ExceptionInInitializerError(e);
- }
- }
- public static Connection getConnection() throws SQLException
- {
- return DriverManager.getConnection(url, user, password);
- }
- public static void free(ResultSet resultset,Statement st,Connection conn)
- {
- //6.释放资源
- try{
- if(resultset!=null)
- resultset.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- finally
- {
- try
- {
- if(st!=null)
- st.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- finally
- {
- if(conn!=null)
- try {
- conn.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
- }
- }
JDBC操作数据库
最新推荐文章于 2023-02-06 08:14:46 发布