Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Springmvc+spring+mybatis+mysql configuration process

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Environment: eclipse

Project catalog:

Jar package:

Web.xml

Archetype Created Web ApplicationcontextConfigLocationclasspath:hanxuanyuan/config/spring-mybatis.xmlencodingFilterorg.springframework.web.filter.CharacterEncodingFiltertrueencodingUTF-8encodingFilter/*org.springframework.web.context.ContextLoaderListenerorg.springframework.web.util.IntrospectorCleanupListenerSpringMVCorg.springframework.web.servlet.DispatcherServletcontextConfigLocationclasspath:hanxuanyuan/config/spring-mvc.xml1trueSpringMVC//index.jsp

Spring-mybatis.xml

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.rootLoggerInfofoForceConsol 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\ u6307\ u5B9A\ u65E5\ u5FD7\ 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\ u5230\ u8FBE\ u6307\ u5B9A\ u5C3A\ u5BF8\ u7684\ u65F6\ u5019\ u4EA7\ u751F\ u4E00\ u4E2A\ u65B0\ u7684\ u4EF6log4j.appender.File = org.apache.log4j.RollingFileAppender#\ u6307\ u5B9A\ u8F93\ u51FA\ u76EE\ u5F55log4j.appender.File.File = logs/ssm.log#\ u5B9A\ u4E49\ u6587\ u4EF6\ u5927\ u5927\ u5C0Flog4j.appender.File.MaxFileSize = 10MB#\ U8F93\ u51FA\ u6240\ u4EE5\ u65E5\ u5FD7\ uFF0C\ u5982\ u679C\ u6362\ u6210DEBUG\ u8868\ u793A\ u8F93\ 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

Id, username, password, age, role select from user where id = # {id,jdbcType=VARCHAR} delete from user where id = # {id,jdbcType=VARCHAR} 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 into user id Username, password, age, role, # {id,jdbcType=VARCHAR}, # {username,jdbcType=VARCHAR}, # {password,jdbcType=VARCHAR}, # {age,jdbcType=VARCHAR} # {role,jdbcType=VARCHAR}, update user username = # {username,jdbcType=VARCHAR}, password = # {password,jdbcType=VARCHAR}, age = # {age,jdbcType=VARCHAR}, role = # {role,jdbcType=VARCHAR}, where id = # {id,jdbcType=VARCHAR} update user set username = # {username JdbcType=VARCHAR}, password = # {password,jdbcType=VARCHAR}, age = # {age,jdbcType=VARCHAR}, role = # {role,jdbcType=VARCHAR} where id = # {id,jdbcType=VARCHAR}

UserMapper,User,UserMapper.xml these three files are automatically generated by mybatis-generator, http://pan.baidu.com/s/1cvQWsY

How to use it: (1) Open the dos command window, enter the directory, and after configuring 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: http://pan.baidu.com/s/1o7H6WUu

It is not recommended that you look at the source code directly. Refer to the above code and see if you can build it yourself.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report