java数据库连接 实现增删改查

java数据库连接实现增删改查

数据库连接类

package com.xgmzhn.web.work1.util;

import java.sql.*;

public class DBUtil {
    public static Connection getConnection() throws SQLException, ClassNotFoundException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        //创建连接
        Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/springboot?useSSL=false&serverTimezone=UTC","root","123456");

        return connection;
    }

    public  static void closeAll(ResultSet resultSet, Statement statement,Connection connection) throws SQLException {
        if(resultSet != null){
            resultSet.close();
        }
        if (statement != null){
            statement.close();
        }
        if(connection != null){
            connection.close();
        }
    }
}

删

package com.xgmzhn.web.work1;

import com.xgmzhn.web.work1.util.DBUtil;

import java.sql.*;

public class Delete {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        Connection connection = DBUtil.getConnection();
        //写sql语句
        String sql = "DELETE from tb_user where user_id=1";
        //获得statement对象
        PreparedStatement statement =connection.prepareStatement(sql);
        //执行sql得到的结果集
        statement.executeUpdate();
        //关闭资源
        DBUtil.closeAll(null,statement,connection);
    }
}

查

package com.xgmzhn.web.work1;

import com.xgmzhn.web.work1.util.DBUtil;

import java.sql.*;

public class Find {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection connection=null;
        PreparedStatement statement=null;
        ResultSet resultSet=null;
        try{
            connection = DBUtil.getConnection();
            //写sql语句
            String sql = "select * from tb_user";
            //获得statement对象
            statement =connection.prepareStatement(sql);
            //执行sql得到的结果集
            resultSet = statement.executeQuery();
            //处理结果集
            while(resultSet.next()){
                System.out.println(resultSet.getInt(1));
                System.out.println(resultSet.getString(2));
                System.out.println(resultSet.getString(3));
            }

        }catch (Exception e){
            e.printStackTrace();
        }finally {
            //关闭资源
            DBUtil.closeAll(resultSet,statement,connection);
        }
    }
}

增

package com.xgmzhn.web.work1;

import com.xgmzhn.web.work1.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Insert {
    public static void main(String[] args) throws SQLException {
        Connection connection=null;
        PreparedStatement statement=null;
        ResultSet resultSet=null;
        try{
            connection = DBUtil.getConnection();
            //写sql语句
            String sql = "insert tb_user value(null,'smw','123456')";
            //获得statement对象
            statement =connection.prepareStatement(sql);
            //执行sql得到的结果集
            int z=statement.executeUpdate();
            System.out.println(z);

        }catch (Exception e){
            e.printStackTrace();
        }finally {
            //关闭资源
            try{
                DBUtil.closeAll(null,statement,connection);
            } catch (Exception e){
                e.printStackTrace();
            }
        }
    }
}

改

package com.xgmzhn.web.work1;

import com.xgmzhn.web.work1.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Update {
    public static void main(String[] args)  {
        Connection connection=null;
        PreparedStatement statement=null;
        ResultSet resultSet=null;
        try{
            connection = DBUtil.getConnection();
            //写sql语句
            String sql = "update tb_user set user_pwd='123456789' where user_name='smw'";
            //获得statement对象
            statement =connection.prepareStatement(sql);
            //执行sql得到的结果集
            int z=statement.executeUpdate();
            System.out.println(z);

        }catch (Exception e){
            e.printStackTrace();
        }finally {
            //关闭资源
            try{
                DBUtil.closeAll(null,statement,connection);
            } catch (Exception e){
                e.printStackTrace();
            }
        }
    }
}