sregister.java

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

/*
 * Created on 2005-8-27
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */

/**
 * @author Administrator
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
import java.sql.*;
/**
 * 
 * Transact register action. <p>
 * 2005.8.10 <p>
 * @version 0.1.2
 * @author Daxin Tian
 *
 */
public class Sregister extends Saccept{
	
	
	/**
	 * 
	 * @param name Who want to register.
	 * @param password User's password.
	 * @param ips User's IP address.
	 */
	Sregister(String name,String password,String ips)
	{
		super(name,password,ips);
	}
	/**
	 * 
	 * @return If the username has been registered return false,else return true.
	 */
	public boolean register()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
			info="db driver wrong";
			return false;
		}
		try
		{
			con=DriverManager.getConnection("jdbc:mysql://localhost/jidx");
			//con=DriverManager.getConnection("jdbc:odbc:jidxdb","","");
			sql=con.createStatement();
			rs=sql.executeQuery("select * from register where username='"+s_name+"'");
			
			if(rs.next())
			{
				info="the user name: "+rs.getString(1)+" has been register";
				con.close();
				return false;
			}
			else
			{
				sql.execute("insert into register (username,password,ips,state) values ('"+s_name+"','"+s_password+"','"+s_ips+"',1)");
				info="register ok";
				con.close();
				return true;
			}
			
			//sql.execute("commit");
			/*
			rs=sql.executeQuery("select * from register");
			while(rs.next())
			{
				System.out.println(rs.getString(2));
				System.out.println(rs.getString(3));
			}
			*/
			
		}
		catch(SQLException e)
		{
			info="register wrong";
			return false;
		}
		
	}
	

}