log.java

淘客在线客服管理系统（TaokeOCS V3.2）

package msg;
import msg.*;
import java.io.*;
import java.util.*;
import java.lang.*;
import java.sql.*;
public class Log{

 	public Log(){}
	static public void  log(String msg){
		DbConn db=null;
		try{
			String sql="";
			ResultSet rs=null;
   			
			db=new msg.DbConn();
			if(db.getConnection()==null || db.isClosed())			 
				db.setConnection(); 
			Calendar now= Calendar.getInstance();
			String nowStr=String.valueOf(now.get(Calendar.YEAR))+"-"+String.valueOf(now.get(Calendar.MONTH)+1)+"-"+
						  String.valueOf(now.get(Calendar.DAY_OF_MONTH))+" "+String.valueOf(now.get(Calendar.HOUR_OF_DAY))+":"+
						  String.valueOf(now.get(Calendar.MINUTE))+":"+String.valueOf(now.get(Calendar.SECOND));	
			sql="insert into log values(\'"+nowStr+"\',\'"+msg+"\')";
			db.setSqlQuery(sql);	
			db.executeUpdate();	
			if(db.getConnection()!=null && !db.isClosed())
				db.closeConnection();	
		}catch(Exception e){
			try{
				if(db!=null && db.getConnection()!=null && !db.isClosed())
					db.closeConnection();			
			}catch(Exception e1){}
		}
	
	}

}