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();
        }
    }
}