logrecorder.java

课程设计：ATM Project源码

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.tree.*;
import javax.swing.border.*;
import java.util.*;
import java.text.*;
import java.util.Date;
import java.net.*;
import java.io.*;
import java.sql.*;
public class LogRecorder{
	private String Operator;
	private String Type;
	private String Event;
	
	private String Card;
	private String IP;
	private String Detail;
	SimpleDateFormat DateFormatter=new SimpleDateFormat("yyyy/MM/dd");
	
       public LogRecorder(String operator,String type,String event){
       	this.Operator=operator;
       	this.Type=type;
       	this.Event=event;
       	RecLogin(Operator,Type,Event);
       }
       public LogRecorder(String Card,String Type,String IP,String Detail)
       {
       	RecOperate(Card,Type,IP,Detail);
       }
       
       public void RecLogin(String Operator,String Type,String Event){
       	try{
       	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	Connection connect=DriverManager.getConnection("jdbc:odbc:srvlog","","");
    	Statement odbc=connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  		String cmd=new String("INSERT INTO SysEvent"+"(LogDate,LogTime,Type,Operator,Event)"+
  		"VALUES('"+DateFormatter.format(new Date())+"','"+DateFormatter.format(new Date())
  		+"','"+Type+"','"+Operator+"','"+Event+"')");
  		System.out.println(cmd);
  		odbc.executeUpdate(cmd);
   		odbc.close();
  		connect.close();}
  		catch(SQLException Exp)
     	{
		System.out.println(Exp.toString());
        }
        catch(ClassNotFoundException Exp)
        {
         System.out.println(Exp.toString());
        }
        catch(Exception Exp)
        {
         System.out.println(Exp.toString());
        }
  		
       }
       public void RecOperate(String Card,String Type,String IP,String Detail){
       	try{
       	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	Connection connect=DriverManager.getConnection("jdbc:odbc:srvlog","","");
    	Statement odbc=connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
  		String cmd=new String("INSERT INTO CliEvent"+"(LogDate,LogTime,Type,CardID,AtmIP,AtmID,Detail)"+
  		"VALUES('"+DateFormatter.format(new Date())+"','"+DateFormatter.format(new Date())
  		+"','"+Type+"','"+Card+"','"+IP+"',1,'"+Detail+"')");
  		System.out.println(cmd);
  		odbc.executeUpdate(cmd);
   		odbc.close();
  		connect.close();}
  		catch(SQLException Exp)
     	{
		System.out.println(Exp.toString());
        }
        catch(ClassNotFoundException Exp)
        {
         System.out.println(Exp.toString());
        }
        catch(Exception Exp)
        {
         System.out.println(Exp.toString());
        }
       }
       


}