Skip to content
This repository was archived by the owner on Jul 20, 2020. It is now read-only.

Commit fe5f17e

Browse files
committed
Day06 日更
1 parent 65d3e9f commit fe5f17e

31 files changed

Lines changed: 972 additions & 44 deletions

File tree

‎.idea/artifacts/day06_war_exploded.xml‎

Lines changed: 16 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎.idea/artifacts/day07_1_war_exploded.xml‎

Lines changed: 16 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎.idea/modules.xml‎

Lines changed: 2 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎.idea/sqldialects.xml‎

Lines changed: 6 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎day05/day05_3/Config/UserMapper.xml‎

Lines changed: 34 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
<!DOCTYPE mapper
2-
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
3-
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
2+
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
3+
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
44

55
<!--通过命令空间找到指定 sql 操作文件-->
66
<mapper namespace="UserMapper">
@@ -12,6 +12,38 @@
1212

1313
</select>
1414

15+
<select id="selectById" parameterType="int" resultType="com.inkss.day05_3.pojo.User">
16+
17+
select * from user where id = #{id};
18+
19+
</select>
20+
21+
<select id="selectByName" parameterType="String" resultType="com.inkss.day05_3.pojo.User">
22+
23+
select * from user where username = #{name};
24+
25+
</select>
26+
27+
<select id="selectLikeName" parameterType="String" resultType="com.inkss.day05_3.pojo.User">
28+
29+
select * from user where username like '%${value}%';
30+
31+
</select>
32+
33+
<insert id="insertUser" parameterType="com.inkss.day05_3.pojo.User">
34+
-- 获取插入的 ID
35+
<selectKey keyProperty="id" resultType="int" order="AFTER">
36+
select LAST_INSERT_ID()
37+
</selectKey>
38+
39+
insert into user(username,sex,birthday,address)
40+
values (#{username},#{sex},#{birthday},#{address});
41+
</insert>
42+
43+
<update id="updateUser" parameterType="com.inkss.day05_3.pojo.User">
44+
update user set username = #{username} , birthday = #{birthday} ,sex = #{sex},address = #{address}
45+
where id = #{id};
46+
</update>
1547

1648
</mapper>
1749

‎day05/day05_3/day05_3.iml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@
2020
<content url="file://$MODULE_DIR$">
2121
<sourceFolder url="file://$MODULE_DIR$/src" isTestSource="false" />
2222
<sourceFolder url="file://$MODULE_DIR$/Config" isTestSource="false" />
23-
<sourceFolder url="file://$MODULE_DIR$/src/com/test" isTestSource="true" />
23+
<sourceFolder url="file://$MODULE_DIR$/src/test" isTestSource="true" />
2424
</content>
2525
<orderEntry type="inheritedJdk" />
2626
<orderEntry type="sourceFolder" forTests="false" />

‎day05/day05_3/src/com/inkss/day05_3/pojo/User.java‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -21,6 +21,13 @@ public User(Integer id, String username, Date birthday, String sex, String addre
2121
this.address = address;
2222
}
2323

24+
public User(String username, Date birthday, String sex, String address) {
25+
this.username = username;
26+
this.birthday = birthday;
27+
this.sex = sex;
28+
this.address = address;
29+
}
30+
2431
public Integer getId() {
2532
return id;
2633
}

‎day05/day05_3/src/com/test/com/inkss/day05_3/pojo/UserTest.java‎

Lines changed: 0 additions & 41 deletions
This file was deleted.
Lines changed: 113 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,113 @@
1+
package com.inkss.day05_3.pojo;
2+
3+
import org.apache.ibatis.io.Resources;
4+
import org.apache.ibatis.session.SqlSession;
5+
import org.apache.ibatis.session.SqlSessionFactory;
6+
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
7+
import org.junit.Test;
8+
9+
import java.io.IOException;
10+
import java.io.InputStream;
11+
import java.util.Date;
12+
import java.util.List;
13+
14+
15+
public class UserTest {
16+
17+
@Test
18+
public void selectAllUser() throws IOException {
19+
System.out.println("测试开始");
20+
21+
// 在类中访问库
22+
// 先加载 mybatis 配置文件
23+
String path = "SqlMapConfig.xml";
24+
25+
InputStream inputStream = Resources.getResourceAsStream(path);
26+
27+
// 生成 sql 会话工厂类对象
28+
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
29+
30+
// 获取 SqlSession 对象:也就是一次 sql 会话对象
31+
SqlSession sqlSession = sqlSessionFactory.openSession();
32+
33+
// 使用 sqlSession 进行 sql 查询
34+
// selectList 是查询集合数据
35+
List<User> userList = sqlSession.selectList("UserMapper.selectAllUser");
36+
37+
for (User user : userList)
38+
System.out.println(user);
39+
sqlSession.close();
40+
}
41+
42+
@Test
43+
public void selectById() throws IOException {
44+
System.out.println("测试开始");
45+
String path = "SqlMapConfig.xml";
46+
InputStream inputStream = Resources.getResourceAsStream(path);
47+
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
48+
SqlSession sqlSession = sqlSessionFactory.openSession();
49+
User user = sqlSession.selectOne("UserMapper.selectById", 26);
50+
System.out.println(user);
51+
52+
sqlSession.close();
53+
}
54+
55+
@Test
56+
public void selectByName() throws IOException {
57+
System.out.println("测试开始");
58+
String path = "SqlMapConfig.xml";
59+
InputStream inputStream = Resources.getResourceAsStream(path);
60+
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
61+
SqlSession sqlSession = sqlSessionFactory.openSession();
62+
User user = sqlSession.selectOne("UserMapper.selectByName", "张三");
63+
System.out.println(user);
64+
65+
sqlSession.close();
66+
}
67+
68+
@Test
69+
public void selectLikeName() throws IOException {
70+
System.out.println("测试开始");
71+
String path = "SqlMapConfig.xml";
72+
InputStream inputStream = Resources.getResourceAsStream(path);
73+
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
74+
SqlSession sqlSession = sqlSessionFactory.openSession();
75+
List<User> userList = sqlSession.selectList("UserMapper.selectLikeName", "张");
76+
for (User user : userList)
77+
System.out.println(user);
78+
79+
sqlSession.close();
80+
}
81+
82+
@Test
83+
public void insertUser() throws IOException {
84+
System.out.println("测试开始");
85+
String path = "SqlMapConfig.xml";
86+
InputStream inputStream = Resources.getResourceAsStream(path);
87+
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
88+
SqlSession sqlSession = sqlSessionFactory.openSession();
89+
90+
User user = new User("小红", new Date(), "男", "");
91+
92+
sqlSession.insert("UserMapper.insertUser", user);
93+
sqlSession.commit(); // 提交
94+
System.out.println("插入的 id 为:" + user.getId());
95+
sqlSession.close();
96+
}
97+
98+
@Test
99+
public void updateUser() throws IOException {
100+
System.out.println("测试开始");
101+
String path = "SqlMapConfig.xml";
102+
InputStream inputStream = Resources.getResourceAsStream(path);
103+
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
104+
SqlSession sqlSession = sqlSessionFactory.openSession();
105+
106+
User user = new User(29,"小红哟", new Date(), "女", "三里屯");
107+
108+
sqlSession.update("UserMapper.updateUser", user);
109+
sqlSession.commit(); // 提交
110+
sqlSession.close();
111+
}
112+
113+
}

‎day05/readme.md‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,2 +1,11 @@
11
> 注意:项目的 Lib 依赖来自于 day04/web/WEB-INF/lib 文件夹中,以后的 JavaWeb 项目也是。
22
3+
附录:
4+
5+
* [MyBatis 从入门到放弃一:从 SqlSession 实现增删改查](https://www.cnblogs.com/sword-successful/p/6504222.html)
6+
* [MyBatis 从入门到放弃二:传参](https://www.cnblogs.com/sword-successful/p/6504254.html)
7+
* [MyBatis 从入门到放弃三:一对一关联查询](https://www.cnblogs.com/sword-successful/p/6504300.html)
8+
* [MyBatis 从入门到放弃四:一对多关联查询](https://www.cnblogs.com/sword-successful/p/6505744.html)
9+
* [MyBatis 从入门到放弃五:调用存储过程(SQLServer2012)](https://www.cnblogs.com/sword-successful/p/6505875.html)
10+
* [MyBatis 使用示例](https://www.cnblogs.com/zhanjindong/p/3397828.html)
11+
* [Mybatis 初体验](https://segmentfault.com/a/1190000006705133)

0 commit comments

Comments
 (0)