mybatis工程搭建

准备数据源

示例

drop database if exists mybatis_demo;

create database mybatis_demo;

use mybatis_demo;

create table user (

id int auto_increment primary key,

username varchar(20),

age int,

score int

);

insert into user (id, username, age, score) values

(1,‘peter‘, 18, 100), (2,‘pedro‘, 24, 200),

(3,‘jerry‘, 28, 500), (4,‘mike‘, 12, 300),

(5,‘tom‘, 27, 1000);

引入MySQL驱动包

<dependencies>

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

    <dependency>

        <groupId>mysql</groupId>

        <artifactId>mysql-connector-java</artifactId>

        <version>8.0.23</version>

    </dependency>

</dependencies>

public class JDBCDemo {

public static void main(String[] args) throws Exception {

Class.forName("com.mysql.cj.jdbc.Driver");

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mybatis_demo", "root", "root");

PreparedStatement preparedStatement = connection.prepareStatement("select * from user WHERE id = ?");

preparedStatement.setInt(1, 1);

ResultSet resultSet = preparedStatement.executeQuery();

while (resultSet.next()) {

System.out.println("username: " + resultSet.getString("username"));

System.out.println("age: " + resultSet.getString("age"));

}

resultSet.close();

preparedStatement.close();

connection.close();

}

}

<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->

<dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

<version>3.5.6</version>

</dependency>

<!-- https://mvnrepository.com/artifact/ch.qos.logback/logback-classic -->

<dependency>

<groupId>ch.qos.logback</groupId>

<artifactId>logback-classic</artifactId>

<version>1.3.0-alpha5</version>

<scope>test</scope>

</dependency>

用代码实现删除JDBC连接及操作数据库

@SuppressWarnings({"SqlResolve", "SqlNoDataSourceInspection", "Duplicates"})

public class StartNoXml {

    public static void main(String[] args) throws SQLException {

        JdbcTransactionFactory jdbcTransactionFactory = new JdbcTransactionFactory();

        PooledDataSource dataSource =

new PooledDataSource(

                "com.mysql.cj.jdbc.Driver", "jdbc:mysql://localhost:3306/mybatis_demo?useSSL=false",

                "root",

                "root");

Environment environment = new Environment.Builder("development")

                .transactionFactory(jdbcTransactionFactory)

                .dataSource(dataSource).build();

Configuration configuration = new Configuration(environment);

        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);

        SqlSession session = sqlSessionFactory.openSession();

PreparedStatement preStatement = session

.getConnection()

.prepareStatement("SELECT * FROM user WHERE id = ?");

preStatement.setInt(1, 1);

ResultSet result = preStatement.executeQuery();

while (result.next()) {

System.out.println("username: " + result.getString("username"));

System.out.println("age: " + result.getString("age"));

}

session.close();

}

}

mybatis工程搭建

原文：https://www.cnblogs.com/wph021/p/14616482.html