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

 CoolWeb
 
  index.html
  index.htm
  index.jsp
  default.html
  default.htm
  default.jsp
 


 
   CoolWeb
   org.springframework.web.servlet.DispatcherServlet
   
      contextConfigLocation
      
      classpath:CoolWeb-servlet.xml 
   
   1
 

  
 
    CoolWeb
    /
 

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



  
  
  

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



  
  

  
  

    
  
    
    
      
   

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


  
    
      
      
      
        
        
        
        
        
      
    
  
  
    
  

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

  
    
      
      
    
    
      
      
    
  
  
    
      
      
    
  

   
   
     
   

   
     
   

   
     
   

   
     
   

   
     
   

   
     
     
 
 
   

package com.vincent.lwx.bean;

import java.io.Serializable;

import lombok.Data;
import lombok.Getter;
import lombok.Setter;

/**  
* @Title: User.java 
* @Package com.vincent.lwx.bean 
* @Description: TODO(用一句話描述該文件做什么) 
* @author Vincent  
* @date 2017年3月3日 下午6:36:58 
* @version V1.0  
*/
public class User implements Serializable{

  /**
   * 序列化id
   */
  private static final long serialVersionUID = -6375697395831845246L;

  /**
   * 用戶id
   */
  private @Getter String user_id;

  /**
   * 用戶手機(jī)號(hào)碼
   */
  private @Setter@Getter String phone;

  /**
   * 密碼
   */
  private @Setter@Getter String password;

  /**
   * 用戶名
   */
  private @Setter@Getter String nickname;

  /**
   * 用戶頭像地址
   */
  private @Setter@Getter String head;

  /**
   * 性別
   */
  private @Setter@Getter String sex;

  /**
   * 生日
   */
  private @Setter@Getter String birthday;

  /**
   * 生活狀態(tài)(發(fā)表的說(shuō)說(shuō))
   */
  private @Setter@Getter String live_status;


}

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




  
  
    select * from user where phone = #{phone}
  

package com.vincent.lwx.db;

import java.io.IOException;
import java.io.Reader;
import java.util.Timer;
import java.util.TimerTask;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.vincent.lwx.util.EatTimerTask;


/**
 * @Title: MyBatisUtils.java
 * @Package com.vincent.julie.config
 * @Description: TODO(��һ�仰�������ļ���ʲô)
 * @author Vincent
 * @date 2017��2��18�� ����12:05:35
 * @version V1.0
 */

public class MyBatisUtils {
  private static SqlSessionFactory sqlSessionFactory;
  private static SqlSession sqlSession;
  private static long timeInterval;//上一次運(yùn)行的時(shí)間
  private static TimerTask task =null;

  static {
    String resource = "mybatis.xml";
    Reader reader = null;
    try {
      reader = Resources.getResourceAsReader(resource);
    } catch (IOException e) {
      System.out.println(e.getMessage());

    }
    sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
  }
  /**
   * 
   * @return
   */
  public static SqlSessionFactory getSqlSessionFactory() {
    return sqlSessionFactory;
  }

  /**
   * ��ȡsqlSession����
   * @return
   */
  public static SqlSession getSqlSession(){
    if (task != null){
       task.cancel(); //將原任務(wù)從隊(duì)列中移除
     }
    task = new EatTimerTask();
    timeInterval = System.currentTimeMillis();
     //間隔�?1小時(shí)
     long period = 1000 * 60 * 60;  
     //測(cè)試時(shí)間每分鐘一�?
     //period = 1000 * 60;    
     Timer timer = new Timer(); 
     timer.schedule(task, timeInterval, period);

    if(sqlSessionFactory == null){
      sqlSessionFactory = MyBatisUtils.getSqlSessionFactory();
    }
    sqlSession = sqlSessionFactory.openSession();
    return sqlSession;
  }


}

package com.vincent.lwx.controller;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.ibatis.session.SqlSession;
import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import com.vincent.lwx.bean.ServiceStatus;
import com.vincent.lwx.bean.User;
import com.vincent.lwx.db.MyBatisUtils;
import com.vincent.lwx.util.ResponseUtils;

/**  
* @Title: UserControl.java 
* @Package com.vincent.lwx.mapping 
* @Description: TODO(��һ�仰�������ļ���ʲô) 
* @author Vincent  
* @date 2017��3��3�� ����6:28:37 
* @version V1.0  
*/
@Controller
public class UserController {

  private static final Logger logger = LogManager.getLogger(UserController.class);

  /**
   * 注冊(cè)
   * @param phone
   * @param password
   * @param request
   * @param response
   */
  @RequestMapping(value = "register", method = RequestMethod.POST)
  public void registerUser(@RequestParam("phone")String phone,@RequestParam("password")String password,HttpServletRequest request,HttpServletResponse response){
    if(hasUserPhone(phone)){
      //用戶已存在，無(wú)須再次注冊(cè)
      ResponseUtils.renderJsonDataFail(response, ServiceStatus.RUNTIME_EXCEPTION, "該號(hào)碼已被注冊(cè)");
      return;
    }
  }


  /**
   * 根據(jù)手機(jī)號(hào)碼查詢用戶是否存在
   * @param phone
   * @return
   */
  public boolean hasUserPhone(String phone){
    /**sql 語(yǔ)句 完整的包名類名和方法id，*/
    String sql = "com.vincent.lwx.mapping.UserMapping.selectUser";
    SqlSession session = MyBatisUtils.getSqlSession();
    /**返回一個(gè)User對(duì)象*/
    User user = session.selectOne(sql, phone);
    if(user!=null){
      //用戶已存在
      return true;
    }else{
      //用戶不存在
      return false;
    }
  }
}

CREATE DETABASE cool;
//創(chuàng)建數(shù)據(jù)庫(kù)并指定字符編碼集
CREATE DATABASE cool DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

//創(chuàng)建表
create table user(
user_id int(10) not null primary key auto_increment,
phone varchar(11) not null,
password varchar(16) not null,
nickname varchar(36),
head varchar(50),
sex varchar(3),
birthday varchar(10) default '1992-01-01',
live_status varchar(255)
)engine = InnoDB default charset=utf8;

//限制最小id=10000
 alter table user AUTO_INCREMENT=10000;設(shè)置已經(jīng)存在的表的默認(rèn)值
//限制手機(jī)號(hào)碼唯一性
alter table user add unique(phone); 字段值唯一性約束

insert into user(phone,password) values(
'18696855784',
'555555');