java jdbc简单用法

package ordinaryClass;

import java.sql.*;

/**
 * @author 图南
 * @date 2022-5-13
 * @version 1.0
 * @description:一个简单的jdbc测试类
 */
public class testJdbc {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        //配置信息
        //?useUnicode=true&characterEncoding=gbk解决中文乱码
        String url = "jdbc:mysql://localhost:3306/users?useUnicode=true&characterEncoding=gbk";
        String username = "your username";
        String password = "your password";
        //1.加载驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        //2.连接数据库,代表数据库
        Connection connection = DriverManager.getConnection(url, username, password);
        //3.向数据库发送sql的对象statement:CRUD
        Statement statement = connection.createStatement();
        //4.编写sql
        //查询user表中的所有数据
        String sql = "select * from user;";
        //5.执行sql,返回一个ResultSet
        ResultSet query = statement.executeQuery(sql);
        //6.遍历ResultSet
        while (query.next()) {
            System.out.println("id:"+query.getString("id") + " " + "name:"+query.getString("name")
                    + " " + "age"+query.getString("age"));
        }
        //根据id查询
        String sql2 = "select * from user where id=1;";
        PreparedStatement preparedStatement = connection.prepareStatement(sql2);
        ResultSet query2 = preparedStatement.executeQuery();
        while (query2.next()) {
            System.out.println("id:"+query2.getString("id") + " " + "name:"+query2.getString("name")
                    + " " + "age"+query2.getString("age"));
        }
        //插入数据
        //String sql3 = "insert into user(id,`name`,age) values(?,?,?)";
        //PreparedStatement preparedStatement2 = connection.prepareStatement(sql3);
        //preparedStatement2.setInt(1,3);
        //preparedStatement2.setString(2,"dr");
        //preparedStatement2.setInt(3,20);
        //int i = preparedStatement2.executeUpdate();
        //if (i>0){
        //    System.out.println("插入成功");
        //}
        //更新数据
        String sql4 = "update user set name=?,age=? where id=?";
        PreparedStatement preparedStatement3 = connection.prepareStatement(sql4);
        preparedStatement3.setString(1,"drrrr");
        preparedStatement3.setInt(2,22222);
        preparedStatement3.setInt(3,1);
        int i = preparedStatement3.executeUpdate();
        if (i>0){
            System.out.println("更新成功");
        }
        //删除数据
        String sql5 = "delete from user where id=?";
        PreparedStatement preparedStatement4 = connection.prepareStatement(sql5);
        preparedStatement4.setInt(1,1);
        int i2 = preparedStatement4.executeUpdate();
        if (i2>0){
            System.out.println("删除成功");
        }


        //7.关闭资源
        query2.close();
        query.close();
        statement.close();
        connection.close();

    }
}