1、创建一个maven项目
2、pom.xml导入依赖jar包(这里需要注意的是jar包的完整性,不然会报错)
Junit,spring-test:用于单元测试(不测试可以不加);spring-data-jpa(1.11.3);spring-webmvc(4.3.8);hibernate-core(5.0.11);hibernate-entitymanager(5.0.11);javax.servlet-api(3.1.0);javax.servet.jsp-api(2.2.1);Jstl(1.2),standard(1.1.2):在项目中使用JSTL和EL表达式;mysql-connector-java(5.1.29):数据库驱动;c3p0(0.9.5);jackson-databind(2.9.6):用于数据返回(版本太低不支持);slf4j-log4j12(1.6.4)
3、创建数据库驱动文件:db.properties
jdbc.jdbcUrl=jdbc:mysql://localhost:3306/sss
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.user=root
jdbc.password=root
4、创建打印日志的文件:log4j.properties
log4j.rootLogger=INFO,Console,File
#\u5B9A\u4E49\u65E5\u5FD7\u8F93\u51FA\u76EE\u7684\u5730\u4E3A\u63A7\u5236\u53F0
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.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\u5F0F
log4j.appender.Console.layout = org.apache.log4j.PatternLayout
log4j.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\u4EF6
log4j.appender.File = org.apache.log4j.RollingFileAppender
#\u6307\u5B9A\u8F93\u51FA\u76EE\u5F55
log4j.appender.File.File = logs/ssm.log
#\u5B9A\u4E49\u6587\u4EF6\u6700\u5927\u5927\u5C0F
log4j.appender.File.MaxFileSize = 10MB
# \u8F93\u51FA\u6240\u4EE5\u65E5\u5FD7\uFF0C\u5982\u679C\u6362\u6210DEBUG\u8868\u793A\u8F93\u51FADEBUG\u4EE5\u4E0A\u7EA7\u522B\u65E5\u5FD7
log4j.appender.File.Threshold = ALL
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-dd HH\:mm\:ss}][%c]%m%n
5、创建spring框架配置文件:applicationContext.xml
<!-- 扫描包,使用注解可以生成实体 -->
<context:component-scan base-package="com.dream" />
<!--属性文件位置 -->
<beanclass="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"
id="annotationPropertyConfigurer">
<!-- 忽略没有找到的资源文件 -->
<property name="ignoreResourceNotFound" value="true" />
<!-- 配置资源文件 -->
<property name="locations">
<list>
<value>classpath:db.properties</value>
<value>classpath:log4j.properties</value>
</list>
</property>
</bean>
<!--配置数据源 c3p0 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
<property name="driverClass" value="${jdbc.driverClass}"></property>
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!--配置 JPA 的 EntityManagerFactory -->
<bean
class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"
id="entityManagerFactory">
<property name="dataSource" ref="dataSource"></property>
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"></bean>
</property>
<property name="packagesToScan" value="com.dream.bean" />
<property name="jpaProperties">
<props>
<!-- 生成的数据表的列的映射策略 -->
<prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>
<!-- hibernate 基本属性 -->
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean>
<!--配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory" />
</bean>
<!--开启事务注解支持 -->
<tx:annotation-driven transaction-manager="transactionManager" />
<!--配置 SpringData,需要加入 jpa 的命名空间 -->
<!-- base-package: 扫描 Repository Bean 所在的 package -->
<jpa:repositories base-package="com.dream.dao"
entity-manager-factory-ref="entityManagerFactory">
</jpa:repositories>
6、创建springmvc框架配置文件:springmvc.xml
<!-- 扫表包:控制层包 -->
<context:component-scan base-package="com.dream.controller" />
<!-- 视图解析器 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- jsp所在的位置 -->
<property name="prefix" value="/WEB-INF/jsp/"></property>
<!-- 文件后缀 -->
<property name="suffix" value=".jsp"></property>
</bean>
7、web.xml文件中的配置
<!-- 添加Spring的上下文环境监听 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<!-- 添加Springmvc的上下文环境监听 -->
<servlet>
<servlet-name>DispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 配置DispatcherServlet的初始化參數:设置文件的路径和文件名称 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>DispatcherServlet</servlet-name>
<!--这是REST URL风格的要求 -->
<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>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
8、创建实体类(注解模式)(配置了数据库自动创建表,不需要自己创建)
@Entity
@Table(name="user")
public class User {
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Integer id;
@Column
private String username;//姓名
@Column
private String password;//密码
public Integer getId() {
return id;
}
public void setId(Integer 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;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password=" + password + "]";
}
}
9、创建dao层,继承JpaRepository,JpaSpecificationExecutor接口
public interface IUserDAO extends JpaRepository<User, Serializable>,JpaSpecificationExecutor<User>{
@Query("from User where username=?1")
User findOneUserByUsername(String username);
}
10、创建service层(注解注入dao层对象)
@Service
@Transactional
public class UserService implements IUserService{
@Autowired
IUserDAO userDAO;
@Override
public User addUser(User u) {
if (null==u||"".equals(u.getUsername())||"".equals(u.getPassword())) {
return null;
}else {
User user = userDAO.findOneUserByUsername(u.getUsername());
if (null!=user) {
return null;
}else {
return userDAO.save(u);
}
}
}
@Override
public User findUserByUsername(User u) {
if (null!=u&&!"".equals(u.getUsername())&&!"".equals(u.getPassword())) {
User user = userDAO.findOneUserByUsername(u.getUsername());
if (user.getPassword().equals(u.getPassword())) {
return user;
}
}
return null;
}
}
11、创建controller层(注解注入service层对象)
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
IUserService userService;
@RequestMapping("/regist")
public void regist(Model model,User user,HttpServletRequest request,HttpServletResponse response) throws Exception{
response.setContentType("text/html;charset=utf-8");
User user2 = userService.addUser(user);
if (null!=user2) {
response.getWriter().write("<script>alert('注册成功');location.href='"+request.getContextPath()+"/page/login';</script>");
}else {
response.getWriter().write("<script>alert('注册失败');location.href='"+request.getServletContext().getContextPath()+"/page/regist';</script>");
}
}
@RequestMapping("/login")
public void login(Model model,User user,HttpServletRequest request,HttpServletResponse response) throws Exception{
response.setContentType("text/html;charset=utf-8");
User user2 = userService.findUserByUsername(user);
if (null!=user2) {
response.getWriter().write("<script>alert('登陆成功');location.href='"+request.getContextPath()+"/page/index';</script>");
}else {
response.getWriter().write("<script>alert('登陆失败');location.href='"+request.getContextPath()+"/page/login';</script>");
}
}
}
这里写一个页面跳转帮助类
@Controller
public class PageController {
@RequestMapping("/page/{page}")
public String skip(@PathVariable(value="page") String page){
return page;
}
}
12、创建前台页面
//注册
<form action="${pageContext.request.contextPath}/user/regist"
method="post" id="registForm">
<input type="hidden" name="method" value="regist">
<div class="control-group">
<div class="controls">
<div class="input-icon left">
<i class="icon-user"></i> <input class="m-wrap placeholder-no-fix"
type="text" placeholder="帐号" id="username" name="username">
</div>
</div>
</div>
<div class="control-group">
<div class="controls">
<div class="input-icon left">
<i class="icon-lock"></i> <input class="m-wrap placeholder-no-fix"
type="password" placeholder="密码" id="password" name="password">
</div>
</div>
</div>
<div class="relogin">
<!-- 单击注册 -->
<button type="submit" id="login-submit-btn" class="btn green"
style="margin-left: 20px">
注册 <i class="m-icon-swapright m-icon-white"></i>
</button>
</div>
</form>
//登录
<form action="${pageContext.request.contextPath}/user/login"
method="post" id="loginForm">
<input type="hidden" name="method" value="login">
<div class="control-group">
<div class="controls">
<div class="input-icon left">
<i class="icon-user"></i> <input class="m-wrap placeholder-no-fix"
type="text" placeholder="帐号" id="username" name="username">
</div>
</div>
</div>
<div class="control-group">
<div class="controls">
<div class="input-icon left">
<i class="icon-lock"></i> <input class="m-wrap placeholder-no-fix"
type="password" placeholder="密码" id="password" name="password">
</div>
</div>
</div>
<div class="relogin">
<!-- 单击登录 -->
<button type="submit" id="login-submit-btn" class="btn green"
style="margin-left: 20px">
登陆 <i class="m-icon-swapright m-icon-white"></i>
</button>
</div>
</form>