网上书店 java sql java sql 网上书店 java sql

package wyf; import java.sql.*; import java.util.*; public class DBBean { static Connection con; static PreparedStatement psGoodList; static PreparedStatement psGoodFromIdToPrice; static PreparedStatement psGoodFromIdToDetail; static PreparedStatement psCountRecords; static int span=5; static { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:shop","",""); psGoodList= con.prepareStatement( "select sid,sname,sprice from good", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); psGoodFromIdToPrice=con.prepareStatement("select sprice from good where sid=?"); psGoodFromIdToDetail=con.prepareStatement("select sname,sprice from good where sid=?"); psCountRecords=con.prepareStatement( "select count(sid) from good" ); } catch(Exception e) { e.printStackTrace(); } } public static String[][] getGoodList(int cp) { String[][] result=null; Vector v=new Vector(); try { ResultSet rs=psGoodList.executeQuery(); if(cp!=1) { rs.absolute((cp-1)*span); } int count=1; while(rs.next()&&count<=span) { count++; String[] tempsa=new String[3]; tempsa[0]=rs.getString(1); tempsa[1]=rs.getString(2); tempsa[2]=rs.getString(3); v.add(tempsa); } int size=v.size(); result=new String[size][]; for(int i=0;i<size;i++) { result[i]=(String[])v.elementAt(i); } } catch(Exception e) { e.printStackTrace(); } return result; } public static double getPrice(String sid) { double dd=0; try { psGoodFromIdToPrice.setString(1,sid); ResultSet rs=psGoodFromIdToPrice.executeQuery(); rs.next(); dd=Double.parseDouble(rs.getString(1)); } catch(Exception e) { e.printStackTrace(); } return dd; } public static String[] getDetail(String sid) { String[] ss=null; try { psGoodFromIdToDetail.setString(1,sid); ResultSet rs=psGoodFromIdToDetail.executeQuery(); rs.next(); ss=new String[2]; ss[0]=rs.getString(1); ss[1]=rs.getString(2); } catch(Exception e) { e.printStackTrace(); } return ss; } public static int getTotalPage() { int tp=0; try { ResultSet rs=psCountRecords.executeQuery(); rs.next(); int count=rs.getInt(1); tp=count/span+((count%span==0)?0:1); } catch(Exception e) { e.printStackTrace(); } return tp; } public static void main(String args[]) { System.out.println(DBBean.getTotalPage()); } }