pagebreak.java

软件上传下载网站,上传用户经过注册成为本站会员就可将将软件上传到本网站

package downreg;
import java.sql.*;
import java.lang.*;

public class PageBreak {

private Connection conn=null;
private ResultSet rs=null;
Statement stmt=null;
private int PageSize=0;//一页几个记录
private int PageNumber=0;//页号
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPasswd="324802";
String dbName="downreg";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd+"&useUnicode=true&characterEncoding=gb2312";
public PageBreak()
{
      try
        {
           Class.forName(driverName).newInstance();

        }
      catch (Exception e)
        {
        System.out.println("数据库驱动错误"+e);
        }


}

public ResultSet executeQuery(String sql)
{
rs=null;
try{
conn=DriverManager.getConnection(url);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException e){
System.err.println(e.getMessage());
}
return rs;
}

public int RecordNumber()//得到表的记录总数
{
rs=null;
int ColNumber=0;
try{
conn=DriverManager.getConnection(url);
stmt=conn.createStatement();
rs=stmt.executeQuery("select count(*) as ColNumber from individual_user" );

while (rs.next())
{
ColNumber=rs.getInt("ColNumber");
}
}
catch(SQLException e){
System.err.println(e.getMessage());
}
return ColNumber;
}

public void setPageSize(int pPageSize)//设置页面大小，并且计算出一共有多少页
{
this.PageSize=pPageSize;
int RecordNumber=this.RecordNumber();
this.PageNumber=(int)Math.floor(RecordNumber/PageSize);
}

public int getPageSize()//得到页面大小
{
return this.PageSize;
}

public int getPageNumber()//得到页面数
{
return this.PageNumber;
}

public void Close()//显示关闭连接
{
try
{
if(rs!=null)
{
  rs.close();
}
if(stmt!=null)
{
  stmt.close();
}
if(conn!=null)
{
  conn.close();
}
}
catch(SQLException e){
System.err.println(e.getMessage());
}
}
}