onetitle.java

jsp编程的源代码

package com.mybean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import com.myopdb.DBCon;

public class OneTitle {

	private int oneid;

	private String onetitle;

	private Connection con = null;

	private Statement stmt = null;

	private ResultSet rs = null;

	private ArrayList<Object> lst = null;

	DBCon dbo = new DBCon();

	public String getOnetitle() {
		return onetitle;
	}

	public void setOnetitle(String onetitle) {
		this.onetitle = onetitle;
	}

	public boolean addTitle(OneTitle one) {

		return true;
	}

	public int getOneid() {
		return oneid;
	}

	public void setOneid(int oneid) {
		this.oneid = oneid;
	}

	public ArrayList getAllOneTitle() {

		OneTitle one;
		lst = new ArrayList<Object>();
		final String sql = "select * from onetitle order by onetitle";
		this.con = dbo.getCon();
		if (con != null) {
			try {
				stmt = con.createStatement();
				rs = stmt.executeQuery(sql);
				while (rs.next()) {
					one = new OneTitle();
					one.setOneid(rs.getInt(1));
					one.setOnetitle(rs.getString(2));
					lst.add(one);
				}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
				return null;
			}
		}
		return lst;
	}

	int intRowCount;// 数据的总记录数

	int intPageCount;// 总页数

	int intPageSize = 10;// 每页行数

	int intPage;// 当前第几页

	public ArrayList getAllOneTitle(int curpage) {

		OneTitle one;
		lst = new ArrayList<Object>();
		final String sql = "select * from onetitle order by onetitle";
		this.con = dbo.getCon();

		if (con != null) {
			try {
				stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
						ResultSet.CONCUR_UPDATABLE);
				rs = stmt.executeQuery(sql);
				rs.last();
				intRowCount = rs.getRow();
				System.out.println(intRowCount);
				if (intRowCount % intPageSize == 0) {
					intPageCount = intRowCount / intPageSize;
				} else {
					intPageCount = intRowCount / intPageSize + 1;
				}
				if (curpage == 0) {
					intPage = 1;
				} else {
					intPage = curpage;
					if (intPage < 1 || intPage > intPageCount) {
						intPage = 1;
					}
				}

				// 将对记录集进行操作，以显示数据,
				// 首先要将记录集的指针移到要显示页面的第一条记录上面
				rs.absolute((intPage - 1) * intPageSize + 1);
				// 循环显示当前指定页面的数据
				int i = 0;
				while (i < intPageSize && !rs.isAfterLast()) {
					one = new OneTitle();
					one.setOneid(rs.getInt(1));
					one.setOnetitle(rs.getString(2));
					lst.add(one);
					rs.next();
					i++;
				}

				System.out.println(i);
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
				return null;
			}
		}
		lst.add(this.intPage);
		lst.add(this.intPageCount);
		return lst;

	}

	public boolean insertOneTitle(OneTitle one) {
		String sql = "insert into onetitle values('" + one.getOnetitle() + "')";
		if (this.con == null) {
			this.con = dbo.getCon();
		}
		try {
			stmt = con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		return true;
	}

	public boolean deleteOneTitle(OneTitle ot) {
		String sql = "delete from onetitle where oneid=" + ot.getOneid() + "";
		if (this.con == null) {
			this.con = dbo.getCon();
		}

		try {
			stmt = con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		return true;
	}
	
	public boolean updateOneTitle(OneTitle ot)
	{
		String sql="update onetitle set onetitle='"+ot.getOnetitle()+"' where oneid="+ot.getOneid()+"";
		if(this.con==null)
		{
			this.con=dbo.getCon();
		}
		try {
			stmt=con.createStatement();
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return false;
		}
		return true;
	}
}