backlog.java

来自「一个学生选课系统」· Java 代码 · 共 56 行

package com.student.dao;

import java.util.Calendar;

import com.student.DB.DbCont;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;

public class BackLog {
	public static void bckLog(String sql) throws SQLException
	{
		//获取当前系统时间
		Calendar c=Calendar.getInstance();
		String year=String.valueOf(c.get(Calendar.YEAR))+"年";
		String month=String.valueOf(c.get(Calendar.MONTH)+1)+"月";
		String day=String.valueOf(c.get(Calendar.DAY_OF_MONTH))+"日";
		String hour=String.valueOf(c.get(Calendar.HOUR_OF_DAY))+"时";
		String minute=String.valueOf(c.get(Calendar.MINUTE))+"分";
		String second=String.valueOf(c.get(Calendar.SECOND))+"秒";
		String str=year+month+day+hour+minute+second+"  "+sql;
        
		Connection conn=null;
		PreparedStatement pstmt=null;
		
		conn=(Connection) DbCont.getConn();
		String sql1="insert into logs values(?)";
		pstmt=conn.prepareStatement(sql1);
		pstmt.setString(1, str);
		pstmt.executeUpdate();
		if(conn!=null) conn.close();
		if(pstmt!=null) pstmt.close();
	}
	public static ArrayList getLog() throws SQLException
	{
		ArrayList log =new ArrayList();
		Connection conn=null;
		PreparedStatement pstmt=null;
		ResultSet rs=null;
		conn=(Connection) DbCont.getConn();
		String sql="select * from logs";
		pstmt=conn.prepareStatement(sql);
		rs=(ResultSet) pstmt.executeQuery();
		while(rs.next())
		{
			String sql1=rs.getString("actions");
			log.add(sql1);
		}
		return log;
	}
}