SpringMVC mybatis整合实例代码详解

2024-02-25 12:12:03 57

MyBatis本是apache的一个开源项目iBatis,2010年这个项目由apachesoftwarefoundation迁移到了googlecode，并且改名为MyBatis。

一、逆向工程生成基础信息










word="jalja">





























publicstaticvoidmain(String[]arhs)throwsException{
Listwarnings=newArrayList();
booleanoverwrite=true;
FileconfigFile=newFile("src.main.resources/generator.xml");
ConfigurationParsercp=newConfigurationParser(warnings);
Configurationconfig=cp.parseConfiguration(configFile);
DefaultShellCallbackcallback=newDefaultShellCallback(overwrite);
MyBatisGeneratormyBatisGenerator=newMyBatisGenerator(config,callback,warnings);
myBatisGenerator.generate(null);
}

二、springMVC与Mybatis整合各个配置文件

1.项目结构

2、各个文件的核心代码

a.web.xml




index.jsp


contextConfigLocation
classpath:spring/applicationContext-*.xml


org.springframework.web.context.ContextLoaderListener


log4jConfigLocation
classpath:log4j.properties


log4jRefreshInterval
3000


org.springframework.web.util.Log4jConfigListener



SpringEncodingFilter
org.springframework.web.filter.CharacterEncodingFilter

encoding
UTF-8


forceEncoding
true



SpringEncodingFilter
*.do



springMvc
org.springframework.web.servlet.DispatcherServlet


contextConfigLocation
classpath:spring/springmvc.xml

1


springMvc

*.do



30

b、config/mybatis/applicationContext-mybatis.xml

c、config/spring/applicationContext-dao.xml








${jdbc_driverClassName}


${jdbc_url}


${jdbc_username}


${jdbc_password}



20



1



60000



20



3



true



180



clientEncoding=UTF-8

d、config/spring/applicationContext-service.xml

e、config/spring/springmvc.xml

f、config/jdbc.properties

jdbc_driverClassName=com.mysql.jdbc.Driver
jdbc_url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=UTF-8
jdbc_username=root
jdbc_password=111111

g、config/log4j.properties

#在开发环境下的日志级别要设置成debug，生成环境设置成info或error
log4j.rootLogger=debug,stdout
log4j.logger.org.apache.ibatis=debug
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p[%t]-%m%n

h、com/jalja/springmvc_mybatis/controller/ItemsController.java

packagecom.jalja.springmvc_mybatis.controller;
importjava.io.File;
importjava.util.List;
importjava.util.UUID;
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.RequestBody;
importorg.springframework.web.bind.annotation.RequestMapping;
importorg.springframework.web.bind.annotation.RequestMethod;
importorg.springframework.web.bind.annotation.RequestParam;
importorg.springframework.web.bind.annotation.ResponseBody;
importorg.springframework.web.multipart.MultipartFile;
importcom.jalja.springmvc_mybatis.exception.CustomException;
importcom.jalja.springmvc_mybatis.model.custom.ItemsCustom;
importcom.jalja.springmvc_mybatis.service.ItemsService;
/**
*商品
*@authorPC003
*conterver参数转换器springMvc提供了很多参数转换器
*/
@Controller
@RequestMapping("/items")//窄化请求映射
publicclassItemsController{
@AutowiredItemsServiceitemsService;
@RequestMapping(value="/findItemsList")
publicStringfindItemsList(Modelmodel)throwsException{
ListitemsList=itemsService.findItemsList(null);
System.out.println(itemsList);
model.addAttribute("itemsList",itemsList);
return"itemsList";
}
@RequestMapping(value="/editItems",method={RequestMethod.POST,RequestMethod.GET})//限制Http请求方式
//@RequestParam将请求参数与形式参数进行绑定required:指定属性必须传入值defaultValue:设置默认值
publicStringeditItems(Modelmodel,@RequestParam(value="id",required=true,defaultValue="0")IntegeritemsId)throwsException{
ItemsCustomitemsCustom=itemsService.findItemsById(itemsId);
if(itemsCustom==null){
thrownewCustomException("商品不存在");
}
model.addAttribute("itemsCustom",itemsCustom);
return"editItems";
}
@RequestMapping(value="/updateItems")
publicStringeditItemsSubmit(Integerid,ItemsCustomitemsCustom,MultipartFileitemsPic)throwsException{
StringuploadFileName=itemsPic.getOriginalFilename();//获取上传的文件名
if(itemsPic!=null&&uploadFileName!=null&&!uploadFileName.equals("")){
StringimagesPath="E:\\develop\\upload\\images\\";
StringnewFileName=UUID.randomUUID()+uploadFileName.substring(uploadFileName.lastIndexOf("."),uploadFileName.length());
FilenewFile=newFile(imagesPath+newFileName);
itemsPic.transferTo(newFile);//将内存中的数据写入磁盘
itemsCustom.setPic(newFileName);
}
itemsService.updateItemsById(id,itemsCustom);
return"redirect:findItemsList.do";//重定向
}
//JSON的使用@ResponseBody：将对像转json输出@RequestBody:将请求参数转java对象
@RequestMapping(value="/jsonRequest")
public@ResponseBodyItemsCustomjsonRequest(@RequestBodyItemsCustomitemsCustom)throwsException{
returnitemsCustom;
}
//RestFul风格编程/restFulRequest/{id}：表示将这个位置的参数传到@PathVariable指定的名称中
@RequestMapping(value="/restFulRequest/{id}")
public@ResponseBodyItemsCustomrestFulRequest(@PathVariable("id")Integerid)throwsException{
ItemsCustomitemsCustom=itemsService.findItemsById(id);
returnitemsCustom;
}
}

希望本篇实例对您有所帮助

SpringMVC mybatis整合实例代码详解

热门推荐

随机推荐