增删减查

增：

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

public class Add {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection connection = DBUtil.getConnection();
        String sql = "insert into tb_user(username,password) value ('123','123')";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.executeUpdate();
        DBUtil.closeAll(null,statement,connection);
    }
}

删：

public class Delete {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection connection = DBUtil.getConnection();
        //3.写SQL语句
        String sql = "delete from tb_user where id = 1";
        PreparedStatement statement = connection.prepareStatement(sql);
        statement.executeUpdate();
        DBUtil.closeAll(null,statement,connection);
    }
}

查：

public class Find {
    public static void main(String[] args) {
    }
    public List<User> findAll(){
        Connection connection= null;
        List<User> userList=new ArrayList<>();
        PreparedStatement statement=null;
        ResultSet resultSet =null;
        try {
            connection = DBUtil.getConnection();
            String sql = "select * from tb_user";
            statement = connection.prepareStatement(sql);
            resultSet = statement.executeQuery();
            while (resultSet.next()){
                User user=new User();
                user.setId(resultSet.getInt());
                user.setUsername(resultSet.getString());
                user.setPassword(resultSet.getString());
                userList.add(user);
            }
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }catch (SQLException throwables){
            throwables.printStackTrace();
        }finally {
            try {
                DBUtil.closeAll(resultSet,statement,connection);
            }catch (SQLException throwables){
                throwables.printStackTrace();
            }
        }
        return userList;
    }

}