详解SpringMVC和MyBatis框架开发环境搭建和简单实用

   CoolWeb index.htmlindex.htmindex.jspdefault.htmldefault.htmdefault.jsp CoolWeborg.springframework.web.servlet.DispatcherServlet contextConfigLocationclasspath:CoolWeb-servlet.xml1 CoolWeb/

 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; /** * 用户手机号码 */ 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; /** * 生活状态(发表的说说) */ private @Setter@Getter String live_status; } 

    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;//上一次运行的时间 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(); //将原任务从队列中移除 } task = new EatTimerTask(); timeInterval = System.currentTimeMillis(); //间隔�?1小时 long period = 1000 * 60 * 60; //测试时间每分钟一�? //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); /** * 注册 * @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)){ //用户已存在，无须再次注册 ResponseUtils.renderJsonDataFail(response, ServiceStatus.RUNTIME_EXCEPTION, "该号码已被注册"); return; } } /** * 根据手机号码查询用户是否存在 * @param phone * @return */ public boolean hasUserPhone(String phone){ /**sql 语句 完整的包名类名和方法id，*/ String sql = "com.vincent.lwx.mapping.UserMapping.selectUser"; SqlSession session = MyBatisUtils.getSqlSession(); /**返回一个User对象*/ User user = session.selectOne(sql, phone); if(user!=null){ //用户已存在 return true; }else{ //用户不存在 return false; } } } 

 CREATE DETABASE cool; //创建数据库并指定字符编码集 CREATE DATABASE cool DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; //创建表 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;设置已经存在的表的默认值 //限制手机号码唯一性 alter table user add unique(phone); 字段值唯一性约束 insert into user(phone,password) values( '18696855784', '555555');