package net.btdz.oa.common;
import net.btdz.oa.common.*;
import java.util.*;
import java.text.*;
import java.sql.*;
public class AddLog {
public AddLog(int strtype,int xbid,int xbobjectid,String xbloginfo){
String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
Connection conn = null;
Statement s= null;
int rs;
try{
conn = ConnectionPoolBean.getConnection();
String sql="insert into oalogs(logtype,per_id,objectid,logtime,loginfo) values ("+strtype+","+xbid+","+xbobjectid+",'"+date+"','下载附件')";
System.out.print(sql);
s=conn.createStatement();
rs=s.executeUpdate(sql);
}
catch(SQLException se){
}
finally
{
try{//关闭顺序
if(s!=null) s.close();
if(conn!=null) conn.close();
}catch(SQLException sqle){sqle.printStackTrace();}
}
}}
import net.btdz.oa.common.*;
import java.util.*;
import java.text.*;
import java.sql.*;
public class AddLog {
public AddLog(int strtype,int xbid,int xbobjectid,String xbloginfo){
String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
Connection conn = null;
Statement s= null;
int rs;
try{
conn = ConnectionPoolBean.getConnection();
String sql="insert into oalogs(logtype,per_id,objectid,logtime,loginfo) values ("+strtype+","+xbid+","+xbobjectid+",'"+date+"','下载附件')";
System.out.print(sql);
s=conn.createStatement();
rs=s.executeUpdate(sql);
}
catch(SQLException se){
}
finally
{
try{//关闭顺序
if(s!=null) s.close();
if(conn!=null) conn.close();
}catch(SQLException sqle){sqle.printStackTrace();}
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货