详细搭建简单的ssm框架(四)

4.5、jdbc.properties：

driverClassName=com.mysql.jdbc.Driver

url=jdbc:mysql://127.0.0.1:3306/login?useUnicode=true&characterEncoding=utf-8

username=root

password=123

validationQuery=SELECT 1

 

4.6、log4j.properties：

##### \u65e5\u5fd7\u914d\u7f6e\u8d44\u6e90\u6587\u4ef6\uff1a

##### \u63cf\u8ff0\u65e5\u5fd7\u8bb0\u5f55\u76f8\u5173\u914d\u7f6e\u4fe1\u606f

log4j.rootCategory=INFO,stdout,logfile

 

log4j.rootLogger=info,stdout

 

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=%d{yyyy-MM-dd HH:mm:ss} %c{1}:%L %5p - %m%n

 

log4j.logger.com.netqin=INFO

log4j.logger.org.springframework=INFO

 

 

log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender

log4j.appender.logfile.DatePattern='.'yyyy-MM-dd

log4j.appender.logfile.File=D:/tomcat.log

log4j.appender.logfile.layout=org.apache.log4j.PatternLayout

log4j.appender.logfile.layout.ConversionPattern=%d %p [%X{userName}][%X{userLocale}][%c] - <%m>%n

 

 

 

5、生成对应的文件夹和文件：

5.1、dao层：

package com.peihua.dao;

 

import org.apache.ibatis.annotations.Param;

 

import com.peihua.po.Employee;

 

public interface UserDao {

public Employee login(@Param("username") String username,@Param("password") String password);

 

}

5.2、mapping层：

<?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.peihua.dao.UserDao">

 

<select id="login" resultType="com.peihua.po.Employee">

SELECT u.* FROM employee u

where u.username = #{username,jdbcType=VARCHAR} and u.password=#{password,jdbcType=VARCHAR}

</select>

</mapper>

 

5.3、service层：

接口：

package com.peihua.service;

 

import org.apache.ibatis.annotations.Param;

 

import com.peihua.po.Employee;

 

public interface UserService {

public Employee login(@Param("username") String ename,@Param("password") String password);

}

实现类：

package com.peihua.service.impl;

 

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

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;

 

import com.peihua.dao.UserDao;

import com.peihua.po.Employee;

import com.peihua.service.UserService;

@Transactional

@Service("userservice")

public class UserServiceImpl implements UserService {

@Autowired

private UserDao userdao;

 

@Override

public Employee login(String username, String password) {

return userdao.login(username, password);

}

 

}

5.4、web层：

package com.peihua.web;

 

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

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;

 

 

import com.peihua.po.Employee;

 

import com.peihua.service.UserService;

 

@Controller

@RequestMapping("/demo")

public class DemoController {

@Autowired

private UserService userservice;

@RequestMapping("/login")

public String login(Model model,Employee user){

Employee userz=userservice.login(user.getUsername(), user.getPassword());

if(userz!=null){

System.out.println("登陆成功！");

return "/main";

}else {

System.out.println("登陆失败！");

return "/fail";

}

}

 

}

 

5.5、po层：

package com.peihua.po;

 

import java.io.Serializable;

 

public class Employee 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;

}

 

}

 

 

6、修改web.xml配置文件：

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"

id="WebApp_ID" version="2.5">

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>

classpath:applicationContext.xml,

classpath:spring-mybatis.xml,

</param-value>

</context-param>

<listener>

<description>spring监听器</description>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

<servlet>

<description>spring mvc servlet</description>

<servlet-name>springmvc</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<init-param>

<param-name>contextConfigLocation</param-name>

<param-value>

classpath:spring-mvc.xml

</param-value>

</init-param>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-mapping>

<servlet-name>springmvc</servlet-name>

<url-pattern>*.do</url-pattern>

</servlet-mapping>

</web-app>

 

7、新建jsp页面：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%

String path = request.getContextPath();

String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<base href="<%=basePath%>">

<title>My JSP 'MyJsp.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">

<meta http-equiv="cache-control" content="no-cache">

<meta http-equiv="expires" content="0">

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

<meta http-equiv="description" content="This is my page">

<!--

<link rel="stylesheet" type="text/css" href="styles.css">

-->

 

</head>

<body>

<form action="<%=path%>/demo/login.do">

<table>

<tr>

<td>用户名称：</td>

<td><input type="text" name="username" /></td>

</tr>

<tr>

<td>用户密码：</td>

<td><input type="password" name="password" /></td>

</tr>

<tr>

<td><input type="submit" name="登陆" /></td>

</tr>

</table>

</form>

</body>

</html>

 

8、完成！