Springmvc+spring+mybatis+mysql configuration Process

Environment: Eclipse

Project directory:

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M00/92/6A/wKiom1j_LX6BegKJAAC6NLMPkqY267.jpg-wh_500x0-wm_ 3-wmp_4-s_814015310.jpg "title=" 33.JPG "alt=" Wkiom1j_lx6begkjaac6nlmpkqy267.jpg-wh_50 "/>

Jar Package:

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M00/92/69/wKioL1j_LOqBaZPFAAEPHoazQk0615.jpg-wh_500x0-wm_ 3-wmp_4-s_98899579.jpg "style=" Float:none; "title=" 11.JPG "alt=" Wkiol1j_loqbazpfaaephoazqk0615.jpg-wh_50 "/>

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M01/92/6A/wKiom1j_LOvjf2EBAABM6ni8aug770.jpg-wh_500x0-wm_ 3-wmp_4-s_207711246.jpg "style=" Float:none; "title=" 22.JPG "alt=" Wkiom1j_lovjf2ebaabm6ni8aug770.jpg-wh_50 "/>

Xml

<?xml version= "1.0"  encoding= "UTF-8"? ><web-app xmlns:xsi= "http://www.w3.org/2001/ Xmlschema-instance "xmlns=" Http://java.sun.com/xml/ns/javaee "xsi:schemalocation=" http://java.sun.com/xml/ns/ Javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd "version=" 3.0 "><display-name>archetype  Created Web Application</display-name><!--configuration files for  spring and MyBatis  -->< Context-param><param-name>contextconfiglocation</param-name><param-value>classpath: hanxuanyuan/config/spring-mybatis.xml</param-value></context-param><!--  Coding Filters  --> <filter><filter-name>encodingFilter</filter-name><filter-class> org.springframework.web.filter.characterencodingfilter</filter-class><async-supported>true</ async-supported><init-param><param-name>encoding</param-name><param-value>utf-8< /param-value></init-param></filter><fIlter-mapping><filter-name>encodingfilter</filter-name><url-pattern>/*</url-pattern ></filter-mapping><!-- spring Listener  --><listener><listener-class> org.springframework.web.context.contextloaderlistener</listener-class></listener><!--  Prevent spring memory Overflow listener  --><listener><listener-class> org.springframework.web.util.introspectorcleanuplistener</listener-class></listener><!--  spring mvc servlet --><servlet><servlet-name>springmvc</servlet-name>< servlet-class>org.springframework.web.servlet.dispatcherservlet</servlet-class><init-param>< param-name>contextconfiglocation</param-name><param-value>classpath:hanxuanyuan/config/ spring-mvc.xml</param-value></init-param><load-on-startup>1</load-on-startup>< Async-supported>true</async-supported></servlet><servlet-mapping><servlet-name>springmvc</servlet-name><!--  Here can be configured as *.do, corresponding to struts ' suffix habits  -->< url-pattern>/</url-pattern></servlet-mapping><welcome-file-list><welcome-file>/ Index.jsp</welcome-file></welcome-file-list></web-app>

Spring-mybatis.xml

<?xml version= "1.0"  encoding= "UTF-8"? ><beans xmlns= "http://www.springframework.org/ Schema/beans "xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance " xmlns:p="/HTTP/ www.springframework.org/schema/p "xmlns:context=" Http://www.springframework.org/schema/context "xmlns:mvc=" http ://www.springframework.org/schema/mvc "xsi:schemalocation=" http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans-3.1.xsd  http:// www.springframework.org/schema/context  http://www.springframework.org/schema/context/ spring-context-3.1.xsd  http://www.springframework.org/schema/mvc  http:// Www.springframework.org/schema/mvc/spring-mvc-4.0.xsd "><!--  Auto Scan  --><context: Component-scan base-package= "Hanxuanyuan"  /><!--  Introducing Profile  --><bean id= " Propertyconfigurer "class=" Org.springframework.beans.factory.config.PropertyPlaceholderConfigurer "><Property name= "Location"  value= "Classpath:hanxuanyuan/config/jdbc.properties"  /></bean ><bean id= "DataSource"  class= "Org.apache.commons.dbcp.BasicDataSource" destroy-method= "Close" ><property name= "Driverclassname"  value= "${driver}"  /><property name= "url"  value= "${url}"  /><property name= "username"  value= "${username}"  />< Property name= "Password"  value= "${password}"  /><!--  Initialize connection size  --><property  name= "InitialSize"  value= "${initialsize}" ></property><!--  Maximum number of connection pools  -->< Property name= "maxactive"  value= "${maxactive}" ></property><!--  Connection pool Max idle  --> <property name= "Maxidle"  value= "${maxidle}" ></property><!--  Connection pool min idle  --> <property name= "Minidle"  value= "${minidle}" ></property><!--  get connection max wait time  -- ><property name= "MaxWait " value=" ${maxwait} "></property></bean><!-- spring and MyBatis Perfect integration, Configuration map files that do not require MyBatis  --><bean id= "sqlsessionfactory"  class= " Org.mybatis.spring.SqlSessionFactoryBean "><property name=" DataSource " ref=" DataSource " / ><!--  Auto-scan mapping.xml file  --><property name= "mapperlocations"  value= "classpath: Hanxuanyuan/mapping/*.xml "></property></bean><!--the package name of the  dao interface, Spring automatically finds the class under it  --> <bean class= "Org.mybatis.spring.mapper.MapperScannerConfigurer" ><property name= "basepackage " value=" Hanxuanyuan.dao " /><property name=" Sqlsessionfactorybeanname " value=" Sqlsessionfactory "></property></bean><!--  (transaction management) Transaction manager, use  jtatransactionmanager for global tx --><bean id= "TransactionManager" class = "Org.springframework.jdbc.datasource.DataSourceTransactionManager"; <property name= "DataSource"  ref= "DataSource"  /></bean></beans> 

Jdbc.properties

Driver=com.mysql.jdbc.driverurl=jdbc:mysql://localhost/cecusername=rootpassword=root#\u5b9a\u4e49\u521d\u59cb\ u8fde\u63a5\u6570initialsize=0#\u5b9a\u4e49\u6700\u5927\u8fde\u63a5\u6570maxactive=20#\u5b9a\u4e49\u6700\u5927 \u7a7a\u95f2maxidle=20#\u5b9a\u4e49\u6700\u5c0f\u7a7a\u95f2minidle=1#\u5b9a\u4e49\u6700\u957f\u7b49\u5f85\ u65f6\u95f4maxwait=60000

Log4j.properties

#\u5b9a\u4e49log\u8f93\u51fa\u7ea7\u522blog4j.rootlogger=info,console,file#\u5b9a\u4e49\u65e5\u5fd7\u8f93\ u51fa\u76ee\u7684\u5730\u4e3a\u63a7\u5236\u53f0log4j.appender.console= Org.apache.log4j.consoleappenderlog4j.appender.console.target=system.out#\u53ef\u4ee5\u7075\u6d3b\u5730\u6307\ U5b9a\u65e5\u5fd7\u8f93\u51fa\u683c\u5f0f\uff0c\u4e0b\u9762\u4e00\u884c\u662f\u6307\u5b9a\u5177\u4f53\u7684\ u683c\u5f0flog4j.appender.console.layout =  Org.apache.log4j.patternlayoutlog4j.appender.console.layout.conversionpattern=[%c] - %m%n#\u6587\ U4ef6\u5927\u5c0f\u5230\u8fbe\u6307\u5b9a\u5c3a\u5bf8\u7684\u65f6\u5019\u4ea7\u751f\u4e00\u4e2a\u65b0\u7684\ U6587\u4ef6log4j.appender.file = org.apache.log4j.rollingfileappender#\u6307\u5b9a\u8f93\u51fa\u76ee \u5f55log4j.appender.file.file = logs/ssm.log#\u5b9a\u4e49\u6587\u4ef6\u6700\u5927\u5927\ U5c0flog4j.appender.file.maxfilesize = 10mb# \u8f93\u51fa\u6240\u4ee5\u65e5\u5fd7\uff0c\u5982\ U679c\u6362\u6210debug\u8868\u793a\u8f93\u51fadebug\u4ee5\u4e0a\u7ea7\u522b\u65e5\u5fd7log4j.appender.file.threshold =  alllog4j.appender.file.layout =  Org.apache.log4j.patternlayoutlog4j.appender.file.layout.conversionpattern =[%p] [%d{yyyy-mm-dd  hh\:mm\:ss}][%c]%m%n

Usercontroller.java

Package Hanxuanyuan.controller;import Javax.annotation.resource;import Org.springframework.stereotype.Controller; Import Org.springframework.ui.model;import Org.springframework.web.bind.annotation.requestmapping;import Hanxuanyuan.domain.user;import Hanxuanyuan.service.UserService; @Controller @requestmapping ("/user") public class Usercontroller {@Resourceprivate userservice userservice; @RequestMapping ("/showuser") public String Showuser (Model Model) {User user = Userservice.selectbyprimarykey ("1"), Model.addattribute ("user", user), return "Welcome";}}

Userservice.java

Package Hanxuanyuan.service;import Hanxuanyuan.domain.user;public interface UserService {void insert (User record); User Selectbyprimarykey (String ID);}

Userserviceimpl.java

Package Hanxuanyuan.service;import Javax.annotation.resource;import Org.springframework.stereotype.service;import Hanxuanyuan.dao.usermapper;import Hanxuanyuan.domain.User; @Service ("UserService") public class Userserviceimpl Implements userservice{@Resourceprivate usermapper usermapper; @Overridepublic void Insert (User record) { Usermapper.insert (record);} @Overridepublic User Selectbyprimarykey (String ID) {return usermapper.selectbyprimarykey (ID);}}

Usermapper.java

Package Hanxuanyuan.dao;import Hanxuanyuan.domain.user;public interface Usermapper {int deletebyprimarykey (String ID)    ;    int Insert (User record);    int insertselective (User record);    User Selectbyprimarykey (String ID);    int updatebyprimarykeyselective (User record); int Updatebyprimarykey (User record);}

Usermapper.xml

<?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=" Hanxuanyuan.dao.UserMapper " >   <resultmap id= "Baseresultmap"  type= "Hanxuanyuan.domain.User"  >     <id column= "id"  property= "id"  jdbctype= "VARCHAR"  />     <result column= "username"  property= "username"  jdbctype= "VARCHAR"  />     <result column= "password"  property= "password"  jdbctype= "VARCHAR"  />     <result column= "Age"  property= "Age"  jdbctype= "VARCHAR"  />     <result column= "Role"  property= "role"  jdbctype= "VARCHAR"  />   </resultmap>  <sql id= "Base_column_list"  >    id, username, password, age, role  </sql>   <select id= "Selectbyprimarykey"  resultmap= "Baseresultmap"  parameterType= " Java.lang.String " >    select     <include refid= "Base_column_list"  />    from user    where id  = #{id,jdbctype=varchar}  </select>  <delete id= "DeleteByPrimaryKey"  parametertype= "Java.lang.String"  >    delete from user     where id = #{id,jdbctype=varchar}  </delete>  <insert  id= "Insert"  parametertype= "Hanxuanyuan.domain.User"  >    insert  into user  (id, username, password,       age, role )     values  (#{id,jdbctype=varchar}, #{username,jdbctype=varchar}, #{password,jdbctype=varchar},        #{age,jdbctype=varchar}, #{role,jdbctype=varchar})   </ Insert>  <insert id= "insertselective"  parametertype= "Hanxuanyuan.domain.User"   >    insert into user    <trim prefix= "("   suffix= ")"  suffixoverrides= ","  >      <if test= "id !=  null " >        id,       </if>      <if test= "Username != null"  >         username,      </if>       <if test= "Password != null"  >         pasSword,      </if>      <if test= "Age  != null " >        age,       </if>      <if test= "Role != null"  >         role,      </if>     </trim>    <trim prefix= "values  ("  suffix= ")"  suffixoverrides= ","  >      <if test= "Id != null"  >        #{id,jdbcType=VARCHAR},       </if>      <if test= "Username != null"   >        #{username,jdbcType=VARCHAR},       </if> &nbSp;    <if test= "Password != null"  >         #{password,jdbcType=VARCHAR},      </if>       <if test= "Age != null"  >         #{age,jdbcType=VARCHAR},      </if>       <if test= "Role != null"  >         #{role,jdbcType=VARCHAR},      </if>     </trim>  </insert>  <update id= "Updatebyprimarykeyselective"   Parametertype= "Hanxuanyuan.domain.User"  >    update user     <set >      <if test= "Username != null"   >        username = #{username,jdbctype=varchar},      </if >      <if test= "Password != null"  >         password = #{password,jdbcType=VARCHAR},       </if>      <if test= "Age != null"  >         age = #{age,jdbcType=VARCHAR},       </if>      <if test= "Role != null"  >        role = #{role,jdbcType=VARCHAR},       </if>    </set>    where  id = #{id,jdbctype=varchar}  </update>  <update id= " Updatebyprimarykey " parametertype= "Hanxuanyuan.domain.User"  >    update user    set  username = #{username,jdbctype=varchar},      password = #{ password,jdbctype=varchar},      age = #{age,jdbctype=varchar},       role = #{role,jdbctype=varchar}    where id  = #{id,jdbcType=VARCHAR}  </update></mapper>

Usermapper,user,usermapper.xml these three files are mybatis-generator automatically generated, their own Baidu is good

How to use: (1) Open the DOS command window, go to the directory, configure the Generatorconfig.xml, run the command:

Java-jar Mybatis-generator-core-1.3.2.jar-configfile Generatorconfig.xml-overwrite

(2) Copy the file to the corresponding location of the project

Jar Package Link: http://down.51cto.com/data/2302826

Project Source Link: Stay put

Do not recommend that you directly see the source code, their own reference to the above codes, to see if you can build out

This article is from "Linux rookie" blog, please be sure to keep this source http://asura1992.blog.51cto.com/8159058/1919362

Springmvc+spring+mybatis+mysql configuration Process