创建mybatis项目
时间: 2023-10-31 07:57:46 浏览: 50
创建MyBatis项目的步骤如下:
1. 首先,确保你已经安装了Java开发环境和Maven构建工具。
2. 打开命令行终端或者使用IDE(如IntelliJ IDEA)创建一个新的Maven项目。可以使用以下命令创建一个基本的Maven项目:
```
mvn archetype:generate -DgroupId=com.example.myproject -DartifactId=myproject -DarchetypeArtifactId=maven-archetype-quickstart -DinteractiveMode=false
```
3. 进入项目文件夹,并打开`pom.xml`文件。在`<dependencies>`标签内添加MyBatis相关的依赖,例如:
```xml
<dependencies>
<!-- MyBatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<!-- MySQL JDBC驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.26</version>
</dependency>
<!-- 其他依赖... -->
</dependencies>
```
4. 创建一个名为`mybatis-config.xml`的文件,用于配置MyBatis。在该文件中,你可以配置数据库连接信息、Mapper扫描路径等。示例配置文件如下:
```xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mydatabase"/>
<property name="username" value="myusername"/>
<property name="password" value="mypassword"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/example/myproject/mapper/MyMapper.xml"/>
<!-- 其他Mapper文件... -->
</mappers>
</configuration>
```
5. 创建Mapper接口和对应的XML文件。Mapper接口定义了对数据库的操作方法,而XML文件提供了SQL语句的映射和具体的实现。示例Mapper接口和XML文件如下:
```java
package com.example.myproject.mapper;
import com.example.myproject.model.MyModel;
public interface MyMapper {
MyModel getById(int id);
void insert(MyModel model);
// 其他方法...
}
```
```xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.myproject.mapper.MyMapper">
<select id="getById" resultType="com.example.myproject.model.MyModel">
SELECT * FROM my_table WHERE id = #{id}
</select>
<insert id="insert">
INSERT INTO my_table (col1, col2) VALUES (#{col1}, #{col2})
</insert>
<!-- 其他SQL语句... -->
</mapper>
```
6. 在Java代码中使用MyBatis。你可以在代码中创建`SqlSessionFactory`和`SqlSession`对象,并通过`SqlSession.getMapper()`方法获取Mapper接口的实例,从而执行数据库操作。示例代码如下:
```java
import com.example.myproject.mapper.MyMapper;
import com.example.myproject.model.MyModel;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
public class MyBatisExample {
public static void main(String[] args) throws IOException {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
try (SqlSession session = sqlSessionFactory.openSession()) {
MyMapper mapper = session.getMapper(MyMapper.class);
MyModel model = mapper.getById(1);
System.out.println(model);
MyModel newModel = new MyModel();
newModel.setCol1("value1");
newModel.setCol2("value2");
mapper.insert(newModel);
session.commit();
}
}
}
```
以上就是创建一个基本的MyBatis项目的步骤。你可以根据自己的需求进行进一步的配置和开发。