spring mvc + mybatis + mysql 调整的一个简单的登录例子

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;
	}
}

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);
}

			select * from user where name=#{name} and pwd=#{pwd}
		
			insert into user(name,pwd) values(#{name},#{pwd})
		
			update user set name=#{name} where id=#{id}
		
			delete from user where id=#{id}
		

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);
}

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) {
		// TODO Auto-generated method stub
		return this.deleteUserById(userId);
	}

	public int insertUser(UserVO uservo) {
		// TODO Auto-generated method stub
		return this.userdao.insertUser(uservo);
	}

	public UserVO selectUser(UserVO uservo) {
		// TODO Auto-generated method stub
		return this.userdao.selectUser(uservo);
	}

	public int updaqteUser(UserVO uservo) {
		// TODO Auto-generated method stub
		return this.userdao.updaqteUser(uservo);
	}

	public void setUserdaoIMP(UserDaoIMP userdaoIMP) {
		this.userdao = userdaoIMP;
	}

	public UserDaoIMP getUserdaoIMP() {
		return userdao;
	}

}

package com.li.controller;

import java.util.HashMap;
import java.util.Map;

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

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

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

public class LoginController implements Controller {
	private UserService userService;
	public ModelAndView handleRequest(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		// TODO Auto-generated method stub
		String name=request.getParameter("userName");
		String password=request.getParameter("password");
		//System.out.println("name-----"+name+"----password-----"+password);
		UserVO uservo=new UserVO();
		uservo.setName(name);
		uservo.setPwd(password);
		Map model=new HashMap();
		if(userService.selectUser(uservo)!=null){
			uservo=userService.selectUser(uservo);
			System.out.println("能查到信息");
			model.put("uservo", uservo);
			return new ModelAndView("WEB-INF/Main.jsp",model);
		}else{
			System.out.println("查不到信息");
			model.put("error", "用户名或密码错误");
			return new ModelAndView("WEB-INF/Login.jsp",model);
		}
		
	}
	public void setUserService(UserService userService) {
		this.userService = userService;
	}
	public UserService getUserService() {
		return userService;
	}


}

LoginController

  
    
    进入主页面

    你的基本信息如下：

    id:${uservo.id}

    用户名:${uservo.name}

    密码:${uservo.pwd}