userservices.java

一个用JSP写的网络购物系统

package cn.edu.dlnu.shop.services;

import java.util.List;
import java.util.Map;

import cn.edu.dlnu.frame.utils.DataBaseUtil;
import cn.edu.dlnu.frame.utils.MapUtil;

public class UserServices {
	DataBaseUtil dbu=new DataBaseUtil();
	public boolean validate(String userId) {
		String sql="select * from ACCOUNTS where USERID=?";
		List result=dbu.queryForList(sql, new Object[]{userId});
		if(result.size()>0)
			return true;
		else
			return false;
	}

	public boolean regUser(Map userInfo) {
		String sql="insert into ACCOUNTS values(ACCOUNTSEQ.nextval,?,?,?,?,?,?,?,0,1)";
		Object[] params=MapUtil.getObjectArrayFromMap(userInfo, "user_id,user_name,user_pass,user_adds,user_postcode,user_mail,user_tel");
		return dbu.executeUpdate(sql, params);
	}

	public Map findUser(String userId, String userPwd) throws Exception {
		// TODO Auto-generated method stub
		String sql="select * from ACCOUNTS where userid=? and pwd=? and state=1";
		return dbu.queryForMap(sql, new Object[]{userId,userPwd});
	}

}