?? prodstoredaoimpl.java
字號:
package control.dao.prodstore;import java.sql.Statement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Connection;import java.sql.DriverManager;import java.util.ArrayList;import utils.Keys;import beans.ProdStore;public class ProdStoreDAOImpl{ public static String flag=""; private Connection conn; private Statement stmt; private ResultSet rs; public ProdStoreDAOImpl(){ } public ArrayList showAll(){ ArrayList al=new ArrayList(); ResultSet rs2=null; Statement stmt2=null; String pName2=""; try{ conn=this.getConn(); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); rs=stmt.executeQuery("select * from ProdStore"); int pSID=0,pID=0,pINum=0,pONum=0,pSNum=0; String pDate=""; String pName=""; while(rs.next()){ pSID=rs.getInt("PSID"); pID=rs.getInt("PID"); pINum=rs.getInt("PINum"); pONum=rs.getInt("PONum"); pSNum=rs.getInt("PSNum"); pDate=rs.getString("PSDate"); rs2=stmt2.executeQuery("select pName from products where pID="+pID); if(rs2.next()) pName=rs2.getString("PName"); else pName="(沒有相關產品)"; ProdStore pd=new ProdStore(pSID,pName,pINum,pONum,pSNum,pDate); al.add(pd); } if(rs2 != null) rs2.close(); if(stmt2 != null) stmt2.close(); }catch(SQLException se){ System.out.println(se.getMessage()); return null; }finally{ this.closeConn(); } return al; } public Connection getConn(){ try{ Class.forName(Keys.connDriver); return DriverManager.getConnection(Keys.connUrl,Keys.connUsername,Keys.connPassword); }catch(ClassNotFoundException e){ return null; }catch(SQLException se){ return null; } } public void closeConn(){ try{ if(rs != null){ rs.close(); } if(stmt != null){ stmt.close(); } if(conn != null){ conn.close(); } }catch(SQLException e){ System.out.println(e.getMessage()); } }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -