使用JDBC实现数据库的连接

Mybatis

JDBC

jdbc实现步骤

使用jdbc实现数据库的连接

public class JDBCDemoTest {
    private Connection conn;
    private PreparedStatement statement;
    private ResultSet resultSet;

    @Test
    public void jdbcTest(){
        try{
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //获取连接
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/abc?characterEncoding=utf-8","root","root");
            //定义SQL语句
            String sql = "select * from student";
            //获取预处理
            statement = conn.prepareStatement(sql);
            //执行语句，将SQL放松给数据库
            resultSet = statement.executeQuery();
            //处理结果
            while (resultSet.next()){
                System.out.println(resultSet);
            }
        }catch (Exception e){
            e.printStackTrace();
        }finally {
            try {
                resultSet.close();
                statement.close();
                conn.close();
            }catch (Exception e){
                e.printStackTrace();
            }

        }

    }
}