写个简单的JDBC

一个简单的jdbc连接数据库操作

1.引入maven依赖，也可以自己导入jar

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.15</version>
</dependency>

2.编码

package datasource.jdbc;

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

public class Jdbc {
    private static final String URL = "jdbc:mysql://localhost:3306/t_user?useUnicode=true&characterEncoding=UTF-8";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "123456";
    public static void main(String[] args) {
        try{
            //1.加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //2.获取数据库连接
            Connection conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
            //3.预编译sql
            String sql = "select * from t_user t where t.id =? and t.name=?";
            PreparedStatement preparedStatement = conn.prepareStatement(sql);
            preparedStatement.setString(1,"1");
            preparedStatement.setString(2,"张三");
            //4.执行sql操作
            ResultSet rs = preparedStatement.executeQuery();
            //5.处理返回结果
            while (rs.next()){
                String id = rs.getString("id");
                String title = rs.getString("name");
                System.out.println("id:"+id);
                System.out.println("name:"+title);
            }
            //6.关闭连接
            preparedStatement.close();
            conn.close();
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}