使用idea2017搭建SSM框架(图文步骤)

  4.0.0com.chatRobotChatRobotwar1.0-SNAPSHOTChatRobot Maven Webapphttp://maven.apache.org UTF-8UTF-84.3.5.RELEASE3.4.1  javaxjavaee-api7.0 junitjunit4.12 ch.qos.logbacklogback-classic1.2.2 com.fasterxml.jackson.corejackson-databind2.8.7 mysqlmysql-connector-java5.1.41runtime com.mchangec3p00.9.5.2 org.mybatismybatis${mybatis.version} org.mybatismybatis-spring1.3.1 org.springframeworkspring-core${spring.version} org.springframeworkspring-beans${spring.version} org.springframeworkspring-context${spring.version} org.springframeworkspring-jdbc${spring.version} org.springframeworkspring-tx${spring.version} org.springframeworkspring-web${spring.version} org.springframeworkspring-webmvc${spring.version} org.springframeworkspring-test${spring.version} ChatRobot  org.apache.maven.pluginsmaven-compiler-plugin 1.81.8

     %d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n 

 jdbc.driver=com.mysql.jdbc.Driver #数据库地址 jdbc.url=jdbc:mysql://xxxxxxxxx:3306/ChatRobot?useUnicode=true&characterEncoding=utf8 #用户名 jdbc.username=xxxx #密码 jdbc.password=xxxxx #最大连接数 c3p0.maxPoolSize=30 #最小连接数 c3p0.minPoolSize=10 #关闭连接后不自动commit c3p0.autoCommitOnClose=false #获取连接超时时间 c3p0.checkoutTimeout=10000 #当获取连接失败重试次数 c3p0.acquireRetryAttempts=2

   ChatRobotChatRobot_Alpha_0.0.1 encodingFilterorg.springframework.web.filter.CharacterEncodingFilter encodingUTF-8 encodingFilter/* SpringMVCorg.springframework.web.servlet.DispatcherServlet contextConfigLocationclasspath:spring-*.xml1true SpringMVC/ index.html

 CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `email` varchar(255) NOT NULL COMMENT '用户邮箱', `password` varchar(255) NOT NULL COMMENT '用户密码', `username` varchar(255) NOT NULL COMMENT '用户昵称', `role` varchar(255) NOT NULL COMMENT '用户身份', `status` int(1) NOT NULL COMMENT '用户状态', `regTime` datetime NOT NULL COMMENT '注册时间', `regIp` varchar(255) NOT NULL COMMENT '注册IP', PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; INSERT INTO `user` VALUES ('1', 'xxx', 'xxxxx', 'xxxxx', 'root', '0', '2017-03-28 09:40:31', '127.0.0.1'); SET FOREIGN_KEY_CHECKS=1;

 package com.chatRobot.controller; import javax.servlet.http.HttpServletRequest; import com.chatRobot.model.User; import com.chatRobot.service.IUserService; import com.fasterxml.jackson.databind.ObjectMapper; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; import java.io.IOException; @Controller @RequestMapping("/user") public class UserController { @Resource private IUserService userService; @RequestMapping("/showUser.do") public void selectUser(HttpServletRequest request, HttpServletResponse response) throws IOException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); long userId = Long.parseLong(request.getParameter("id")); User user = this.userService.selectUser(userId); ObjectMapper mapper = new ObjectMapper(); response.getWriter().write(mapper.writeValueAsString(user)); response.getWriter().close(); } }

 package com.chatRobot.dao; import com.chatRobot.model.User; public interface IUserDao { User selectUser(long id); }

 package com.chatRobot.model; import java.util.Date; public class User { private long id; private String email; private String password; private String username; private String role; private int status; private Date regTime; private String regIp; public long getId() { return id; } public void setId(int id) { this.id = id; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getRole() { return role; } public void setRole(String role) { this.role = role; } public int getStatus() { return status; } public void setStatus(int status) { this.status = status; } public Date getRegTime() { return regTime; } public void setRegTime(Date regTime) { this.regTime = regTime; } public String getRegIp() { return regIp; } public void setRegIp(String regIp) { this.regIp = regIp; } }

 package com.chatRobot.service; import com.chatRobot.model.User; public interface IUserService { public User selectUser(long userId); }

 package com.chatRobot.service.impl; import com.chatRobot.dao.IUserDao; import com.chatRobot.model.User; import com.chatRobot.service.IUserService; import org.springframework.stereotype.Service; import javax.annotation.Resource; @Service("userService") public class UserServiceImpl implements IUserService { @Resource private IUserDao userDao; public User selectUser(long userId) { return this.userDao.selectUser(userId); } }

    SELECT * FROM user WHERE id = #{id} 

 package com.chatRobot.dao; import com.chatRobot.model.User; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; // 加载spring配置文件 @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration({"classpath:spring-mybatis.xml"}) public class IUserDaoTest { @Autowired private IUserDao dao; @Test public void testSelectUser() throws Exception { long id = 1; User user = dao.selectUser(id); System.out.println(user.getUsername()); } }

    
Hello World!
onclick test