IDEA+Maven+Spring+SpringMVC+SpringJDBC整合Demo
来源:互联网 发布:淘宝发货需要身份证 编辑:程序博客网 时间:2024/06/08 08:13
项目结构
项目说明
一个简单的网站登陆注册web项目Demo,基于最新版的IDEA15+Maven3+Spring4.2.5+SpringMVC4.2.5+SpringJDBC4.2.5实现
pom.xml文件
<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.zzkun</groupId> <artifactId>MySpring</artifactId> <version>1.0-SNAPSHOT</version> <properties> <maven.compiler.source>1.8</maven.compiler.source> <maven.compiler.target>1.8</maven.compiler.target> </properties> <dependencies> <dependency> <groupId>org.apache.tomcat</groupId> <artifactId>tomcat-catalina</artifactId> <version>8.0.30</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.2.5.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.2.5.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.2.5.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>4.2.5.RELEASE</version> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.8.9</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.38</version> </dependency> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <dependency> <groupId>jstl</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> </dependencies></project>
web.xml
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <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:springmvc-servlet.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>springmvc</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <filter> <filter-name>CharacterEncodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping></web-app>
springmvc-servlet.xml (spring配置文件)
<?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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <context:property-placeholder location="classpath:jdbc.properties"/> <context:component-scan base-package="com.zzkun.controller"/> <context:component-scan base-package="com.zzkun.service"/> <context:component-scan base-package="com.zzkun.dao"/> <mvc:annotation-driven/> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="${jdbc.driverClassName}"/> <property name="jdbcUrl" value="${jdbc.url}"/> <property name="user" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <!--连接池中保留的最小连接数。 --> <property name="minPoolSize" value="5"/> <!--连接池中保留的最大连接数。Default: 15 --> <property name="maxPoolSize" value="30"/> <!--初始化时获取的连接数,取值应在minPoolSize与maxPoolSize之间。Default: 3 --> <property name="initialPoolSize" value="10"/> <!--最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 --> <property name="maxIdleTime" value="60"/> <!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 --> <property name="acquireIncrement" value="5"/> <!--JDBC的标准参数,用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements 属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。 如果maxStatements与maxStatementsPerConnection均为0,则缓存被关闭。Default: 0 --> <property name="maxStatements" value="0"/> <!--每60秒检查所有连接池中的空闲连接。Default: 0 --> <property name="idleConnectionTestPeriod" value="60"/> <!--定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 --> <property name="acquireRetryAttempts" value="30"/> <!--获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效 保留,并在下次调用getConnection()的时候继续尝试获取连接。如果设为true,那么在尝试 获取连接失败后该数据源将申明已断开并永久关闭。Default: false --> <property name="breakAfterAcquireFailure" value="true"/> <!--因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的 时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable 等方法来提升连接测试的性能。Default: false --> <property name="testConnectionOnCheckout" value="false"/> </bean> <!-- 配置Jdbc模板 --> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" p:dataSource-ref="dataSource" /> <!-- 通过AOP配置提供事务增强,让service包下所有Bean的所有方法拥有事务 --> <aop:config proxy-target-class="true"> <aop:pointcut id="serviceMethod" expression=" execution(* com.zzkun.service..*(..))" /> <aop:advisor pointcut-ref="serviceMethod" advice-ref="txAdvice" /> </aop:config> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="*" /> </tx:attributes> </tx:advice></beans>
jdbc.properties(SpringJDBC配置文件)
jdbc.driverClassName = com.mysql.jdbc.Driverjdbc.url = jdbc:mysql://localhost:3306/mytest1?characterEncoding=utf8&useSSL=truejdbc.username = rootjdbc.password = ******
model层(User)
package com.zzkun.model;import java.io.Serializable;import java.io.SerializablePermission;/** * Created by kun on 2016/5/5. */public class User implements Serializable { private int id; private String username; private String password; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; }}
DAO层(UserDao)
package com.zzkun.dao;import com.zzkun.model.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowCallbackHandler;import org.springframework.stereotype.Repository;import java.sql.ResultSet;import java.sql.SQLException;/** * Repository用于标注数据访问组件,即DAO组件 * Created by kun on 2016/5/5. */@Repositorypublic class UserDao { @Autowired private JdbcTemplate jdbcTemplate; public void register(User user) { String sql = "insert into user(username, password) values(?, ?)"; jdbcTemplate.update(sql, user.getUsername(), user.getPassword()); } public User findUserByUserName(String userName) { String sql = "select id, username, password from user where username=?"; User user = new User(); jdbcTemplate.query(sql, new Object[]{userName}, new RowCallbackHandler() { @Override public void processRow(ResultSet resultSet) throws SQLException { user.setId(resultSet.getInt("id")); user.setUsername(resultSet.getString("username")); user.setPassword(resultSet.getString("password")); } }); return user; }}
Service层(UserService)
package com.zzkun.service;import com.zzkun.dao.UserDao;import com.zzkun.model.User;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;/** * Service用于标注业务层组件 * Created by kun on 2016/5/5. */@Servicepublic class UserService { @Autowired private UserDao userDao; public boolean register(User user) { User u = userDao.findUserByUserName(user.getUsername()); if(u.getId() == 0) { userDao.register(user); return true; } return false; } public boolean loginCheck(User user) { User u = userDao.findUserByUserName(user.getUsername()); return user.getPassword().equals(u.getPassword()); }}
Controller层(UserController)
package com.zzkun.controller;import com.zzkun.model.User;import com.zzkun.service.UserService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.servlet.ModelAndView;/** * Controller用于标注控制层组件 * Created by kun on 2016/5/5. */@Controller@RequestMapping(value = "/user")public class UserController { @Autowired private UserService userService; @RequestMapping("/loginView") public String loginView(){ return "login.jsp"; } @RequestMapping("/login") public ModelAndView login(User user){ ModelAndView mav = new ModelAndView(); System.out.println(user.getUsername() + " " + user.getPassword()); if(!userService.loginCheck(user)) { mav.setViewName("login.jsp"); mav.addObject("errorMsg", "用户名或密码错误!"); } else { mav.setViewName("success.jsp"); mav.addObject("user", user); } return mav; }}
用户服务测试类(UserServiceTest)
package com.zzkun.service;import com.zzkun.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;import static org.junit.Assert.*;/** * Created by kun on 2016/5/5. */@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(locations = "classpath:springmvc-servlet.xml")public class UserServiceTest { @Autowired private UserService userService; @Test public void register() throws Exception { User user = new User(); user.setUsername("zzk"); user.setPassword("123456"); assertEquals(true, userService.register(user)); } @Test public void loginCheck() throws Exception { User user = new User(); user.setUsername("zzk"); user.setPassword("123456"); assertEquals(true, userService.loginCheck(user)); user.setPassword("111111"); assertEquals(false, userService.loginCheck(user)); }}
login.jsp页面
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%-- Created by IntelliJ IDEA. User: kun Date: 2016/5/5 Time: 16:18 To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>用户登录</title></head><body> <c:if test="${!empty errorMsg}"> <h3>${errorMsg}</h3> </c:if> <form action="login" method="post"> <h2>欢迎登陆</h2> <p> <label for="username">用户名</label> <input type="text" id="username" name="username"> </p> <p> <label for="password">密码</label> <input type="password" id="password" name="password"> </p> <p> <input type="submit" value="登陆"> </p> </form></body></html>
success.jsp页面
<%-- Created by IntelliJ IDEA. User: kun Date: 2016/5/5 Time: 16:23 To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head> <title>登陆成功</title></head><body> <h3>恭喜${user.username}, 登陆成功!</h3></body></html>
网站测试
github源代码
https://github.com/kun368/MySpring
0 0
- IDEA+Maven+Spring+SpringMVC+SpringJDBC整合Demo
- SpringMVC + Spring + SpringJDBC整合
- SpringMVC + Spring + SpringJDBC整合
- SpringMVC + Spring + SpringJDBC整合
- SpringMVC + Spring + SpringJDBC整合
- SpringMVC + Spring + SpringJDBC整合
- SpringMVC + Spring + SpringJDBC整合
- SpringMVC +Spring+ SpringJDBC整合实例。
- SpringMVC+Spring+SpringJDBC整合配置
- SpringMVC +Spring+ SpringJDBC 整合 教程
- Intellij-IDEA-maven+springMVC+mybatis整合DEMO
- Idea SpringMVC+Spring+MyBatis+Maven整合
- Idea SpringMVC+Spring+MyBatis+Maven整合
- Idea SpringMVC+Spring+MyBatis+Maven整合
- springmvc+spring+mybatis整合demo(maven)
- IDEA Maven + SpringMVC DEMO
- 使用Idea创建ssm项目,SpringMVC+Spring+MyBatis+Maven整合
- SSM框架整合(IntelliJ IDEA + maven + Spring + SpringMVC + MyBatis)
- 面向对象的3个基本要素和5个基本设计原则
- 接口
- AngularJS学习记录-过滤器(排序方式过滤)
- HDU 2612 Find a way(两次BFS)
- 第十周项目—阅读程序,写出执行结果(1)
- IDEA+Maven+Spring+SpringMVC+SpringJDBC整合Demo
- NYOJ 题目860 又见01背包
- java classloader机制
- UML画图总结
- HDFS的实现思想和概念
- UVa 1339 Ancient Cipher
- KVM管理工具:webvirtmgr增加磁盘扩容功能
- 关于堆栈的一点认识
- java junit测试