package com.yourcompany.struts;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.LinkedList;
public class UserManger {
	private Connection con=null;
	private Statement st = null;
	private ResultSet rs=null;
	private boolean bool;
	String userName;
	
	public UserManger()
	{
		try{
			Class.forName("org.gjt.mm.mysql.Driver");
			con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/" +
					"mydb","root","admin");
		}catch(Exception se){
			se.printStackTrace();
		}
	}
	public List list()  {
		Person temp;
		List<Person> list=new LinkedList();
		System.out.println("11");
		try{
			st=con.createStatement();
			rs=st.executeQuery("SELECT * FROM user");			
			
			while(rs.next())
			{
				temp=new Person();
				System.out.println(rs.getString(1));
				
				temp.setName(rs.getString(1));
				System.out.println(temp.getName());
				temp.setPassword(rs.getString(2));
				temp.setState(rs.getString(3));
				list.add(temp);				
			}
			st.close();
			rs.close();	
		}
		catch(SQLException sql){sql.printStackTrace();}
		return list;
	}
	public boolean checkUser(String userName,String password)
	{
		String user;
		String word;
		user=userName;
		word=password;
		try{
			st=con.createStatement();
			rs=st.executeQuery("SELECT * FROM user WHERE username=\'"+user+"\' and " +
					"userpwd=\'"+word+"\'");
			if(rs.next())
			{
				bool=true;
			}else
				bool=false;
			st.close();
			rs.close();			
		}catch(SQLException sql){sql.printStackTrace();}
		return bool;
	}
	public void addUser(String userName,String password)
	{
		String user;
		String word;
		user=userName;
		word=password;
		try{
			st=con.createStatement();
			st.execute("INSERT INTO user(username,userpwd,roke)VALUES('"+user+"','"+word+"','1')");
			st.close();
		}catch(SQLException sql){sql.printStackTrace();}
	}
	public void delUser(String userName){
		String user;
		user=userName;
		try{
			st=con.createStatement();
			st.execute("DELETE from user where username='"+user+"'");
			st.close();
		}catch(SQLException sql)
		{sql.printStackTrace();}
	}
	public void updateUser(String userName,String password,String roke){
		String user,npwd,nroke;
		user=userName;
		npwd=password;
		nroke=roke;
		try{
			st=con.createStatement();
			st.execute("update user set userpwd = '"+npwd+"',roke='"+nroke+"' where username = '"+user+"'");
		}catch(SQLException sql)
		{sql.printStackTrace();}
	}
}