eclipse 创建maven 项目 动态web工程完整示例 maven 整合springmvc整合mybatis

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
    http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
    
<!--   <display-name>Archetype Created Web Application</display-name> -->
  
  <!-- 1,从类路径下加载spring的配置文件,classpath关键字特指类路径下加载 -->
    <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
    
    </context-param>
    <!--2,负责启动spring容器的监听器,它将引用1处的上下文参数,获得spring配置文件的地址  -->
    <listener>
    <listener-class>
    org.springframework.web.context.ContextLoaderListener
    </listener-class>
    </listener>
    
    <servlet>
        <servlet-name>bbs</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <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>bbs</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>
  
  
  
  
</web-app>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:mvc="http://www.springframework.org/schema/mvc" 
    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"
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
        http://www.springframework.org/schema/beans/spring-beans-4.2.xsd 
        http://www.springframework.org/schema/context 
        http://www.springframework.org/schema/context/spring-context-4.2.xsd 
        http://www.springframework.org/schema/mvc 
        http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd">

    <!-- 自动扫描带有@Controller注解的控制层，注入为bean -->
    <context:component-scan base-package="com.noteless.bbs.controller" />
    
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/" />
        <property name="suffix" value=".jsp" />
    </bean>
    


    
</beans>

<?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:p="http://www.springframework.org/schema/p"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd">



    <!--扫描类包,标注spring注解的类自动转换成bean,同时完成bean的注入  (这样类中定义的spring注解  比如@repository @autowired等才能起作用)  -->
    <context:component-scan base-package="com.noteless.bbs.domain" />
    
        <!--扫描service包,应用spring注解配置  -->
    <context:component-scan base-package="com.noteless.bbs.service" />
    
    
<!-- 定义一个使用DBCP实现的数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
    destroy-method="close"
    p:driverClassName="com.mysql.jdbc.Driver"
    p:url="jdbc:mysql://localhost:3306/sampledb"
    p:username="root"
    p:password="123456"/>
    
    
    <!-- myBatis文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 自动扫描映射文件 -->
        <property name="mapperLocations">
            <array>
                <value>classpath:mapper/*.xml</value>
            </array>
        </property>

    </bean>

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.noteless.bbs.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
    </bean>
    

</beans>

### set log levels ###
log4j.rootLogger = DEBUG,stdout,D


### 输出到控制台 ###
log4j.appender.stdout = org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target = System.out
log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern = [%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} method:%l%n%m%n


### 输出DEBUG 级别以上的日志到=E://logs/error.log ###
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = C://Users/joy/\Desktop/logs/log.log
log4j.appender.D.Append = true
log4j.appender.D.Threshold = DEBUG 
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ]  %m%n

### sql ###
log4j.logger.java.sql.Connection=DEBUG 
log4j.logger.java.sql.PreparedStatement=DEBUG  
log4j.logger.java.sql.ResultSet=DEBUG

package com.noteless.bbs.controller;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.noteless.bbs.domain.User;
import com.noteless.bbs.service.UserService;



@Controller
public class LoginController {

    @Autowired
    private UserService userService;
    
    @RequestMapping(value="/welcome")
    public String toLoginWelconenPage(HttpServletRequest request){

        return "welcome";
    }
    

    
    @RequestMapping(value="/login")
    public String toLoginPage(HttpServletRequest request){

        return "login";
    }
    
    
    @RequestMapping(value="/checkLogin")
    public String loginPage(HttpServletRequest request,User user){
        
        Boolean loginSucess = userService.hasMatchUser(user);
        if(loginSucess){
            userService.loginSucess(userService.findUserByUserName(user));
            request.getSession().setAttribute("Info","");
            return "welcome";
        }else{
            request.getSession().setAttribute("Info","请重新输入!!");
            return "redirect:/login.do";
        }
        
    }
}

package com.noteless.bbs.dao;

import com.noteless.bbs.domain.LoginLog;

public interface LoginLogMapper {

    public void insertLoginLog(LoginLog loginLog);
}

package com.noteless.bbs.dao;

import com.noteless.bbs.domain.User;

public interface UserMapper {
    
    public Integer getMatchCount(User user);

    
    public User findUserByUserName(User user);

    
    public void updateLoginInfo(User user);
    
    public void insertUser(User user);
    
    public void updateUserInfo(User user);
}

package com.noteless.bbs.domain;

import java.io.Serializable;
import java.util.Date;

public class LoginLog implements Serializable{
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    private int loginLogId;
    private int userId;
    private String ip;
    private Date loginDate;
    public int getLoginLogId() {
        return loginLogId;
    }
    public void setLoginLogId(int loginLogId) {
        this.loginLogId = loginLogId;
    }
    public int getUserId() {
        return userId;
    }
    public void setUserId(int userId) {
        this.userId = userId;
    }
    public String getIp() {
        return ip;
    }
    public void setIp(String ip) {
        this.ip = ip;
    }
    public Date getLoginDate() {
        return loginDate;
    }
    public void setLoginDate(Date loginDate) {
        this.loginDate = loginDate;
    }
    
    
}

package com.noteless.bbs.domain;

import java.io.Serializable;
import java.util.Date;


public class User implements Serializable{

    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    private int userId;
    private String userName;
    private String password;
    private int credits;
    private String lastIp;
    private Date lastVisit;
    
    
    public int getUserId() {
        return userId;
    }
    public void setUserId(int userId) {
        this.userId = userId;
    }
    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;
    }
    public int getCredits() {
        return credits;
    }
    public void setCredits(int credits) {
        this.credits = credits;
    }
    public String getLastIp() {
        return lastIp;
    }
    public void setLastIp(String lastIp) {
        this.lastIp = lastIp;
    }
    public Date getLastVisit() {
        return lastVisit;
    }
    public void setLastVisit(Date date) {
        this.lastVisit = date;
    }
    
    
}

package com.noteless.bbs.service;

import com.noteless.bbs.domain.LoginLog;

public interface LoginLogService {

    public void insertLoginLog(LoginLog loginLog);
}

package com.noteless.bbs.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.noteless.bbs.dao.LoginLogMapper;
import com.noteless.bbs.domain.LoginLog;

@Service
public class LoginLogServiceImpl implements LoginLogService {

    @Autowired
    private LoginLogMapper loginLogMapper;
    @Override
    public void insertLoginLog(LoginLog loginLog) {
        loginLogMapper.insertLoginLog(loginLog);
        
    }

}

package com.noteless.bbs.service;

import com.noteless.bbs.domain.User;

public interface UserService {

    public Boolean hasMatchUser(User user);
    
    
    public User findUserByUserName(User user);
    
    
    public void loginSucess(User user);
    
    public void insertUser(User user);


    public void UpdateUser(User user);

}

package com.noteless.bbs.service;

import java.util.Date;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.noteless.bbs.dao.UserMapper;
import com.noteless.bbs.domain.LoginLog;
import com.noteless.bbs.domain.User;



@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper userMapper;
    @Autowired
    private LoginLogService loginLogService;
    
    @Override
    public Boolean hasMatchUser(User user) {
        
        Integer matchCount = userMapper.getMatchCount(user);
        if(matchCount > 0){
            return true;
        }else{
            return false;
        }


    }

    @Override
    public User findUserByUserName(User user) {
        return userMapper.findUserByUserName(user);
    }

    @Override
    public void loginSucess(User user) {

        user.setCredits(5+user.getCredits());
        user.setLastVisit(new Date());
        
        LoginLog loginLog = new LoginLog();
        
        loginLog.setUserId(user.getUserId());
        loginLog.setIp(user.getLastIp());
        loginLog.setLoginDate(new Date());
        
        
        userMapper.updateLoginInfo(user);
        loginLogService.insertLoginLog(loginLog);
    }

    @Override
    public void insertUser(User user) {
        userMapper.insertUser(user);
    }
    
    @Override
    public void UpdateUser(User user) {
        userMapper.updateUserInfo(user);
    }
    

}

<?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="com.noteless.bbs.dao.LoginLogMapper">

   <insert id="insertLoginLog" parameterType="com.noteless.bbs.domain.LoginLog">
        insert into t_login_log(
            user_id,
            ip,
            login_datetime
        ) 
        values(
            #{userId},
            #{ip},
            #{loginDate}
        )
    </insert>
    
</mapper>

<?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="com.noteless.bbs.dao.UserMapper">

    <select id="getMatchCount" parameterType="com.noteless.bbs.domain.User"
        resultType="java.lang.Integer">
        SELECT count(*)
        FROM
        t_user
        WHERE
        user_name=#{userName}
        and password=#{password}
    </select>

    <select id="findUserByUserName" parameterType="com.noteless.bbs.domain.User"
        resultType="com.noteless.bbs.domain.User">
        SELECT
        t_user.user_id as userId,
        t_user.user_name as userName,
        t_user.credits as credits,
        t_user.password as password,
        t_user.last_ip as lastIp,
        t_user.last_visit as lastVisit


        FROM
        t_user
        WHERE
        user_name=#{userName}
    </select>


    <update id="updateLoginInfo" parameterType="com.noteless.bbs.domain.User">

        UPDATE t_user
        <set>
            <if test="lastVisit !=null">
                last_visit = #{lastVisit},
            </if>
            <if test="lastIp !=null and lastIp !=''">
                last_ip = #{lastIp},
            </if>
            <if test="credits !=null and credits !=''">
                credits = #{credits},
            </if>

        </set>
        where user_id=#{userId}
    </update>

    <insert id="insertUser" parameterType="com.noteless.bbs.domain.User">
        insert into t_user(
        user_name,
        credits,
        password,
        last_ip,
        last_visit
        )
        values(
        #{userName},
        #{credits},
        #{password},
        #{lastIp},
        #{lastVisit}

        )
    </insert>



    <update id="updateUserInfo" parameterType="com.noteless.bbs.domain.User">

        UPDATE t_user

        <set>
            <if test="lastVisit !=null">
                last_visit = #{lastVisit},
            </if>
            <if test="lastIp !=null and lastIp !=''">
                last_ip = #{lastIp},
            </if>
            <if test="credits !=null and credits !=''">
                credits = #{credits},
            </if>

        </set>
        where user_id=#{userId}
    </update>


</mapper>

package com.noteless.bbs;

import static org.junit.Assert.*;

import java.util.Date;

import org.apache.log4j.Logger;
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 com.noteless.bbs.domain.User;
import com.noteless.bbs.service.UserService;



@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"/applicationContext.xml"})

public class TestUserService {

    @Autowired
    private UserService userService;
    

    
    private static Logger logger = Logger.getLogger(Test.class);  
    
    @Test
    public void testLog(){
        
        logger.debug("this is a debug info");
        
    }
    
    @Test 
    public void hasMAtchUser(){
        User user1 = new User();
        User user2 = new User();
        
        user1.setUserName("admin");
        user1.setPassword("123456");
        
        user2.setUserName("admin");
        user2.setPassword("11111");
        
        
        boolean b1 = userService.hasMatchUser(user1);
        //boolean b2 = userService.hasMatchUser(user2);
        
        assertTrue(b1);
        //assertTrue(b2);
        
        
        
    }
    
    @Test
    public void findUserByUserName(){
        User user = new User();
        
        user.setUserName("admin");

        
        User user1 = userService.findUserByUserName(user);
        System.out.println(user1.getUserName());
        assertEquals(user1.getUserName(),"admin");
    }

    @Test
    public void loginSucess(){
        
        User user = new User();
        user.setUserName("admin");
        user= userService.findUserByUserName(user);
        userService.loginSucess(user);
    
    }
    
    @Test
    public void insertUser(){
        
        User user = new User();
        user.setUserName("user1");
        user.setPassword("123456");
        user.setCredits(0);
        user.setLastIp("255.255.255.255");
        user.setLastVisit(new Date(0) );
        
        userService.insertUser(user);
        

    
    }
    @Test
    public void updateUserInfo(){
        
        User user = new User();
        user.setUserId(2);
        user.setLastVisit(new Date() );
        user.setCredits(5+user.getCredits());

        
        userService.UpdateUser(user);
        

    
    }
    
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>


<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>标题</title>
</head>
<body>

${Info}


请输入用户名,密码登陆:
<form action="/springmvcMaven/checkLogin.do" meathod="post">
用户名:
<input type="text" name="userName">
<br>
密码:
<input type="password" name="password">
<br>

<input type="submit" value="登陆">
<input type="reset" value="重置">
</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>标题</title>
</head>
<body>
欢迎光临!
<br>
欢迎光临!
</body>
</html>