?? rspagedemo.java
字號:
import java.sql.*;
public class RsPageDemo
{
public static void main(String args[])
{
if(args.length!=2)
{
System.out.println("參數錯誤");
System.out.println("use:java RsPageDemo NoPage PageSzie");
return;
}
RsPageDemo rpd=new RsPageDemo();
String sql="select * from users";
int intPageNo=Integer.parseInt(args[0]);
int intPageSize=Integer.parseInt(args[1]);
rpd.queryRecord(rpd.openDatabase(),sql,intPageNo,intPageSize);
}
public Connection openDatabase()
{
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=HappyChat";
Connection conn=DriverManager.getConnection(url,"sa","");
return conn;
}
catch(Exception e)
{
System.out.println ("數據庫連接失敗!");
return null;
}
}
public void queryRecord(Connection con,String sql,int pageNo,int pageSize)
{
try
{
if(con==null)
throw new Exception("數據庫連接失敗!");
if(sql==null)
throw new Exception("查詢字符串不能為空");
int intRowCount;//記錄數
int intPageCount;//總頁數
Statement sm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=sm.executeQuery(sql);
ResultSetMetaData rsmd=rs.getMetaData();
int intColumn=rsmd.getColumnCount();
rs.last();
intRowCount=rs.getRow();
intPageCount=(intRowCount+pageSize-1)/pageSize;
if(intPageCount>0)
{
rs.absolute((pageNo-1)*pageSize+1);
int i=0;
while(i<pageSize&&!rs.isAfterLast())
{
for (int j=0;j<intColumn;j++)
{
String sTemp=rs.getString(j+1);
System.out.print(sTemp+" ");
}
i++;
rs.next();
System.out.println("");
}
}
}
catch(Exception e)
{
System.out.println (" 數據查詢錯誤!");
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -