checklog.java

实现统一的人员日志管理系统管理后台

package com.tb.log.dwr;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.tb.log.factory.*;


public class CheckLog {
	Connection coon = null;
	PreparedStatement psm = null;
	ResultSet rs = null;
	
	public String checkLog(String log_state,String log_id) {
		String outPut = "";
		System.out.println("ok");
		coon = OracleDAOFactory.getConnection();
		try {
			coon.setAutoCommit(false);
			psm = coon.prepareStatement("update t_worklog set log_state=? where log_id=?");
			psm.setString(1, log_state);
			psm.setString(2, log_id);
			//System.out.println("a");	
			int a = psm.executeUpdate();
			//System.out.println("a:"+a);
			if(a ==1 ){
				outPut = "<font color='#ff0000'>"+log_state+"</font>";
			}else{
				outPut = "<font color='#ff0000'>"+"修改错误"+"</font>";
			}
			coon.commit();
			coon.setAutoCommit(true);
		} catch (SQLException e) {
			try {
				coon.rollback();
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			try {
				if(rs != null) rs.close();
				if(psm != null ) psm.close();
				if(coon != null) coon.close();
			} catch (Exception e) {
				System.out.println(" 登陆数据库验证异常 ！");
				e.printStackTrace();
			}
		}
		return outPut;
	}
	public static void main(String[] args) {
		System.out.println(new CheckLog().checkLog("优秀", "24"));
	}
}