logmanager.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.wap.sncs;

/**
 * <p>Title: wap II</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: sxit</p>
 * @author not attributable
 * @version 1.0
 */
import java.util.Vector;
import java.sql.*;
public class LogManager {
    public LogManager() {
    }
	public void log(Connection conn,String name,String content,Date date,String level, String type){
		PreparedStatement  statement = null;
		String sql = "insert into sxit_wap_log (ADMIN_NAME,LOG_CONTENG,LON_DATE,LOG_LEVEL,LOG_TYPE)values(?,?,?,?,?)";
		if (conn == null)
			return ;
		try {
			statement = conn.prepareStatement(sql);
			statement.setString(1,name);
			statement.setString(1,content);
			statement.setDate (1,date);
			statement.setString(1,level);
			statement.setString(1,type);
			int res = statement.executeUpdate ();
		} catch ( SQLException e1 ) {
			e1.printStackTrace ();
		}
		try {
			statement.close ();
		} catch ( SQLException e2 ) {
			e2.printStackTrace ();
		}

	}
	private Vector getBySQL(String sql){
		Vector logs = new Vector();
		Connection conn = com.sxit.wap.dacs.DBManager.getConnection();
		Statement statement = null;
		if (conn == null)
			return null;
		try {
			statement = conn.createStatement ();
			ResultSet result = statement.executeQuery ( sql );
			while (result.next() ) {
				Log log = new Log();
				log.setAdminName(result.getString(1));
				log.setLogContent(result.getString(2));
				log.setLogDate (result.getDate(3));
				log .setLogLevel(result.getString(4));
				log.setLogType (result.getString(5));
				logs.addElement(log);
			}
		} catch ( SQLException e1 ) {
			e1.printStackTrace ();
		} finally {
			com.sxit.wap.dacs.DBManager.freeConnection(conn,statement);
		}
		return logs;

	}
	public Vector getByAdminName(String adminName){
		String sql = "select * from sxit_wap_log where adminname = '" + adminName + "'";
		return this.getBySQL(sql);
	}
	public Vector getByDate(java.util.Date startDate,java.util.Date endDate){
		String sql = "select * from sxit_wap_log where LOG_DATE >= ? and LOG_DATE <=?" ;
		Vector logs = new Vector();
		Connection conn = com.sxit.wap.dacs.DBManager.getConnection();
		PreparedStatement statement = null;

		if (conn == null)
			return null;
		try {
			statement = conn.prepareStatement(sql);
			statement.setDate (1,new java.sql.Date(startDate.getTime()));
			statement.setDate (2,new java.sql.Date(endDate.getTime()));
			ResultSet res = statement.executeQuery ();
		} catch ( SQLException e1 ) {
			e1.printStackTrace ();
		}
		com.sxit.wap.dacs.DBManager.freeConnection(conn,statement);
		System.out.println(sql);
		return logs;
	}
	public Vector getAllLog(){
		String sql = "select * from sxit_wap_log ";
		return this.getBySQL(sql);
	}
	public static void main(String[] sss){
		LogManager logmanager = new LogManager();
		logmanager.getByDate(new java.util.Date(),new java.util.Date());
	}
}