?? poixlsdb.java
字號:
ResultSet rs = null;
try {
// ps=dataCon.getcon().prepareStatement(sql);
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
py1 = rs.getString("py_code");// .substring(0,1);
}
} catch (SQLException ex) {
// logger.error(ex.getMessage());
throw new Exception("添加入庫錯誤");
} finally {
if (ps != null) {
ps.close();
}
if (rs != null)
rs.close();
if (conn != null)
conn.close();
}
return py1;
}
/**
* 判斷是否是城市
* @param conn
* @param city
* @return
* @throws Exception
*/
private boolean isCity(Connection conn, String city) throws Exception {
// String sql="select bran_name from EMAP_MGR_BRANCH ";
String sql = "select dist_code from EMAP_MGR_DIST where dist_name like '"+city+"%";
PreparedStatement ps = null;
ArrayList alist = new ArrayList();
long code = 0;
boolean isCity=false;
ResultSet rs = null;
try {
// ps=dataCon.getcon().prepareStatement(sql);
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
code = rs.getLong("dist_code");// .substring(0,1);
}
} catch (SQLException ex) {
// logger.error(ex.getMessage());
throw new Exception("isCity查詢庫錯誤");
} finally {
if (ps != null) {
ps.close();
}
if (rs != null)
rs.close();
if (conn != null)
conn.close();
}
if (code>0){
isCity=true;
}
return isCity;
}
private long getBranch(Connection conn, String branchname) throws Exception {
// String sql="select bran_name from EMAP_MGR_BRANCH ";
String sql = "select bran_code from BRAN_CODE where BRAN_name like '"+branchname+"%";
PreparedStatement ps = null;
ArrayList alist = new ArrayList();
long code = 0;
ResultSet rs = null;
try {
// ps=dataCon.getcon().prepareStatement(sql);
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
code = rs.getLong("bran_code");// .substring(0,1);
}
} catch (SQLException ex) {
// logger.error(ex.getMessage());
throw new Exception("getBranch庫錯誤");
} finally {
if (ps != null) {
ps.close();
}
if (rs != null)
rs.close();
if (conn != null)
conn.close();
}
return code;
}
public static boolean iscity2(String city){
boolean iscity=false;
for(int i=0;i<staticcitys.length;i++){
if (city.indexOf("市")>-1){
if (staticcitys[i].equals(city)){
iscity=true;
}
}else{
city=city+"市";
if (staticcitys[i].equals(city)){
iscity=true;
}
}
}
return iscity;
}
public static String getbrancode(String branname){
String brancode="";
for(int i=0;i<staticbranchs.length;i++){
if (staticbranchs[i].equals(branname)){
brancode=staticbranchs[i-1].trim();
}
}
return brancode;
}
/**
* 城市的靜態列表,上海交行
*/
static String[] staticcitys = {
"北京市",
"天津市",
"石家莊市",
"唐山市",
"秦皇島市",
"太原市",
"晉城市",
"呼和浩特市",
"包頭市",
"沈陽市",
"鞍山市",
"撫順市",
"丹東市",
"錦州市",
"營口市",
"遼陽市",
"大連市",
"長春市",
"吉林市",
"哈爾濱市",
"齊齊哈爾市",
"大慶市",
"上海市",
"南京市",
"徐州市",
"連云港市",
"揚州市",
"泰州市",
"南通市",
"鎮江市",
"常州市",
"鹽城市",
"蘇州市",
"無錫市",
"杭州市",
"溫州市",
"嘉興市",
"湖州市",
"紹興市",
"臺州市",
"金華市",
"寧波市",
"合肥市",
"蕪湖市",
"蚌埠市",
"淮南市",
"安慶市",
"馬鞍山市",
"福州市",
"泉州市",
"廈門市",
"南昌市",
"景德鎮市",
"新余市",
"九江市",
"濟南市",
"淄博市",
"濰坊市",
"通化市",
"煙臺市",
"威海市",
"濟寧市",
"泰安市",
"青島市",
"鄭州市",
"洛陽市",
"武漢市",
"黃石市",
"宜昌市",
"襄樊市",
"長沙市",
"岳陽市",
"廣州市",
"珠海市",
"汕頭市",
"東莞市",
"中山市",
"佛山市",
"揭陽市",
"惠州市",
"江門市",
"深圳市",
"南寧市",
"柳州市",
"桂林市",
"梧州市",
"北海市",
"海南省",
"重慶市",
"成都市",
"自貢市",
"攀枝花市",
"貴陽市",
"遵義市",
"昆明市",
"曲靖市",
"玉溪市",
"西安市",
"咸陽市",
"蘭州市",
"銀川市",
"烏魯木齊市",
"延邊市",
"楚雄市"
};
/**
* 上海分行列表信息
*/
static String[] staticbranchs = {
" 0516 ","寧夏分行" ,
" 1 ","淮南分行" ,
" 103 ","江西省分行" ,
" 109 ","重慶市分行" ,
" 112 ","常州分行" ,
" 1138 ","華南審計部" ,
" 116 ","河北省分行" ,
" 118 ","梧州分行" ,
" 12 ","山西省分行" ,
" 128 ","河南省分行" ,
" 1304 ","華西授信中心" ,
" 131 ","自貢分行" ,
" 133 ","泰安分行" ,
" 136 ","黑龍江省分行" ,
" 1371 ","華西審計部" ,
" 138 ","湖北省分行" ,
" 14 ","丹東分行" ,
" 141 ","天津市分行" ,
" 144 ","吉林省分行" ,
" 148 ","無錫分行" ,
" 150 ","蘇州分行" ,
" 153 ","秦皇島分行" ,
" 16 ","洛陽分行" ,
" 163 ","海南省分行" ,
" 169 ","濰坊分行" ,
" 1716 ","惠州分行" ,
" 172 ","安慶分行" ,
" 176 ","桂林分行" ,
" 18 ","新余分行" ,
" 183 ","鞍山分行" ,
" 1865 ","華中授信中心" ,
" 187 ","連云港分行" ,
" 193 ","大慶分行" ,
" 195 ","宜昌分行" ,
" 20 ","陜西省分行" ,
" 202 ","九江分行" ,
" 208 ","東北審計部" ,
" 210 ","泰州分行" ,
" 22 ","江蘇省分行" ,
" 222 ","揚州分行" ,
" 24 ","汕頭分行" ,
" 242 ","遵義分行" ,
" 245 ","鎮江分行" ,
" 256 ","黃石分行" ,
" 258 ","新疆分行" ,
" 260 ","吉林分行" ,
" 2697 ","華東授信中心" ,
" 271 ","華北審計部" ,
" 274 ","貴州省分行" ,
" 28 ","錦州分行" ,
" 284 ","煙臺分行" ,
" 287 ","太平洋卡中心" ,
" 296 ","延邊分行" ,
" 298 ","中山分行" ,
" 3 ","岳陽分行" ,
" 30 ","云南省分行" ,
" 3022 ","鹽城分行" ,
" 3027 ","華北授信中心" ,
" 307 ","柳州分行" ,
" 318 ","蕪湖分行" ,
" 32 ","嘉興分行" ,
" 321 ","華東審計部" ,
" 323 ","臺州分行" ,
" 342 ","廈門分行" ,
" 350 ","華中審計部" ,
" 36 ","濟寧分行" ,
" 361 ","楚雄分行" ,
" 369 ","曲靖分行" ,
" 3719 ","東京分行" ,
" 38 ","營口分行" ,
" 388 ","威海分行" ,
" 3915 ","新加坡分行" ,
" 40 ","香港分行" ,
" 404 ","淄博分行" ,
" 4146 ","馬鞍山分行" ,
" 42 ","深圳分行" ,
" 4223 ","倫敦分行" ,
" 423 ","徐州分行" ,
" 4261 ","紐約分行" ,
" 427 ","泉州分行" ,
" 44 ","東莞分行" ,
" 46 ","珠海分行" ,
" 477 ","景德鎮分行" ,
" 49 ","北京市分行" ,
" 5 ","福建省分行" ,
" 51 ","廣西分行" ,
" 525 ","撫順分行" ,
" 54 ","南通分行" ,
" 550 ","唐山分行" ,
" 556 ","攀枝花分行" ,
" 56 ","湖南省分行" ,
" 58 ","安徽省分行" ,
" 591 ","北海分行" ,
" 60 ","四川省分行" ,
" 63 ","青島分行" ,
" 649 ","華南授信中心" ,
" 65 ","浙江省分行" ,
" 675 ","晉城分行" ,
" 678 ","遼陽支行" ,
" 69 ","上海市分行" ,
" 7 ","山東省分行" ,
" 71 ","紹興分行" ,
" 73 ","甘肅省分行" ,
" 75 ","廣東省分行" ,
" 77 ","包頭分行" ,
" 772 ","法蘭克福分行" ,
" 791 ","揭陽支行" ,
" 793 ","玉溪分行" ,
" 866 ","蚌埠分行" ,
" 89 ","佛山分行" ,
" 898 ","金華分行" ,
" 9 ","大連分行" ,
" 9001 ","江門分行" ,
" 91 ","溫州分行" ,
" 93 ","齊齊哈爾分行" ,
" 95 ","湖州分行" ,
" 951 ","內蒙古分行" ,
" 97 ","遼寧省分行" ,
" 977 ","咸陽分行" ,
" 99 ","寧波分行"
};
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -