?? warelistbean.java
字號:
package Bean;
import Action.WareObj;
import java.util.ArrayList;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
/*
* Created by IntelliJ IDEA.
* User: ZhangRui
* Date: 2007-10-26
* Time: 9:52:44
*/
public class WareListBean {
public ArrayList WareList(){
ArrayList arr = new ArrayList();
try {
Connection conn = DatabaseConn.getConnection();
ResultSet rs=null;
String sql = "select * from shop";
PreparedStatement smt = conn.prepareStatement(sql);
rs = smt.executeQuery();
while (rs.next()) {
WareObj wareObj = new WareObj();
wareObj.setWareName(rs.getString("wareName"));
wareObj.setWareNum(rs.getInt("WareNum"));
wareObj.setWarePrice(rs.getDouble("WarePrice"));
arr.add(wareObj);
}
rs.close();
conn.close();
} catch (Exception e) {
System.out.println(e.toString());
}
return arr;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -