# mybatis-study

**Repository Path**: aopmin/mybatis-study

## Basic Information

- **Project Name**: mybatis-study
- **Description**: mybatis
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-02-07
- **Last Updated**: 2025-02-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README


## 1、原生jdbc写法
jdbc缺点:
   -  比较硬编码(每次都写加载驱动、获取数据库连接、执行sql语句、释放资源)
   - java代码和sql语句耦合在一起。
```java
public class JDBCTest {
    @Test
    public void test() throws Exception {
        // 1.加载数据库驱动
        // 新版mysql驱动不需要显示加载驱动类了
        // Class.forName("com.mysql.cj.jdbc.Driver");

        // 2.获取数据库连接
        String url = "jdbc:mysql://localhost:3307/mybatis?useSSL=false&useUnicode=true&characterEncoding=utf-8";
        String username = "root";
        String password = "123456";
        Connection conn = DriverManager.getConnection(url, username, password);
        // 3.执行SQL语句
        PreparedStatement ps = conn.prepareStatement("select * from user");

        // 4.处理结果
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
            String name = rs.getString("name");
            String age = rs.getString("age");
            String email = rs.getString("email");
            String printStr = StrUtil.format("name:{} , age:{} , email:{}", name, age, email);
            System.out.println(printStr);
        }

        // 5.释放资源
        rs.close();
        ps.close();
        conn.close();
    }
}
```