package my; import java.sql.*; import java.util.*; public class PageQueryJB {
public List query(String key,int pageNO) { List result=null;
try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String url="jdbc:
sqlserver://localhost:1433;databaseName=pubs;String user=sa;String pw=12345"; Connection con=DriverManager.getConnection(url); Statement st=con.createStatement(); int skip=(pageNO-1)*3; String sql="select recID,title,type,price from titles " + " where title like '%"+key+"%'"; ResultSet rs=st.executeQuery(sql); int counter=1; while(rs.next()&;&;counter<=3) { String id=rs.getString("recID"); String title=rs.getString("title"); String type=rs.getString("type"); String price=rs.getString("price"); QueryVO record=new QueryVO(); record.setRecID(id); record.setTitle(title); record.setType(type); record.setPrice(price); result.add(record); counter++; } con.close();
}catch(Exception e) {System.out.print("出错:"+e);} return result; } }