a062de72ead2001d149ca1d0101b11a6

JSP+SERVLE源码 JSP+SERVLE源码

package com.bo;

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

import java.sql.*;
public class User {
	Dao dao = new Dao();
	ResultSet rs = null;
	public int check(Vo vo){
	
	 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;
	}	

}