JDBC

数据库增删改查

DBUtil

public class DBUtil {
    public static Connection getConnection() throws ClassNotFoundException, SQLException {

        // 加载驱动
        Class.forName("com.mysql.jdbc.Driver");
        //创建链接
        Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/wzsxy","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();
        }
    }

数据库查询

public class Find {

    public static void main(String[] args) throws 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.print(resultSet.getInt(1)+" ");
                System.out.print(resultSet.getString(2)+" ");
                System.out.print(resultSet.getString(3)+" ");
                System.out.println("");
            }
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }finally {
            //关闭资源
            DBUtil.closeAll(resultSet,statement,connection);
        }

        

    }
}

插入

public class insert {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Connection connection = null;
        PreparedStatement statement = null;
        try{
            connection= DBUtil.getConnection();
            //写sql语句
            String sql ="insert into tb_user(username,password) values('QHQ','123456')";

            //获得statement对象
            statement=connection.prepareStatement(sql);
            //处理结果集
            statement.executeUpdate();

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

    }
}

删除

public class Delete {
    public static void main(String[] args) throws SQLException {
        Connection connection = null;
        PreparedStatement statement = null;
        try{
            connection=DBUtil.getConnection();
            //写sql语句
            String sql ="delete from tb_user where id=7";
            //获得statement对象
            statement=connection.prepareStatement(sql);
            //执行sql得到结果集
            statement.executeUpdate();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }finally {
            DBUtil.closeAll(null,statement,connection);
        }

    }
}

修改

public class Update {
    public static void main(String[] args) throws SQLException {
        Connection connection = null;
        PreparedStatement statement = null;
        try{
            connection=DBUtil.getConnection();
            //写sql语句
            String sql ="update tb_user set password='123654' where id=5";
            //获得statement对象
            statement=connection.prepareStatement(sql);
            //处理结果集
            statement.executeUpdate();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }finally {
            //关闭资源
            DBUtil.closeAll(null,statement,connection);
        }


    }
}

数据库