个人中心
gpt4 book ai didi

Mybatis实现增删改查及分页查询的方法

转载 作者：qq735679552 更新时间：2022-09-29 22:32:09 24 4
gpt4 key购买 nike

CFSDN坚持开源创造价值，我们致力于搭建一个资源共享平台，让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章Mybatis实现增删改查及分页查询的方法由作者收集整理，如果你对这篇文章有兴趣，记得点赞哟.

MyBatis的前身就是iBatis。是一个数据持久层(ORM)框架。 MyBatis是支持普通SQL查询，存储过程和高级映射的优秀持 久层框架。MyBatis消除了几乎所有的JDBC 代码和参数的手工 设置以及结果集的检索。MyBatis使用简单的XML或注解用于 配置和原始映射，将接口和Java 的POJOs（Plan Old Java Objects，普通的Java 对象）映射成数据库中的记录。每个 MyBatis应用程序主要都是使用SqlSessionFactory实例的，一个 SqlSessionFactory实例可以通过SqlSessionFactoryBuilder获得.

具体代码如下所示:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
<?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>
<typeAliases>
<!-- give a alias for model -->
<typeAlias alias= "goods" type= "com.clark.model.Goods" ></typeAlias>
</typeAliases>
<environments default = "development" >
<environment id= "development" >
<transactionManager type= "JDBC" />
<dataSource type= "POOLED" >
<property name= "driver" value= "oracle.jdbc.driver.OracleDriver" />
<property name= "url" value= "jdbc:oracle:thin:@172.30.0.125:1521:oradb01" />
<property name= "username" value= "settlement" />
<property name= "password" value= "settlement" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource= "com/clark/model/goodsMapper.xml" />
</mappers>
</configuration>
<?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= "clark" >
<!-- 将db查询出来的结果映射到Model--Goods -->
<resultMap type= "com.clark.model.Goods" id= "t_good" >
<id column= "id" property= "id" />
<result column= "cate_id" property= "cateId" />
<result column= "name" property= "name" />
<result column= "price" property= "price" />
<result column= "description" property= "description" />
<result column= "order_no" property= "orderNo" />
<result column= "update_time" property= "updateTime" />
</resultMap>
<!-- 根据id查询 返回Goods类型 <typeAlias alias= "goods" type= "com.clark.model.Goods" ></typeAlias>-->
<!--resultMap 和 resultType的使用区别-->
<select id= "selectGoodById" parameterType= "int" resultType= "goods" >
select id,cate_id,name,price,description,order_no,update_time
from goods where id = #{id}
</select>
<!-- 查询所有Goods 返回resultMap类型-->
<select id= "selectAllGoods" resultMap= "t_good" >
select id,cate_id,name,price,description,order_no,update_time from goods
</select>
<!-- 指定parameterType=map 其中map的形式为Map<String,PageBean> map-->
<select id= "selectGoodsByPage" resultMap= "t_good" parameterType= "map" >
<!-- order by id asc是指对查询后的结果进行升序排序 -->
<![CDATA[
select * from
(select g.*,rownum rn from (select * from goods) g where 1 = 1 and rownum <= #{pageBean.endNumber})
where rn >= #{pageBean.startNumber}
order by id asc
]]>
</select>
<!-- 新增Goods 参数类型为Goods-->
<insert id= "insertGood" parameterType= "goods" >
insert into goods(id,cate_id,name,price,description,order_no,update_time)
values(#{id},#{cateId},#{name},#{price},#{description},#{orderNo},#{updateTime})
</insert>
<!-- 更新Goods 参数类型为Goods-->
<update id= "updateGood" parameterType= "goods" >
update goods g
set g.name = #{name},g.order_no =#{orderNo}
where g.id = #{id}
</update>
<!-- 删除Goods 参数类型为 int -->
<delete id= "deleteGood" parameterType= "int" >
delete from goods g
where g.id = #{id}
</delete>
</mapper>
package com.clark.model;
import java.util.Date;
public class Goods {
private Integer id;
private Integer cateId;
private String name;
private double price;
private String description;
private Integer orderNo;
private Date updateTime;
public Goods(){
}
public Goods(Integer id, Integer cateId, String name, double price,
String description, Integer orderNo, Date updateTime) {
super ();
this .id = id;
this .cateId = cateId;
this .name = name;
this .price = price;
this .description = description;
this .orderNo = orderNo;
this .updateTime = updateTime;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this .id = id;
}
public Integer getCateId() {
return cateId;
}
public void setCateId(Integer cateId) {
this .cateId = cateId;
}
public String getName() {
return name;
}
public void setName(String name) {
this .name = name;
}
public double getPrice() {
return price;
}
public void setPrice( double price) {
this .price = price;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this .description = description;
}
public Integer getOrderNo() {
return orderNo;
}
public void setOrderNo(Integer orderNo) {
this .orderNo = orderNo;
}
public Date getTimeStamp() {
return updateTime;
}
public void setTimeStamp(Date updateTime) {
this .updateTime = updateTime;
}
@Override
public String toString() {
return "[goods include:Id=" + this .getId()+ ",name=" + this .getName()+
",orderNo=" + this .getOrderNo()+ ",cateId=" + this .getCateId()+
",updateTime=" + this .getTimeStamp()+ "]" ;
}
}
 
package com.clark.model;
//模拟的一个分页对象PageBean
public class PageBean {
//开始数
private Integer startNumber;
//结束数
private Integer endNumber;
public PageBean(){
}
public PageBean(Integer startNumber, Integer endNumber) {
super ();
this .startNumber = startNumber;
this .endNumber = endNumber;
}
public Integer getStartNumber() {
return startNumber;
}
public void setStartNumber(Integer startNumber) {
this .startNumber = startNumber;
}
public Integer getEndNumber() {
return endNumber;
}
public void setEndNumber(Integer endNumber) {
this .endNumber = endNumber;
}
}
package com.clark.mybatis;
import java.io.IOException;
import java.io.Reader;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
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 com.clark.model.Goods;
import com.clark.model.PageBean;
public class TestGoods {
public static void main(String[] args) throws IOException {
String resource = "configuration.xml" ;
Reader reader = null ;
SqlSessionFactory sessionFactory = null ;
SqlSession session = null ;
try {
reader = Resources.getResourceAsReader(resource);
sessionFactory = new SqlSessionFactoryBuilder().build(reader);
session = sessionFactory.openSession();
PageBean pageBean = new PageBean( 8 , 20 );
Map<String,PageBean> map = new HashMap<String, PageBean>();
map.put( "pageBean" , pageBean);
List<Goods> gs = findGoodsByPage(session,map);
for (Goods goods2 : gs) {
System.out.println(goods2.toString());
}
} catch (IOException e) {
e.printStackTrace();
} finally {
session.close();
reader.close();
}
}
//find by id
public static Goods findGoodById(SqlSession session,Integer id){
//clark对应着goodMapper.xml配置文件中的namespace name="clark"
Goods goods = (Goods)session.selectOne( "clark.selectGoodById" , id);
return goods;
}
//find all
public static List<Goods> findAllGoods(SqlSession session){
List<Goods> goods = session.selectList( "clark.selectAllGoods" );
return goods;
}
public static List<Goods> findGoodsByPage(SqlSession session,Map<String,PageBean> map){
List<Goods> goods = session.selectList( "clark.selectGoodsByPage" ,map);
return goods;
}
//insert a goods
public static int insertGoods(SqlSession session,Goods goods){
int result = session.insert( "clark.insertGood" , goods);
session.commit();
return result;
}
//update goods
public static int updateGoods(SqlSession session,Goods goods){
int result = session.update( "clark.updateGood" , goods);
session.commit();
return result;
}
//delete goods
public static int deleteGood(SqlSession session,Integer id){
int result = session.delete( "clark.deleteGood" , id);
session.commit();
return result;
}
}

关于Mybatis实现增删改查及分页查询的方法的相关知识，就给大家介绍到这里，后续还会持续给大家更新，谢谢大家一直以来对我网站的支持.

最后此篇关于Mybatis实现增删改查及分页查询的方法的文章就讲到这里了,如果你想了解更多关于Mybatis实现增删改查及分页查询的方法的内容请搜索CFSDN的文章或继续浏览相关文章，希望大家以后支持我的博客！ 。

24 4 0
文章推荐： 详解java中动态代理实现机制
文章推荐： Java运用SWT插件编写桌面记事本应用程序
文章推荐： 中国式人生健身有什么加成 健身属性一览
文章推荐： 中国式人生课外活动怎么选 课外活动属性加成介绍
qq735679552
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com