首页 > 代码库 > 使用Maven简单配置Mybatis
使用Maven简单配置Mybatis
1.新建一个Maven项目
2. 在pom.xml中进行配置，在pom.xml中配置的时候，需要网速好，当网速不是很好的时候，是加载不出Jar包的。
代码如下所示.
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.whl</groupId> <artifactId>MyBatis01</artifactId> <packaging>war</packaging> <version>0.0.1-SNAPSHOT</version> <name>MyBatis01 Maven Webapp</name> <url>http://maven.apache.org</url> <dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.4</version> </dependency> </dependencies> <build> <finalName>MyBatis01</finalName> </build> </project>
<dependencies>的文件配置参考http://mvnrepository.com/
如果不知如何添加，可在此链接中输入相应jar包的名称，然后选择正确的版本，就会有示例。
3.手动导入MySQL的jar包，因为网速不好，下载不了，故采用手动导入，然后右键该jar包，build path。
4.在resources下，新建mybatis-config.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.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/test" /> <property name="username" value="root" /> <property name="password" value="123456" /> </dataSource> </environment> </environments> <mappers> <mapper resource="com/whl/mybatis/userMapper.xml" /> </mappers> </configuration>
mappers中的映射要与下一步操作对应。
5.在Java文件夹下建立相应的包，并在此写相应的bean类，如下
package com.whl.mybatis;
public class User {
private int id;
private String username;
private String userpass;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserpass() {
return userpass;
}
public void setUserpass(String userpass) {
this.userpass = userpass;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", userpass=" + userpass + "]";
}
public User(int id, String username, String userpass) {
super();
this.id = id;
this.username = username;
this.userpass = userpass;
}
public User() {
super();
}
}
6.在Java文件下新建相关的包，新建一个userMapper.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="userMapper"> <!-- id是唯一标志符 --> <!-- parameterType参数类型，指明插入时使用的参数类型 --> <!-- useGeneratedKeys="true", 表示数据库的自动增长策略 --> <insert id="save" parameterType="com.whl.mybatis.User" useGeneratedKeys="true"> insert into user(username, password) values(#{username}, #{password}) </insert> <delete id="deleteById" parameterType="int"> delete from user where uid = #{value} </delete> <delete id="deleteByIds"> delete from user where uid in <foreach collection="list" item="uid" open="(" close=")" separator=","> #{uid} </foreach> </delete> <select id="likeByName" resultType="com.whl.mybatis.User" parameterType="string"> select * from user where username like ‘%${value}%‘ </select> <select id="findAll" resultType="com.whl.mybatis.User"> select uid, username, password from user </select> <select id="findById" parameterType="int" resultType="com.whl.mybatis.User"> select * from user where uid = #{value} </select> <update id="updateById" parameterType="com.whl.mybatis.User"> update user set username=#{username}, password=#{password} where uid = #{uid} </update> <!-- update user set username = case uid when #{u.uid} then #{u.username} end where uid in (...) --> <update id="updateUserBatch" parameterType="list"> update user set username = CASE uid <foreach collection="list" item = "u" separator=" "> when #{u.uid} then #{u.username} </foreach> end where uid in <foreach collection="list" item="user" open="(" separator="," close=")"> #{user.uid} </foreach> </update> </mapper>
7.测试：代码如下
package com.whl.mybatis.test; import java.io.InputStream; import java.util.ArrayList; import java.util.Collections; import java.util.List; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.ExecutorType; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; import org.junit.After; import org.junit.Before; import org.junit.Test; import com.whl.mybatis.User; public class TestMyBatis { private SqlSession s = null; private SqlSessionFactory ssf = null; @Before public void init(){ String resourcesStr = "mybatis-config.xml"; try { InputStream is = Resources.getResourceAsStream(resourcesStr); ssf = new SqlSessionFactoryBuilder().build(is); s = ssf.openSession(); }catch (Exception e) { e.printStackTrace(); } } @Test public void testDeleteByIds(){ List<Integer> list = new ArrayList<>(); Collections.addAll(list, 1, 2, 3, 36, 39); // 以批量的处理方式打开数据库连接 ssf.openSession(ExecutorType.BATCH, false); int result = s.delete("myBatis.deleteByIds", list); s.commit(); System.out.println("result = " + result); } @Test public void testDeleteById(){ int result = s.delete("myBatis.deleteByIds.deleteById", 38); s.commit(); System.out.println("result = " + result); } @Test public void testSelectByLike(){ String name = "user"; List<User> list = s.selectList("myBatis.deleteByIds.likeByName", name); for (User u : list) { System.out.println(u); } } @Test public void testUpdateBatch(){ List<User> users = new ArrayList<>(); User u = null; for(int i = 0; i < 3; i++){ u = new User(20+i, "name" + i, "pass" + i); System.out.println(u); users.add(u); } int result = s.update("myBatis.deleteByIds.updateUserBatch", users); s.commit(); System.out.println("result = " + result); } @Test public void testUpdateUserById(){ User user = new User(38, "user38", "pass38"); int result = s.update("myBatis.deleteByIds.updateById", user); System.out.println("result = " + result); } @Test public void testFindById(){ User u = s.selectOne("myBatis.deleteByIds.findById", 32); System.out.println(u); } @Test public void testFindAll(){ List<User> list = s.selectList("myBatis.deleteByIds.findAll"); for (User u : list) { System.out.println(u); } } @Test public void testAdd(){ try { User user = new User(); user.setUsername("abc"); user.setPassword("123"); s.insert("myBatis.deleteByIds.save", user); s.commit(); s.close(); } catch (Exception e) { e.printStackTrace(); } } @After public void destrory(){ if(s != null){ s.close(); s = null; } } }
使用Maven简单配置Mybatis
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。