sclosesocket.java

来自「windows系统下用java开发的网络入侵检测程序」· Java 代码 · 共 48 行

import java.sql.*;

/**
 * 
 * When user leave, set his/her state to offline and IP address to null.<p>
 * 2005.8.27
 * @version 0.1.2
 * @author Daxin Tian
 * 
 */
public class ScloseSocket {
	
	Connection con;
	Statement sql;
	
	/**
	 * 
	 * @param name Who leave the server.
	 */
	ScloseSocket(String name)
	{
		try
		{
			//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch(ClassNotFoundException e)
		{
			
		}
		try
		{
			//con=DriverManager.getConnection("jdbc:odbc:jidxdb","","");
			con=DriverManager.getConnection("jdbc:mysql://localhost/jidx");
			sql=con.createStatement();
			
			sql.execute("update register set state=0, ips=null where username='"+name+"'");
			con.close();
		}
		catch(SQLException e)
		{
			
		}
	}

}