【Java开源代码栏目提醒】:以下是网学会员为您推荐的Java开源代码-WaresList.java,希望本篇文章对您学习有所帮助。
package com;
import java.util.*;
import java.sql.*;
public class WaresList {
private Vector Wares = new Vector();
private int PageSize;
private int PageNow;
private int PageNum;
private int TotalPages;
private String PageStr;
private int WaresId;
private Connection con;
private int Status;
public void Cart() {
}
public Wares getOne(int index) {
return (Wares)Wares.elementAt(index);
}
public int getPageNow() {
return PageNow;
}
public int getPageNum() {
return pageNum;
}
public int getTotalPages () {
return TotalPages;
}
public int getWaresId() {
return WaresId;
}
public int getStatus() {
returns Status;
}
public void setConnection(Connection con) {
this.con = con;
}
public void setPageNow(String index) {
PageStr = index;
}
public void setWaresId(int WaresId) {
this.WaresId = WaresId;
}
public Wares storeWares(){
try {
Statement stmt = con.createStatement();
String sql = "select * from wares where Id=" + WaresId;
ResultSet rs= stmt.executeQuery(sql);
if(rs.next()) {
Wares one = new Wares();
one.setOne(rs.getInt("Id"),
rs.getInt("Sort");
rs.getString("Name"),
rs.getDouble("MarketPrice"),
rs.getDouble("Price"),
rs.getString("Description"),
rs.getString("SmallImg"),
rs.getString("BigImg")),
return one;
}
}catch(SQLException e) {
DBLog.getLog().println(DateTime.getDateTime()+" "+e.toString());
}
return null;
}
public void storeList() {
try {
Statement stmt = con.createStatement();
String sql = "select * from wares";
ResultSet rs= stmt.executeQuery(sql);
rs.absolute(-1);
int TotalPages = rs.getRow();
if (PageStr != null && !PageStr.equals("")) {
try {
PageNow = Integer.parseInt(PageStr);
}
catch(NumberFormatException e) {
PageNow = 1;
}
if(PageNow < 1)
PageNow = 1;
if((PageNow - 1) * PageSize > TotalPages)
PageNow = TotalPages/ PageSize + 1;
}
TotalPages= Total/ PageSize + 1;
if(PageNow * PageSize >Total)
PageNum = Total - (PageNow - 1) * PageSize;
else
PageNum = PageSize;
rs.absolute((PageNow - 1) * PageSize + 1);
for(int i = 0;i < PageNum;i ++) {
Wares one= new Wares();
one.setOne(rs.getInt("Id"),
rs.getInt("Sort"),
rs.getString("Name"),
rs.getDouble("MarketPrice"),
rs.getDouble("Price"),
rs.getString("Description"),
rs.getString("SmallImg"),
rs.getString("BigImg")
);
Wares.addElement(one);
rs.next();
}
rs.close();
stmt.close();
}
catch(SQLException e) {
DBLog.getLog().println(DateTime.getDateTime()+" "+e.toString());
status = 1;
}
}
public void reset() {
PageSize = 4;
PageNow = 1;
pageNum = 0;
Status = 0;
Wares.removeAllElements();
}
上一篇:
WareServlet.java
下一篇:
关于大学英语教学