日期:2014-05-16  浏览次数:20769 次

spring mvc + mybatis + mysql 整合的一个简单的登录例子
今天用spring跟mybatis整合写了一个简单的登录例子,第一次整合,给自己做个笔记,可能注释写的有点少,做的不足的地方谢谢指出,也分享给需要的朋友,下面给出登录失败和成功的效果图:

 

     这个登录例子用的工具是myeclipse8.6+mysql5.1,使用到的技术有spring3.0+mybatis3.2.3+mybatis-spring-1.1.1(这个是spring跟mybatis整合的包),项目的整体结构如图:

 

    现在我们要做的就是在myeclipse工具里新建一个web项目,并且添加spring 支持,不懂的朋友可以查看http://blog.csdn.net/ooliuyunoo/article/details/19908661

    项目新建完之后我们就把项目分次序把项目新建起来:

   1: 新建vo类,代码如下:

     

package com.li.vo;

public class UserVO {
	private int id;
	private String name;
	private String pwd;
	public UserVO(){}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	public String getPwd() {
		return pwd;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getName() {
		return name;
	}
	public void setId(int id) {
		this.id = id;
	}
	public int getId() {
		return id;
	}
}


 

    2:  新建UserDaoIMP接口:

package com.li.IMP;

import com.li.vo.UserVO;

public interface UserDaoIMP {
	public UserVO selectUser(UserVO uservo);
	public int insertUser(UserVO uservo);
	public int updaqteUser(UserVO uservo);
	public int deleteUserById(int user_id);
}


 

   3: 新建UserDaoIMP.xml配置文件:

<?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.li.IMP.UserDaoIMP">
		<select id="selectUser" parameterType="com.li.vo.UserVO" resultType="com.li.vo.UserVO">
			select * from user where name=#{name} and pwd=#{pwd}
		</select>
		<insert id="insertUser" parameterType="com.li.vo.UserVO" flushCache="true">
			insert into user(name,pwd) values(#{name},#{pwd})
		</insert>
		<update id="updateUser" parameterType="com.li.vo.UserVO">
			update user set name=#{name} where id=#{id}
		</update>
		<delete id="deleteUser" parameterType="int">
			delete from user where id=#{id}
		</delete>
	</mapper>


 

    4:新建UserServiceIMP服务接口:

package com.li.service;

import com.li.vo.UserVO;

public interface UserServiceIMP {
	public UserVO selectUser(UserVO uservo);
	public int insertUser(UserVO uservo);
	public int updaqteUser(UserVO uservo);
	public int deleteUserById(int user_id);
}


 

     5:新建UserService继承服务接口:

package com.li.service;

import com.li.IMP.UserDaoIMP;
import com.li.vo.UserVO;

public class UserService implements UserServiceIMP {
	private UserDaoIMP userdao;
	public int deleteUserById(int userId) {