80d83acdf1d2001d149ca1d0101b11a6

JSP+SERVLE源码 JSP+SERVLE源码

package com.dao;

import com.Conn;
import com.vo.Vo;

import java.sql.*;
import java.util.ArrayList;

public class Dao {
	Conn conn = new Conn();
	Connection con = conn.getCon();
	ResultSet rs = null;
	ArrayList List=new ArrayList();
	public int select(Vo vo){
		try{
			Statement stmt=con.createStatement();			
			String sql = "select * from alluser where num='"+vo.getUnum()+"' and paw='"+vo.getUpaw()+"' and isdelete=1";
			rs = stmt.executeQuery(sql);
			try{
				if(rs.next()){
					int i=3;
					i=rs.getInt("sign");
					return i;
				}
			}catch(Exception e){
				e.printStackTrace();
			}
			
			rs.close();
			stmt.close();
			con.close();
		}catch(Exception e){
			e.printStackTrace();
		}
		
		
		return i;
	}	
	public void add(String sql){
		
	}
}