userdaoibatis.java

spring+webwork+ibatis的一个软件练手项目,实现最基础的留言本功能.

package com.bbs.dao;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.bbs.model.User;

public class UserDaoIbatis  extends SqlMapClientDaoSupport implements UserDao  {

	public Integer checkLogin(User user) {
		return (Integer)getSqlMapClientTemplate().queryForObject("getUserCount",user);
//		if(obj.intValue()==0)//select count(id) from user where  
//			return false;
//		else 
//			return true;
	}

	public boolean insertUser(User user) {
		//System.out.println("user:"+user.getPassword2());
		if(!user.getPassword().equals(user.getPassword2())) return false;
		getSqlMapClientTemplate().insert("insertUser",user);
		//TODO 未成功？上面如何在页面端检测
		return true;
	}

	public boolean modifyPassword(User user) {
		getSqlMapClientTemplate().update("modifyPassword",user);
		// TODO 未成功？
		return true;
	}

	public boolean getUserByName(User user) {
		Integer obj = (Integer)getSqlMapClientTemplate().queryForObject("getUserbyName",user);
		if(obj.intValue()==0)//select count(id) from user where  
			return false;
		else 
			return true;
	}

}