首页下载资源后端springmvc下的mybatis的sharding分表

ZIPspringmvc下的mybatis的sharding分表

zhulin4043.86KB需要积分:1

资源文件列表:

shardtest.zip 大约有76个文件
  1. shardtest/
  2. shardtest/.classpath 1.28KB
  3. shardtest/.project 1.19KB
  4. shardtest/.settings/
  5. shardtest/.settings/.jsdtscope 575B
  6. shardtest/.settings/org.eclipse.jdt.core.prefs 430B
  7. shardtest/.settings/org.eclipse.m2e.core.prefs 90B
  8. shardtest/.settings/org.eclipse.wst.common.component 752B
  9. shardtest/.settings/org.eclipse.wst.common.project.facet.core.xml 252B
  10. shardtest/.settings/org.eclipse.wst.jsdt.ui.superType.container 49B
  11. shardtest/.settings/org.eclipse.wst.jsdt.ui.superType.name 6B
  12. shardtest/.settings/org.eclipse.wst.validation.prefs 50B
  13. shardtest/pom.xml 3.5KB
  14. shardtest/src/
  15. shardtest/src/main/
  16. shardtest/src/main/java/
  17. shardtest/src/main/java/com/
  18. shardtest/src/main/java/com/action/
  19. shardtest/src/main/java/com/action/ShardTestAction.java 3.09KB
  20. shardtest/src/main/java/com/model/
  21. shardtest/src/main/java/com/model/ShardTestBean.java 797B
  22. shardtest/src/main/java/com/model/ShardTestBean.xml 2.14KB
  23. shardtest/src/main/java/com/service/
  24. shardtest/src/main/java/com/service/BaseManager.java 305B
  25. shardtest/src/main/java/com/service/ShardStrategyImpl.java 737B
  26. shardtest/src/main/java/com/service/ShardTestManager.java 1.78KB
  27. shardtest/src/main/resources/
  28. shardtest/src/main/resources/applicationContext.xml 3.38KB
  29. shardtest/src/main/resources/database.sql 648B
  30. shardtest/src/main/resources/log4j.properties 1.3KB
  31. shardtest/src/main/resources/mybatis-config.xml 541B
  32. shardtest/src/main/resources/rest-servlet.xml 1.16KB
  33. shardtest/src/main/resources/shard_config.xml 608B
  34. shardtest/src/main/webapp/
  35. shardtest/src/main/webapp/WEB-INF/
  36. shardtest/src/main/webapp/WEB-INF/jstl/
  37. shardtest/src/main/webapp/WEB-INF/jstl/c.tld 15.88KB
  38. shardtest/src/main/webapp/WEB-INF/jstl/fmt.tld 19.14KB
  39. shardtest/src/main/webapp/WEB-INF/jstl/fn.tld 7.13KB
  40. shardtest/src/main/webapp/WEB-INF/jstl/sql.tld 8.25KB
  41. shardtest/src/main/webapp/WEB-INF/jstl/x.tld 12KB
  42. shardtest/src/main/webapp/WEB-INF/web.xml 1.7KB
  43. shardtest/src/main/webapp/index.jsp 52B
  44. shardtest/src/main/webapp/shardTest/
  45. shardtest/src/main/webapp/shardTest/shardtestedit.jsp 2.16KB
  46. shardtest/src/main/webapp/shardTest/shardtestlist.jsp 2.31KB
  47. shardtest/src/test/
  48. shardtest/src/test/java/
  49. shardtest/target/
  50. shardtest/target/classes/
  51. shardtest/target/classes/applicationContext.xml 3.38KB
  52. shardtest/target/classes/com/
  53. shardtest/target/classes/com/action/
  54. shardtest/target/classes/com/action/ShardTestAction.class 3.53KB
  55. shardtest/target/classes/com/model/
  56. shardtest/target/classes/com/model/ShardTestBean.class 1.32KB
  57. shardtest/target/classes/com/model/ShardTestBean.xml 2.14KB
  58. shardtest/target/classes/com/service/
  59. shardtest/target/classes/com/service/BaseManager.class 804B
  60. shardtest/target/classes/com/service/ShardStrategyImpl.class 1.25KB
  61. shardtest/target/classes/com/service/ShardTestManager.class 2.75KB
  62. shardtest/target/classes/database.sql 648B
  63. shardtest/target/classes/log4j.properties 1.3KB
  64. shardtest/target/classes/mybatis-config.xml 541B
  65. shardtest/target/classes/rest-servlet.xml 1.16KB
  66. shardtest/target/classes/shard_config.xml 608B
  67. shardtest/target/m2e-wtp/
  68. shardtest/target/m2e-wtp/web-resources/
  69. shardtest/target/m2e-wtp/web-resources/META-INF/
  70. shardtest/target/m2e-wtp/web-resources/META-INF/MANIFEST.MF 108B
  71. shardtest/target/m2e-wtp/web-resources/META-INF/maven/
  72. shardtest/target/m2e-wtp/web-resources/META-INF/maven/com.my/
  73. shardtest/target/m2e-wtp/web-resources/META-INF/maven/com.my/shardtest/
  74. shardtest/target/m2e-wtp/web-resources/META-INF/maven/com.my/shardtest/pom.properties 214B
  75. shardtest/target/m2e-wtp/web-resources/META-INF/maven/com.my/shardtest/pom.xml 3.5KB
  76. shardtest/target/test-classes/

资源介绍:

springmvc下的mybatis的sharding分表,执行resources下的database.sql建立mysql的分表,修改applicationContext.xml的数据库用户名和密码,既可以运行maven项目,详细开发过程如我的博客地址:http://blog.csdn.net/zhulin40/article/details/38705105
package com.action; import java.util.List; import org.apache.commons.lang3.StringUtils; import org.apache.log4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.servlet.ModelAndView; import com.model.ShardTestBean; import com.service.ShardTestManager; /** * /shardTest/1 HTTP GET => 得到id = 1的shardTest /shardTest/1 HTTP DELETE => 删除 id = 1的shardTest * /shardTest/1 HTTP PUT => 更新id = 1的shardTest /shardTest HTTP POST => 新增shardTest * * @author shiling * */ @Controller @RequestMapping("shardTest") public class ShardTestAction { private static Logger log = Logger.getLogger(ShardTestAction.class); @Autowired private ShardTestManager shardTestManager; @RequestMapping(value = "/{id}", method = RequestMethod.GET) public ModelAndView get(@PathVariable String id) { ModelAndView mv = new ModelAndView(); if (StringUtils.isNotEmpty(id)) { mv.addObject("shardTestName", "获取用户信息成功 get" + id); } ShardTestBean shardTestBean = shardTestManager.get(id); mv.addObject("shardTestBean", shardTestBean); mv.setViewName("shardtestedit"); log.info("获取用户信息成功 get"); return mv; } @RequestMapping(value = "/",method = RequestMethod.POST) public ModelAndView add(ShardTestBean shardTestBean) { ModelAndView mv = new ModelAndView(); shardTestManager.add(shardTestBean); mv.addObject("shardTestBean", shardTestBean); mv.setViewName("shardtestedit"); log.info("添加用户信息成功 post"); return mv; } @RequestMapping(value = "/",method = RequestMethod.GET) public ModelAndView list() { ModelAndView mv = new ModelAndView(); List list = shardTestManager.queryForlist(); mv.addObject("list", list); mv.setViewName("shardtestlist"); log.info("查询用户列表信息成功 get"); return mv; } @RequestMapping(value = "/{id}", method = RequestMethod.PUT) public ModelAndView update(@PathVariable String id, ShardTestBean shardTestBean) { ModelAndView mv = new ModelAndView(); if (StringUtils.isNotEmpty(id)) { mv.addObject("shardTestName", "修改用户信息成功 put" + id); } shardTestManager.update(shardTestBean); mv.addObject("shardTestBean", shardTestBean); mv.setViewName("shardtestedit"); log.info("修改用户信息成功 put"); return mv; } @RequestMapping(value = "/{id}", method = RequestMethod.DELETE) public ModelAndView delete(@PathVariable String id, ShardTestBean shardTestBean) { ModelAndView mv = new ModelAndView(); if (StringUtils.isNotEmpty(id)) { mv.addObject("shardTestName", "删除用户信息成功 delete" + id); } shardTestManager.delete(id); mv.addObject("shardTestBean", shardTestBean); mv.setViewName("shardtestedit"); log.info("删除用户信息成功 delete"); return mv; } }
100+评论
captcha