code_server/src/com/web/user_tb/UserTbDao.java

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

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

package com.web.user_tb;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import org.json.JSONException;
import org.json.JSONObject;

import com.origin.base.DAOBase;




public class UserTbDao {
 
 

	public  void delete( String id ){
			DAOBase dao = new DAOBase(); 
			String sql = " delete from  user_tb where uid=" + id  ; 
			dao.executeSql(sql);   	  
	}
	
	
	public  List getAll( int pageIndex  , int pageSize  ){
		
		List<UserTb> list = new ArrayList() ;
    	DAOBase dao = new DAOBase();
		try { 
			String sql="select * from user_tb  limit " + pageIndex  + ", " + pageSize ;   
	    	dao.querySql(sql);
    		ResultSet rs = dao.getRes(); 
			while(rs.next()) {
				UserTb object = new UserTb();
				object.uid =  String.valueOf( rs.getInt(1)) ;
				
				object.user_userid =   rs.getString(2)  ;
				object.user_username =   rs.getString(3)  ;
				object.user_password =   rs.getString(4)  ;
				object.user_phone =   rs.getString(5)  ;
				object.user_address =   rs.getString(6)  ;
				
				list.add(object);  
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(dao != null)
				dao.release();			
		}
		return list;
	}
	
	public int getTotalCount( ){