package jsp.java.jsp.model.util;

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

import jsp.java.jsp.model.User;



public class Mysql {
	
	private static final String url = "jdbc:mysql://localhost:3306/lol";
	private static final String user = "root";
	private static final String password = "root";
	
	private static Connection creatConnection() throws ClassNotFoundException,SQLException{
		Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection(url,user,password);
		return conn;
	}
	
	public static User getUserRole(String username) throws Exception{
		Connection conn = creatConnection();
		String sql = "select password,role from users where username=?";
		PreparedStatement ps = conn.prepareStatement(sql);
		ps.setString(1, username);
		ResultSet rs = ps.executeQuery();
		User u = new User();
		while(rs.next()){
			u.setRole(rs.getString("role"));
			u.setPassword(rs.getString("password"));
		}
		rs.close();
		ps.close();
		conn.close();
		return u;
	}

}