a06c083decd2001d149ca1d0101b11a6

来自「JSP+SERVLE源码 JSP+SERVLE源码」· 代码 · 共 35 行

package com.bo;

import com.dao.*;
import com.vo.Vo;

import java.sql.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class BoUser {
	Dao dao = new Dao();
	ResultSet rs = null;
	public int check(HttpServletRequest request, HttpServletResponse response){
		
	
	 String sql = "select * from alluser where num='"+vo.getUnum()+"' and paw='"+vo.getUpaw()+"' and isdelete=1";
		rs = dao.select(sql);
		try{
			if(rs.next()){
				if(rs.getInt("sign")==1){
					return 1;
				}
				else if(rs.getInt("sign")==2){
					return 2;
				}
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		
		return 0;
	}	

}