logindao.java

新东方软件开发项目

package com.mobile.dao;



import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class LoginDAO {

	public String getCount(String sql){
		Connection con = null;
		Statement st = null;
		ResultSet rs = null;
	
		String Is_Admin=null;
		try{
			con = ConnectionMgr.getConnection();
			st = con.createStatement();
			System.out.println("Is_Admin");
			rs = st.executeQuery(sql);
			while(rs.next()){
		      Is_Admin=rs.getString(1);
			}
		 System.out.println(Is_Admin);
			
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			ConnectionMgr.closeResource(con, st, rs);
			
		}
	
		return Is_Admin;
	}
}