counter.java

NTsky新闻发布v1.0(提供JavaBean)

package ntsky.common;

import java.sql.*;
import ntsky.database.*;

public class Counter{

	public int total;
	public int counter;
	//判断有没有数
	public int total() throws Exception{
		String sql = "select count(*) as t from common;";
		DBConnect dbc = new DBConnect();
		ResultSet rs = dbc.executeQuery(sql);
		rs.next();
		int total = rs.getInt("t");
		rs.close();
		rs = null;
		return total; 
	}
	//无数据是先插入一个1
	public void num() throws Exception{
		String sql = "insert into common(counter) values(1);";
		DBConnect dbc = new DBConnect();
		dbc.executeUpdate(sql);
	}
	//记录数显示
	public int counter() throws Exception{
		String sql = "select * from common;";
		DBConnect dbc = new DBConnect();
		ResultSet rs = dbc.executeQuery(sql);
		rs.next();
		int counter = rs.getInt("counter");
		rs.close();
		rs = null;
		return counter;
	}
	//显示的数更新到数据库
	public void update(int counter) throws Exception{
		String sql = "update common set counter='"+counter+"';";
		DBConnect dbc = new DBConnect();
		dbc.executeUpdate(sql);
	}
}