尝试JDBC增删改查

DBUtil工具包

package util;

import java.sql.*;

public class DBUtil {
    public static Connection getConnection() {
        Connection connection = null;
        try {
            //1.加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //2.创建连接
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/wzsxy", "root", "123456");

        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return connection;

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

增

import util.DBUtil;

import java.sql.*;

public class Add {
    public static void main(String[] args)  {
        Connection connection =  DBUtil.getConnection();
        //sql语句
        String sql = "insert into tb_user(id,username,password) values (?,?,?)";
        try {
            //获取statement对象
            PreparedStatement statement = connection.prepareStatement(sql);
            statement.setString(1,null);
            statement.setString(2,"sbwkb");
            statement.setString(3,"123456");
            //执行sql
            statement.executeUpdate();
            DBUtil.close(null,statement,connection);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

删

import util.DBUtil;

import java.sql.*;

public class Delect {
    public static void main(String[] args)  {
        Connection connection = DBUtil.getConnection();
        //sql语句
        String sql = "DELETE  from tb_user where username = 'sbwkb'";
        try {
            //获取statement对象
            PreparedStatement statement = connection.prepareStatement(sql);
            //执行sql
            statement.executeUpdate();
            DBUtil.close(null,statement,connection);
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}

改

import util.DBUtil;

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

public class Update {
    public static void main(String[] args) {
        Connection connection = DBUtil.getConnection();
        //sql语句
        String sql = "update tb_user set password = '11111' where username='sbwkb'";
        {
            try {
                //获取statement对象
                PreparedStatement statement = connection.prepareStatement(sql);
                //执行sql
                statement.executeUpdate();
                DBUtil.close(null,statement,connection);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

}

查

import util.DBUtil;

import java.sql.*;

public class Find {
    public static void main(String[] args) {
        Connection connection = DBUtil.getConnection();
        //sql语句
        String sql = "select * from tb_user";
        try {
            //获取statement对象
            PreparedStatement statement = connection.prepareStatement(sql);
            ResultSet resultSet = statement.executeQuery();
            while (resultSet.next()){
                System.out.println(resultSet.getInt(1));
                System.out.println(resultSet.getString(2));
                System.out.println(resultSet.getString(3));
            }
            DBUtil.close(resultSet,statement,connection);
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }
}

稍微修改一下能改成5个方法，顺便靠封装实现控制台输入。

效果图

增后

改后

删后