package com.yourcompany.struts.action;
import java.sql.*;

import com.yourcompany.struts.form.*;
public class getInfo {
	
	public  int checkLogin (LogonForm logonForm){
		Connection con=null;
	
		int check=0;
		try{
			
			Statement state ;
			ResultSet rst;
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:db");
			state=con.createStatement();
			String name=logonForm.getName();
			String pwd=logonForm.getPassword();
			String sql="select role from info where name='"+name+"'and password='"+pwd+"'";
			rst=state.executeQuery(sql);
			String rolename="0";
			if(rst.next()){
				rolename=rst.getString(1);
			}
			if(rolename.equals("1")) check=1;
			else
				if(rolename.equals("2"))check=2;
				else check=3;
	
		}
		 catch (SQLException sqle){
			   System.err.println(sqle.getMessage());
		 }
	      catch (Exception e){
			   System.err.println(e.getMessage());
	     }
	      finally {
			   try{
				   if(con!=null){
					   con.close();
				   }
			   }
			   catch(SQLException sqle){
				   System.err.println(sqle.getMessage());
			   }
		   }
	      return check;
	}
	
}