entrydco.java

海鲜超市管理 登录 修改 增加 等功能jsp+servlet

/*
 * 创建日期 2006-12-18
 * TODO 
 */
package module.entry.dco;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import conn.ConnSky;



public class EntryDco {
	public String SelectFlag(String name,String pswd){
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String flag = null;
		String sql = "select flag from shop_user where username=? and password=?";
		
		try{
			conn = ConnSky.getConn();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1,name);
			pstmt.setString(2,pswd);
			rs=pstmt.executeQuery();
			if(rs.next()){
				flag = rs.getString("flag");
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try{
				rs.close();
				pstmt.close();
				conn.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		return flag;
	}

}