?? logtablewriter.java
字號:
package com.tool;
import javax.servlet.http.HttpServletRequest;
import com.bean.LogTable;
import com.dao.LogTableDAO;
import java.sql.SQLException;
import java.sql.Date;
import com.bean.AccountAndGroup;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2007</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class LogTableWriter {
public static void write(HttpServletRequest request, String operatorType,
String sql) throws SQLException {
try{
AccountAndGroup acountAndGroup = (AccountAndGroup)request.getSession().getAttribute("loginAcountAndGroup");
LogTableDAO.startTransation();
String dataTime = com.tool.MyDate.getDate("-");
// System.out.println(dataTime);
LogTable logTable = new LogTable();
logTable.setLogId(LogTableDAO.getLastId() + 1);
logTable.setOperatorDate(java.sql.Date.valueOf(dataTime));
logTable.setOperatorSql(sql);
logTable.setOperatorType(operatorType);
logTable.setOperatorUrl(request.getRequestURL().toString()+"?"+request.getQueryString());
logTable.setOperatorUser(new Integer(acountAndGroup.getAcountId()));
logTable.setUserIp(request.getRemoteAddr());
// System.out.println(logTable.getLogId()+","+logTable.getOperatorSql()+","+logTable.getOperatorType()+","+logTable.getOperatorUrl()+","+logTable.getOperatorUser()+","+logTable.getUserIp());
LogTableDAO.insertLogTable(logTable);
LogTableDAO.commit();
}catch(SQLException e){
e.printStackTrace();
throw e;
}finally{
LogTableDAO.rollback();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -