<?xml version="1.0" encoding="UTF-8"?>
<!--
 Licensed to the Apache Software Foundation (ASF) under one
 or more contributor license agreements. See the NOTICE file
 distributed with this work for additional information
 regarding copyright ownership. The ASF licenses this file
 to you under the Apache License, Version 2.0 (the
 "License"); you may not use this file except in compliance
 with the License. You may obtain a copy of the License at

 http://www.apache.org/licenses/LICENSE-2.0

 Unless required by applicable law or agreed to in writing,
 software distributed under the License is distributed on an
 "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 KIND, either express or implied. See the License for the
 specific language governing permissions and limitations
 under the License.
-->
<!-- $Id: pom.xml 642118 2008-03-28 08:04:16Z reinhard $ -->
<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/maven-v4_0_0.xsd">

 <modelVersion>4.0.0</modelVersion>
 <packaging>war</packaging>

 <name>yakei</name>
 <groupId>com.yakei</groupId>
 <artifactId>yakei</artifactId>
 <version>1.0-SNAPSHOT</version>

 <dependencies>
 <dependency>
  <!--3.0的junit是使用编程的方式来进行测试，而junit4是使用注解的方式来运行junit-->
  <groupId>junit</groupId>
  <artifactId>junit</artifactId>
  <version>4.11</version>
  <scope>test</scope>
 </dependency>

 <!--补全项目依赖-->
 <!--1.日志 java日志有:slf4j,log4j,logback,common-logging
  slf4j:是规范/接口
  日志实现:log4j,logback,common-logging
  使用:slf4j+logback
 -->
 <dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-api</artifactId>
  <version>1.7.12</version>
 </dependency>
 <dependency>
  <groupId>ch.qos.logback</groupId>
  <artifactId>logback-core</artifactId>
  <version>1.1.1</version>
 </dependency>
 <!--实现slf4j接口并整合-->
 <dependency>
  <groupId>ch.qos.logback</groupId>
  <artifactId>logback-classic</artifactId>
  <version>1.1.1</version>
 </dependency>


 <!--1.数据库相关依赖-->
 <dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.36</version>
  <scope>runtime</scope>
 </dependency>
 <dependency>
  <groupId>c3p0</groupId>
  <artifactId>c3p0</artifactId>
  <version>0.9.1.1</version>
 </dependency>

 <!--2.dao框架:MyBatis依赖-->
 <dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.3.0</version>
 </dependency>
 <!--mybatis自身实现的spring整合依赖-->
 <dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.2.3</version>
 </dependency>

 <!--3.Servlet web相关依赖-->
 <dependency>
  <groupId>taglibs</groupId>
  <artifactId>standard</artifactId>
  <version>1.1.2</version>
 </dependency>
 <dependency>
  <groupId>jstl</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
 </dependency>
 <dependency>
  <groupId>com.fasterxml.jackson.core</groupId>
  <artifactId>jackson-databind</artifactId>
  <version>2.5.4</version>
 </dependency>
 <dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>javax.servlet-api</artifactId>
  <version>3.1.0</version>
 </dependency>

 <!--4:spring依赖-->
 <!--1)spring核心依赖-->
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-core</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-beans</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 <!--2)spring dao层依赖-->
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-tx</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 <!--3)springweb相关依赖-->
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-web</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-webmvc</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 <!--4)spring test相关依赖-->
 <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-test</artifactId>
  <version>4.1.7.RELEASE</version>
 </dependency>
 </dependencies>
</project>

<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dajiu.dao.UserDao">
<!--目的:为dao接口方法提供sql语句配置
即针对dao接口中的方法编写我们的sql语句-->
<select id="getAll" resultType="com.dajiu.bean.User">
 select * from user
</select>
<select id="getLogin" resultType="com.dajiu.bean.User">
 select * from user where name = #{name} and password = #{password}
</select>
</mapper>

<?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"
  xsi:schemaLocation="http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans.xsd
  http://www.springframework.org/schema/context [url=http://www.springframework.org/schema/context/spring-context.xsd">]http://www.springframework.org/schema/context/spring-context.xsd">
[/url] <!--配置整合mybatis过程
 1.配置数据库相关参数-->
 <context:property-placeholder location="classpath:jdbc.properties"/>

 <!--2.数据库连接池-->
 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  <!--配置连接池属性-->
  <property name="driverClass" value="${driver}" />
  <!-- 基本属性 url、user、password -->
  <property name="jdbcUrl" value="${url}" />
  <property name="user" value="${username}" />
  <property name="password" value="${password}" />
  <!--c3p0私有属性-->
  <property name="maxPoolSize" value="30"/>
  <property name="minPoolSize" value="10"/>
  <!--关闭连接后不自动commit-->
  <property name="autoCommitOnClose" value="false"/>
  <!--获取连接超时时间-->
  <property name="checkoutTimeout" value="10000"/>
  <!--当获取连接失败重试次数-->
  <property name="acquireRetryAttempts" value="2"/>
 </bean>
 <!--约定大于配置-->
 
 <!--３.配置SqlSessionFactory对象-->
 <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  <!--往下才是mybatis和spring真正整合的配置-->
  <!--注入数据库连接池-->
  <property name="dataSource" ref="dataSource"/>
  <!--配置mybatis全局配置文件:mybatis-config.xml-->
  <property name="configLocation" value="classpath:mybatis-config.xml"/>
  <!--扫描entity包,使用别名,多个用;隔开-->
  <property name="typeAliasesPackage" value="com.dajiu.bean"/>
  <!--扫描sql配置文件:mapper需要的xml文件-->
  <property name="mapperLocations" value="classpath:mapper/*.xml"/>
 </bean>

 <!--４:配置扫描Dao接口包,动态实现DAO接口,注入到spring容器-->
 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  <!--注入SqlSessionFactory-->
  <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
  <!-- 给出需要扫描的Dao接口-->
  <property name="basePackage" value="com.dajiu.dao"/>
 </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:tx="http://www.springframework.org/schema/tx"
  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/tx [url=http://www.springframework.org/schema/tx/spring-tx.xsd">]http://www.springframework.org/schema/tx/spring-tx.xsd">
[/url] <!--扫描service包下所有使用注解的类型-->
 <context:component-scan base-package="com.dajiu.service"/>

 <!--配置事务管理器-->
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <!--注入数据库连接池-->
  <property name="dataSource" ref="dataSource"/>
 </bean>
 <bean id="date" class="java.util.Date"></bean>
 <!--配置基于注解的声明式事务
 默认使用注解来管理事务行为-->
 <tx:annotation-driven transaction-manager="transactionManager"/>
</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:mvc="http://www.springframework.org/schema/mvc"
  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
  [url=http://www.springframework.org/schema/mvc/spring-mvc.xsd">]http://www.springframework.org/schema/mvc/spring-mvc.xsd">
[/url] <!--配置spring mvc-->
 <!--1,开启springmvc注解模式
 a.自动注册DefaultAnnotationHandlerMapping,AnnotationMethodHandlerAdapter
 b.默认提供一系列的功能:数据绑定，数字和日期的format@NumberFormat,@DateTimeFormat
 c:xml,json的默认读写支持-->
 <mvc:annotation-driven/>

 <!--2.静态资源默认servlet配置-->
 <!--
  1).加入对静态资源处理：js,gif,png
  2).允许使用 "/" 做整体映射
 -->
 <mvc:default-servlet-handler/>

 <!--3：配置JSP 显示ViewResolver-->
 <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
  <property name="prefix" value="/WEB-INF/view/"/>
  <property name="suffix" value=".jsp"/>
 </bean>

 <!--4:扫描web相关的bean-->
 <context:component-scan base-package="com.dajiu.controller"/>
 <mvc:resources mapping="/**/*.html" location="/"/>
 <mvc:resources mapping="/**/*.js" location="/"/>
 <mvc:resources mapping="/**/*.css" location="/"/>
 <mvc:resources mapping="/**/*.png" location="/"/>
 <mvc:resources mapping="/**/*.gif" location="/"/>
</beans>

package com.dajiu.bean;
/**
 * Created by zhangxing on 2017/4/7.
 */
public class User {
 private int id;
 private String name;
 private String password;
 public int getId() {
  return id;
 }

 public void setId(int id) {
  this.id = id;
 }

 public String getName() {
  return name;
 }

 public void setName(String name) {
  this.name = name;
 }

 public String getPassword() {
  return password;
 }

 public void setPassword(String password) {
  this.password = password;
 }
}

package com.dajiu.dao;
import com.dajiu.bean.User;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import java.util.List;
/**
 * Created by zhangxing on 2017/4/7.
 */
@Repository
public interface UserDao {
 List<User> getAll();
 User getLogin(@Param("name") String name, @Param("password") String password);
}

package com.dajiu.service;
import com.dajiu.bean.User;
import java.util.List;
/**
 * Created by zhangxing on 2017/4/7.
 */
public interface UserService {
 List<User> getAll();
 User getLogin(String name,String password);
}

package com.dajiu.service.impl;
import com.dajiu.bean.User;
import com.dajiu.dao.UserDao;
import com.dajiu.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
 * Created by zhangxing on 2017/4/7.
 */
@Service("UserService")
public class UserServiceImpl implements UserService {
 @Autowired
 UserDao userDao;
 public List<User> getAll() {
  return userDao.getAll();
 }

 public User getLogin(String name, String password) {
  return userDao.getLogin(name,password);
 }
}

package com.dajiu.controller;
import com.dajiu.bean.User;
import com.dajiu.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.bind.annotation.ResponseBody;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
 * Created by zhangxing on 2017/4/7.
 */
@Controller
@RequestMapping("/blog")
public class UserController {
 @Autowired
 UserService userService;
 @RequestMapping("/getUser")
 @ResponseBody
 public Map<String,Object> getUser(){
  Map map = new HashMap();
  List<User> list = userService.getAll();
  map.put("user",list);
  map.put("status",1);
  map.put("success",true);
  return map;
 }

 @RequestMapping("getLogin")
 @ResponseBody
 public Map<String,Object> getLogin(String name,String password){
  Map map = new HashMap();
  User user = userService.getLogin(name,password);
  map.put("user",user);
  map.put("isLogin",true);
  map.put("status",1);
  return map;
 }
}