package dao;

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

import model.User;

public class GetUser {

	public boolean flag = false;

	public User getUser(String userid) {
		
		User user = new User();
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		String url = "jdbc:oracle:thin:@localhost:1521:orcl";
		String u = "scott";
		String p = "tiger";
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;

		try {
			conn = DriverManager.getConnection(url, u, p);
			st = conn.createStatement();
			rs = st.executeQuery("Select * from users where userid=" + "'"
					+ userid + "'");
			if (rs.next()) {
				flag = true;
				user.setUserid(rs.getString("userid"));
				user.setUserpw(rs.getString("userpw"));
				user.setUserlimits(rs.getInt("userlimits"));
			}
		} 
		catch (SQLException e) {
			e.printStackTrace();
		} 
		finally {
			if(conn!=null) {
				try {
					rs.close();
				} catch (SQLException e1) {
					
				}
				try {
					
					st.close();
					conn.close();
				} 
				catch (SQLException e) {
					e.printStackTrace();
				}
			}

		}
		
		return user;
	}
}