src/com/accp/myShopping/wjj/dao/Userdao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.accp.myShopping.wjj.dao;
import java.sql.Date;
import java.util.ArrayList;
import java.util.List;

import com.accp.myShopping.util.DataBaseUtil;
import com.accp.myShopping.wjj.entity.UserBean;
public class Userdao {
	
	java.sql.ResultSet rSet=null;
	DataBaseUtil db=new DataBaseUtil();
	List list=new ArrayList();
	public static void main(String[] args) {
		UserBean userBean=new UserBean();
		userBean.setU_isLock(0);
		userBean.setU_id(1);
		Userdao dao=new Userdao();
		boolean count=dao.updateUser(userBean);
		System.out.println(count);
	}
	
	 /*
	  * 查询通用
	  * **/
     public List<UserBean> select(String sql,Object... parmars){
   	  
   	  try {
   		  rSet=db.getResultSet(sql,parmars);
   		  while (rSet.next()) {
				 int U_id=rSet.getInt(1);
				 String U_uName=rSet.getString(2);
				 String U_uPass=rSet.getString(3);
				 String U_Name=rSet.getString(4);
				 String U_sex=rSet.getString(5);
				 int U_Type=rSet.getInt(6);
				 int U_score=rSet.getInt(7);
				 Date U_birthday=rSet.getDate(8);
				 String U_phone=rSet.getString(9);
				 String U_email=rSet.getString(10);
				 int U_isLock=rSet.getInt(11);
				 UserBean user=new UserBean(U_id, U_uName, U_uPass, U_Name, U_sex, U_Type, U_score, U_birthday, U_phone, U_email, U_isLock);
				 list.add(user);
			}
   		  
		} catch (Exception e) {
			   System.out.println("SQL语句错误");
		}finally{
			
			db.release(rSet);
		}
		return list;
   	  
     }
     
     /*
      * 查询所有
      * **/
     public List<UserBean> selectAll(){
   	  
   	  String sql ="select * from users";