SpringMVC3+Mybatis3登录及CRUD操作.docx
- 文档编号:7017600
- 上传时间:2023-01-16
- 格式:DOCX
- 页数:23
- 大小:21.09KB
SpringMVC3+Mybatis3登录及CRUD操作.docx
《SpringMVC3+Mybatis3登录及CRUD操作.docx》由会员分享,可在线阅读,更多相关《SpringMVC3+Mybatis3登录及CRUD操作.docx(23页珍藏版)》请在冰豆网上搜索。
SpringMVC3+Mybatis3登录及CRUD操作
官网:
参考资料
1兼顾效率,iBatis一些非见用法(10条)
2整合Mybatis与Spring3
一环境:
XP3+Oracle10g+MyEclipse6+(TomcatorWebLogic92)+JDK1.5
二工程文件:
Spring3+MyIbatis3
工程图片:
jar下载:
三具体代码如下:
1数据库文件
createtableUSERS
(
idVARCHAR2(50)notnull,
nameVARCHAR2(50),
ageINTEGER,
sexVARCHAR2
(1),
addressVARCHAR2(200),
passwordVARCHAR2(20)
)
insertintousers(id,name,age,sex,address,password)VALUES(";123456789";,";sprng";,23,";1";,";北京大学";,";123";);
2Java相关文件
AUserMapper.java
packagecom.liuzd.ssm.mapper;
importjava.util.List;
importcom.liuzd.ssm.entity.User;
publicinterfaceUserMapper{
publicintcheckUserExits(Useruser);
publicvoidaddUser(Useruser);
publicvoideditUser(Useruser);
publicvoiddelUser(StringuserId);
publicList<;User>;getUserList();
publicUsergetUserByUid(StringuserId);
}
BUserMapper.xml文件
<;?
xmlversion=";1.0";encoding=";UTF-8";?
>;
<;!
DOCTYPEmapperPUBLIC";-//mybatis.org//DTDMapper3.0//EN";
";http:
//mybatis.org/dtd/mybatis-3-mapper.dtd";>;
<;mappernamespace=";com.liuzd.ssm.mapper.UserMapper";>;
<;resultMaptype=";com.liuzd.ssm.entity.User";id=";userMap";>;
<;idproperty=";id";column=";id";/>;
<;resultproperty=";name";column=";name";/>;
<;resultproperty=";age";column=";age";/>;
<;resultproperty=";sex";column=";sex";/>;
<;resultproperty=";address";column=";address";/>;
<;resultproperty=";password";column=";password";/>;
<;/resultMap>;
<;selectid=";checkUserExits";parameterType=";com.liuzd.ssm.entity.User";resultType=";int";>;
<;!
[CDATA[
selectcount(*)fromuserswherename=#{name}andpassword=#{password}
]]>;
<;/select>;
<;selectid=";getUserList";resultType=";java.util.List";resultMap=";userMap";>;
<;!
[CDATA[
select*fromusers
]]>;
<;/select>;
<;selectid=";getUserByUid";parameterType=";string";resultType=";com.liuzd.ssm.entity.User";>;
<;!
[CDATA[
select*fromuserswhereid=#{id}
]]>;
<;/select>;
<;updateid=";editUser";parameterType=";com.liuzd.ssm.entity.User";>;
<;!
[CDATA[
updateuserssetname=#{name},age=#{age},sex=#{sex},address=#{address},password=#{password}whereid=#{id}
]]>;
<;/update>;
<;insertid=";addUser";parameterType=";com.liuzd.ssm.entity.User";>;
<;!
[CDATA[
insertintousers(id,name,age,sex,address,password)VALUES(#{id},#{name},#{age},#{sex},#{address},#{password})
]]>;
<;/insert>;
<;deleteid=";delUser";parameterType=";string";>;
<;!
[CDATA[
deleteuserswhereid=#{id}
]]>;
<;/delete>;
<;/mapper>;
CUserService.java
packagecom.liuzd.ssm.service;
importjava.util.List;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.stereotype.Service;
importcom.liuzd.ssm.entity.User;
importcom.liuzd.ssm.mapper.UserMapper;
@Service(";userService";)
publicclassUserService{
@Autowired
privateUserMapperuserMapper;
publicvoidaddUser(Useruser){
this.userMapper.addUser(user);
}
publicintcheckUserExits(Useruser){
returnthis.userMapper.checkUserExits(user);
}
publicvoiddelUser(StringuserId){
this.userMapper.delUser(userId);
}
publicUsergetUserByUid(StringuserId){
return(User)this.userMapper.getUserByUid(userId);
}
publicList<;User>;getUserList(){
return(List<;User>;)this.userMapper.getUserList();
}
publicvoideditUser(Useruser){
this.userMapper.editUser(user);
}
}
DWEB层调用代码
aLoginController.java
packagecom.liuzd.ssm.web;
importjava.util.List;
importjavax.annotation.Resource;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importorg.springframework.stereotype.Controller;
importorg.springframework.ui.Model;
importorg.springframework.web.bind.annotation.ModelAttribute;
importorg.springframework.web.bind.annotation.PathVariable;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.bind.annotation.RequestMethod;
importorg.springframework.web.servlet.ModelAndView;
importcom.liuzd.ssm.entity.User;
importcom.liuzd.ssm.service.UserService;
@Controller
@RequestMapping(";/login";)
publicclassLoginController{
privateUserServiceuserService;
publicUserServicegetUserService(){
returnuserService;
}
@Resource
publicvoidsetUserService(UserServiceuserService){
this.userService=userService;
}
@SuppressWarnings(";unchecked";)
@RequestMapping(";add";)
//@ModelAttribute可加可不加,url:
http:
//127.0.0.1:
8088/ssm/user/add.do
publicStringlogin(Useruser,HttpServletRequestreq,HttpServletResponseresponse){
//此处调用服务层进行相应的业务操作
//传递对象于下一页面
req.setAttribute(";user";,user);
//调用服务层进行验证用户,此处只演示功能
intusize=getUserService().checkUserExits(user);
System.out.println(";用户信息:
";+user+";,usize:
";+usize);
if(usize>;0){
//return";success";;
List<;User>;useralls=this.getUserService().getUserList();
req.setAttribute(";userList";,useralls);
return";userList";;
}
return";error";;
}
@SuppressWarnings(";unchecked";)
//@RequestMapping(params=";method=add2";,method=RequestMethod.POST)
//定义method方法不是必须的
@RequestMapping(params=";method=add2";)
publicModelAndViewlogin2(@ModelAttribute(";user";)Useruser,HttpServletRequestreq,HttpServletResponseresponse){
//使用ModelAndView保存对象于下一页面
ModelAndViewmodel=newModelAndView();
model.addObject(";user";,user);
//调用服务层进行验证用户,此处只演示功能
intusize=getUserService().checkUserExits(user);
System.out.println(";用户信息2:
";+user+";,usize:
";+usize);
if(usize>;0){
List<;User>;useralls=this.getUserService().getUserList();
model.addObject(";userList";,useralls);
model.setViewName(";userList";);
}else{
model.addObject(";msg";,";用户或者密码错误!
";);
model.setViewName(";error";);
}
returnmodel;
}
@RequestMapping(value=";add3/{name}/{password}";,method=RequestMethod.GET)
publicStringlogin3(@PathVariable(";name";)Stringname,@PathVariable(";password";)Stringpwd,Modelmodel){
Useruser=newUser();
user.setName(name);
user.setPassword(pwd);
model.addAttribute(";user";,user);
//调用服务层进行验证用户,此处只演示功能
intusize=getUserService().checkUserExits(user);
System.out.println(";用户信息3:
";+user+";,size:
";+usize);
if(usize>;0){
return";success";;
}
//放入model默认把参数存于请求
model.addAttribute(";msg";,";用户或者密码错误!
";);
return";error";;
/**
*重定向JSP页面,走出了springmvc配置的view(jsp)
*因为这样说明:
model.addAttribute(";msg";,";用户或者密码错误!
";);
*获取不到值了
*不加上.jsp就是这样:
http:
//127.0.0.1:
8080/Spring3-Login-Annotaction/index?
msg=%E7...
**/
//返回到页面是乱码在页面中用${msg}获取不到值,用request.getParams(";msg";);为乱码
//return";redirect:
index.jsp?
msg=用户或者密码错误!
";;
}
}
bUserController.java
packagecom.liuzd.ssm.web;
importjava.util.List;
importjavax.annotation.Resource;
importorg.springframework.stereotype.Controller;
importorg.springframework.web.bind.annotation.PathVariable;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.bind.annotation.SessionAttributes;
importorg.springframework.web.servlet.ModelAndView;
importcom.liuzd.ssm.entity.User;
importcom.liuzd.ssm.service.UserService;
@Controller
@RequestMapping(";/user";)
@SessionAttributes(";userList";)
publicclassUserController{
privateUserServiceuserService;
publicUserServicegetUserService(){
returnuserService;
}
@Resource
publicvoidsetUserService(UserServiceuserService){
this.userService=userService;
}
@RequestMapping(";/userList";)
publicModelAndViewuserList(){
/**
*想要在页面展现数据,必须返回ModelAndView类型,返回String是不能获取数据的
**/
ModelAndViewmv=newModelAndView();
List<;User>;users=this.getUserService().getUserList();
mv.addObject(";userList";,users);
mv.setViewName(";userList";);
returnmv;
}
@RequestMapping(";/addUser";)
publicModelAndViewaddUser(Useruser){
System.out.println(";ADDUSER:
";+user);
this.userService.addUser(user);
returnuserList();
}
@RequestMapping(";/toAddUser";)
publicStringtoAddUser(){
return";addUser";;
}
@RequestMapping(";/delUser/{id}";)
publicModelAndViewdelUser(@PathVariable(";id";)Stringid){
this.userService.delUser(id);
returnuserList();
}
@RequestMapping(";/getUser/{id}";)
publicModelAndViewgetUser(@PathVariable(";id";)Stringid){
Useruser=this.userService.getUserByUid(id);
ModelAndViewmv=newModelAndView(";updateUser";);
mv.addObject(";user";,user);
returnmv;
}
@RequestMapping(";/updateUser";)
publicModelAndVieweditUser(Useruser){
System.out.println(";编辑:
";+user);
this.userService.editUser(user);
returnuserList();
}
}
3JSp文件
Aindex.jsp
<;%@pagelanguage=";java";pageEncoding=";UTF-8";contentType=";text/html;charset=UTF-8";%>;
<;!
DOCTYPEHTMLPUBLIC";-//W3C//DTDHTML4.01Transitional//EN";>;
<;html>;
<;head>;
<;%@includefile=";/common/meta.jsp";%>;
<;/head>;
<;body>;
<;formaction=";${pageContext.request.contextPath}/login/add.do";method=";post";>;
姓名:
<;inputtype=";text";name=";name";id=";name";>;<;br>;
密码:
<;inputtype=";password";name=";password";id=";password";>;<;br>;
<;inputtype=";submit";value=";Login";>;
<;/form>;<;br>;
<;formaction=";${pageContext.request.contextPath}/login.do?
method=add2";method=";post";>;
姓名:
<;inputtype=";text";name=";name";id=";name";>;<;
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SpringMVC3 Mybatis3 登录 CRUD 操作