code_server/src/com/web/user/UserDao.java

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

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

package com.web.user;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.origin.base.DAOBase;




public class UserDao {


	public  boolean login( String tableName , String name , String password){

    	DAOBase dao = new DAOBase();
		try { 
			String sql = "select 1 from " + tableName  + " where name='" + name + "' and password='" + password +"'"; 
	    	dao.querySql(sql);
    		ResultSet rs = dao.getRes(); 
			while(rs.next()) {
				return true;
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(dao != null)
				dao.release();			
		}
		return false;
	}
	

	public User getUserByName(String tableName , String name , String password ){

		DAOBase dao = new DAOBase();
		User object = null ;
		
		try { 
			String sql = " select id , screen_name , type  from "  + tableName + " where name='" + name + "' and password='" + password + "'"; 
	    	dao.querySql(sql);
    		ResultSet rs = dao.getRes(); 
			while(rs.next()) {
				object = new User() ;
				object.setId( String.valueOf( rs.getInt(1))  );
				object.setScreen_name(  rs.getString(2)  );			
				object.type =    rs.getString(3)  ;	
				break;
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(dao != null)
				dao.release();			
		}