ssignin.java

windows系统下用java开发的网络入侵检测程序

import java.sql.*;
/**
 * Transact user's signin request.<p>
 * 2005.8.10
 * @version 0.1.2
 * @author Daxin Tian
 *
 */
public class Ssignin extends Saccept{
	
	/**
	 * 
	 * @param name Who want to signin.
	 * @param password User's password.
	 * @param ips User's IP adress.
	 */
	Ssignin(String name,String password,String ips)
	{
		super(name,password,ips);
	}
	/**
	 * 
	 * @return If user's username and password are right, return true else return false.
	 */
	public boolean signin()
	{
		try
		{
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch(ClassNotFoundException e)
		{
			info="db driver wrong";
			return false;
		}
		try
		{
			//con=DriverManager.getConnection("jdbc:odbc:jidxdb","","");
			con=DriverManager.getConnection("jdbc:mysql://localhost/jidx");
			sql=con.createStatement();
			
			rs=sql.executeQuery("select * from register where username='"+s_name+"' and password='"+s_password+"'");
			//System.out.println("retrieve begin");
			
			if(rs.next())
			{
				
								
				info="Congratulations: "+rs.getString(1)+" signin ok";
				sql.execute("update register set state=1, ips='"+s_ips+"' where username='"+s_name+"'");
				con.close();
				return true;
			}
			else
			{
				info="not find the user";
				con.close();
				return false;
			}
		}
		catch(SQLException e)
		{
			info="sql wrong";
			return false;
		}
		
	}
	

}