?? getbunu.java
字號:
package imis_hous.com.impl;
import imis_hous.com.db.DBClose;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import cmis.database.DBPoolManager;
public class GetBuNu {
public HashMap getDepartmentNU(){
DBPoolManager dbpool = new DBPoolManager();
Statement stmt = null;
ResultSet rs = null;
HashMap hash= new HashMap();
DBClose dbclose = new DBClose();
String sql = "select b.buildingnu,b.buildingname from buildings_info b";
int i = 0;
dbpool.getConnection();
try {
stmt = dbpool.conn.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
hash.put(rs.getString("buildingnu"),rs.getString("buildingname"));
}
rs.close();
stmt.close();
} catch (SQLException e) {
} finally {
dbclose.CloseResultSet(rs);
dbclose.CloseStmt(stmt);
dbpool.freeConnection();
}
return hash;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -