Mybatis集成Spring的实例代码_动力节点Java 学院整理

2023-09-25 10:39:16 61

所需要用到的其他工具或技术:

项目管理工具:Maven

前台WEB展示：JSP

其他框架:Spring,SpringMVC

数据库 :Derby

新建一个Maven的Web项目

MavenDependencies:



org.springframework
spring-context
4.0.0.RELEASE


org.springframework
spring-webmvc
4.0.0.RELEASE


org.springframework
spring-tx
4.0.0.RELEASE


org.springframework
spring-jdbc
4.0.0.RELEASE



org.aspectj
aspectjrt
1.6.10



org.slf4j
slf4j-api
1.6.6


org.slf4j
jcl-over-slf4j
1.6.6
runtime


org.slf4j
slf4j-log4j12
1.6.6
runtime



javax.inject
javax.inject
1



javax.servlet
servlet-api
2.5
provided


javax.servlet.jsp
jsp-api
2.1
provided


javax.servlet
jstl
1.2



org.mybatis
mybatis
3.2.7


org.mybatis
mybatis-spring
1.2.1



junit
junit
4.9
test



org.apache.derby
derby
10.10.2.0


org.apache.derby
derbyclient
10.10.2.0

SQL建表及数据插入

CREATETABLEUSER_TEST_TB(
IDINTPRIMARYKEY,
USERNAMEVARCHAR(20)NOTNULL,
PASSWORDVARCHAR(20)NOTNULL,
NICKNAMEVARCHAR(20)NOTNULL
);
INSERTINTOUSER_TEST_TBVALUES(1,'1st','111','Jack');
INSERTINTOUSER_TEST_TBVALUES(2,'2nd','222','Rose');
INSERTINTOUSER_TEST_TBVALUES(3,'3rd','333','Will');

web.xml（scr/main/webapp/WEB-INF下）





contextConfigLocation
/WEB-INF/*Context.xml


org.springframework.web.context.ContextLoaderListener


appServlet
org.springframework.web.servlet.DispatcherServlet
1


appServlet
/

appServlet-servlet.xml（Spring的Servlet配置文件scr/main/webapp/WEB-INF下）

JSP文件

show.jsp(src/main/webapp/WEB-INF/views目录下)
<%@pagelanguage="java"contentType="text/html;charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@tagliburi="http://java.sun.com/jsp/jstl/core"prefix="c"%>




ShowAllUsers

*{
margin:0px;
padding:0px;
}






USER_NAME
PASSWORD
NICK_NAME
EDIT
DELETE



${user.username}
${user.password}
${user.nickname}
edit
delete




AddnewUser

update.jsp(src/main/webapp/WEB-INF/views目录下)

<%@pagelanguage="java"contentType="text/html;charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>




UpdateProfile



UserID:${user.id}

Username:

Password:

Nickname:

insert.jsp(src/main/webapp/WEB-INF/views目录下)

<%@pagelanguage="java"contentType="text/html;charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>




InsertProfile




UserId:

Username:

Password:

Nickname:

applicationContext.xml(Spring的Application配置文件在src/main/resources目录下)

Java文件

UserController.Java（在src/main/java/com.bjpowernode.practice.controller目录下）

packagecom.bjpowernode.practice.controller;
importcom.bjpowernode.practice.User;
importcom.bjpowernode.practice.UserMapper;
importjava.util.List;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.stereotype.Controller;
importorg.springframework.ui.Model;
importorg.springframework.web.bind.annotation.PathVariable;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.bind.annotation.RequestMethod;
importorg.springframework.web.servlet.config.annotation.EnableWebMvc;
@EnableWebMvc
@Controller
publicclassUserController
{
@Autowired
privateUserMapperuserMapper;
/**
*
*获得所有的User信息
*
*@parammodel
*@return
*/
@RequestMapping(value={"/",""},method=RequestMethod.GET)
publicStringgetAllUser(Modelmodel)
{
Listusers=userMapper.getUsers();
System.out.println("Showallusersize:"+users.size());
model.addAttribute("users",users);
return"show";
}
/**
*
*INSERT的GET请求，跳转到Insert的View即insert.jsp
*
*@return
*/
@RequestMapping(value={"/insert",""},method=RequestMethod.GET)
publicStringinsertUser()
{
return"insert";
}
/**
*
*INSERT的POST请求，执行插入操作并返回ShowAll页面
*
*@paramuser
*@return
*/
@RequestMapping(value={"/insert",""},method=RequestMethod.POST)
publicStringinsertUserPOST(Useruser)
{
userMapper.insertUser(user);
return"redirect:/";
}
/**
*
*UPDATE的GET请求，跳转到update的View即update.jsp
*
*@paramid
*@parammodel
*@return
*/
@RequestMapping(value={"/update/{id}",""},method=RequestMethod.GET)
publicStringupdateUser(@PathVariableStringid,Modelmodel)
{
model.addAttribute("user",userMapper.getUser(Integer.valueOf(id)));
return"update";
}
/**
*
*UPDATE的POST请求，执行更新操作并返回ShowAll页面
*
*@paramid
*@paramuser
*@return
*/
@RequestMapping(value={"/update/{id}",""},method=RequestMethod.POST)
publicStringupdateUserPOST(@PathVariableStringid,Useruser)
{
userMapper.updateUser(user);
return"redirect:/";
}
/**
*
*通过Id删除USER
*
*@paramid
*@return
*/
@RequestMapping(value={"/delete/{id}",""},method=RequestMethod.GET)
publicStringdeleteUser(@PathVariableintid)
{
userMapper.deleteUser(id);
return"redirect:/";
}
}

User.java(在src/main/java/com.bjpowernode.practice)

packagecom.bjpowernode.practice;
/**
*
*User对象。
*
*@authorFreudKang
*
*/
publicclassUser
{
privateIntegerid;
privateStringusername;
privateStringpassword;
privateStringnickname;
publicIntegergetId()
{
returnid;
}
publicvoidsetId(Integerid)
{
this.id=id;
}
publicStringgetUsername()
{
returnusername;
}
publicvoidsetUsername(Stringusername)
{
this.username=username;
}
publicStringgetPassword()
{
returnpassword;
}
publicvoidsetPassword(Stringpassword)
{
this.password=password;
}
publicStringgetNickname()
{
returnnickname;
}
publicvoidsetNickname(Stringnickname)
{
this.nickname=nickname;
}
}

UserMapper.java(在src/main/java/com.bjpowernode.practice目录下)

packagecom.bjpowernode.practice;
importjava.util.List;
publicinterfaceUserMapper
{
/**
*
*获得所有User
*
*@return
*/
publicListgetUsers();
/**
*
*通过Id获得User
*
*@paramid
*@return
*/
publicUsergetUser(intid);
/**
*
*插入User
*
*@paramuser
*/
publicvoidinsertUser(Useruser);
/**
*
*更新User
*
*@paramuser
*/
publicvoidupdateUser(Useruser);
/**
*
*通过Id删除User
*
*@paramuserId
*/
publicvoiddeleteUser(intuserId);
}

UserMapper.xml（mybatis的mapper配置文件，在src/main/java/com.bjpowernode.practice目录下）






select*
fromUSER_TEST_TB



select*
fromUSER_TEST_TB
whereID=#{id}



insertinto
USER_TEST_TB
values(#{id},#{username},#{password},#{nickname})



updateUSER_TEST_TBset
USERNAME=#{username},
PASSWORD=#{password},
NICKNAME=#{nickname}
whereID=#{id}



deletefromUSER_TEST_TBwhereID=#{id}

总结

以上所述是小编给大家介绍的Mybatis集成Spring的实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持！

Mybatis集成Spring的实例代码_动力节点Java 学院整理

热门推荐

随机推荐