counter.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 58 行

package com.comingnet.bean;

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

import com.db.ProxoolAction;

public class Counter {
	private int count=0;
	
	public Counter()
	{
		Connection conn=null;
		PreparedStatement stmt=null;
		ResultSet rs=null;
		try {
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("select count from w_count");
			rs=stmt.executeQuery();
			while(rs.next())
			{
				this.count=rs.getInt(1);
			}
		} catch (Exception e) {
			System.out.println(e.toString());
		}finally{
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
	}
	
	public int getCount() {
		return count;
	}

	public void setCount(int count) {
		this.count = count;
	}

	public void doCount() {
		count++;
		Connection conn=null;
		PreparedStatement stmt=null;
		try {
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("update w_count set count="+count);
			stmt.executeUpdate();
		} catch (Exception e) {
			System.out.println(e.toString());
		}finally{
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
	}
}