?? seikyu.java
字號(hào):
hiki_las_lv = "0";
} else if (ty != 0.0) {
double lv = hi / ty;
System.out.println("lv+++++>>>" + lv);
hiki_lv = String.valueOf(lv);
StringTokenizer str = new StringTokenizer(hiki_lv, ".");
String hiki_lv_fir = str.nextToken();
if (str.hasMoreTokens() == true) {
String hiki_lv_las = str.nextToken();
System.out.println("hiki_lv_las string shi ======="
+ hiki_lv_las);
boolean isnotnum = NumberUtil.isnotNum(hiki_lv_las);
if (isnotnum == true) {
hiki_las_lv = "0.00%";
} else if (isnotnum == false) {
/**當(dāng)商是除不盡的小數(shù)*/
if (hiki_lv_las.length() >= 5) {
String hiki_las_five = hiki_lv_las.substring(0, 5);
String hiki_tow = hiki_lv_las.substring(0, 2);
String hiki_three = hiki_lv_las.substring(2, 3);
System.out.println("hiki_las_five shi ======="
+ hiki_las_five);
int hiki_las_fo = Integer.parseInt(hiki_las_five
.substring(2, 3));
int hiki_las_fi = Integer.parseInt(hiki_las_five
.substring(3, 4));
System.out.println("hiki_las_fo shi ======="
+ hiki_las_fo);
System.out.println("hiki_las_fi shi ======="
+ hiki_las_fi);
if (hiki_las_fi >= 5) {
hiki_las_fo++;
}
if (hiki_lv_fir.equals("0")) {
if (hiki_tow.equals("00")) {
las_num = "0." + hiki_three
+ String.valueOf(hiki_las_fo) + "%";
} else if (hiki_tow.substring(0, 1).equals("0")) {
las_num = hiki_tow.substring(1, 2) + "."
+ hiki_three
+ String.valueOf(hiki_las_fo) + "%";
} else if (!hiki_tow.equals("00")) {
las_num = hiki_tow + "." + hiki_three
+ String.valueOf(hiki_las_fo) + "%";
}
} else {
las_num = hiki_lv_fir + hiki_tow + "." + hiki_three
+ String.valueOf(hiki_las_fo) + "%";
}
System.out.println("las_num shi =======" + las_num);
hiki_las_lv = las_num;
} else if (hiki_lv_las.length() >= 3
&& hiki_lv_las.length() < 5) {
String one = hiki_lv_las.substring(0, 1);
int tow = Integer.parseInt(hiki_lv_las.substring(1, 2));
int three = Integer.parseInt(hiki_lv_las
.substring(2, 3));
if (three >= 5) {
tow++;
}
hiki_las_lv = hiki_lv_fir + "." + one
+ String.valueOf(tow) + "%";
} else if (hiki_lv_las.length() == 1) {
hiki_las_lv = String.valueOf(lv) + "0" + "%";
} else if (hiki_lv_las.length() == 2) {
hiki_las_lv = String.valueOf(lv) + "%";
}
}
}
}
System.out.println("lv d zhi shi =======" + hiki_las_lv);
return hiki_las_lv;
}
/**
* ?????????該函數(shù)用于獲得Seikyu表的List
* 通過sql語句查詢數(shù)據(jù)庫，將結(jié)果集封裝為L(zhǎng)ist返回
* @param sqlstr
* @return
* @author 楊麗娟 2006-04-17
*/
public static List getBeanList(String sqlstr){
BatchDBConnectionUtil con = new BatchDBConnectionUtil();
ResultSet rs = con.executeQuery(sqlstr);
List beanList = new ArrayList();
try {
while(rs.next()){
Seikyu SL = new Seikyu();
int id = Integer.parseInt(rs.getString("ID"));
SL.setId(id);
int nen = Integer.parseInt(rs.getString("NEN"));
SL.setNen(nen);
SL.setHelinen(nen);
int hagaki_id = Integer
.parseInt(rs.getString("HAGAKI_ID"));
SL.setHagaki_id(hagaki_id);
String hagaki_mie = Hagakicd
.selectHagaki_mei(hagaki_id);
SL.setHagaki_mie(hagaki_mie);
int toukyu_id = Integer
.parseInt(rs.getString("TOUKYU_ID"));
SL.setToukyu_id(toukyu_id);
String toukyu_mie = Toukyucd.selectToukyu_mei(toukyu_id);
SL.setToukyu_mie(toukyu_mie);
int kumi_kubun = Integer
.parseInt(rs.getString("KUMI_KUBUN"));
SL.setKumi_kubun(kumi_kubun);
String kumi = StringUtil
.trans_date(rs.getString("KUMI"));
SL.setKumi(kumi);
String bangou = StringUtil
.trans_date(rs.getString("BANGOU"));
SL.setBangou(bangou);
int ken_id = Integer.parseInt(rs.getString("KEN_ID"));
SL.setKen_id(ken_id);
String kyoku_id = StringUtil
.trans_date(rs.getString("KYOKU_ID"));
SL.setKyoku_id(kyoku_id);
String kyokusyo_mei = Kyokusyo
.selectKyokusyo_mei(ken_id,kyoku_id);
SL.setKyokusyo_mei(kyokusyo_mei);
int syouhin_id = Integer.parseInt(rs.getString("SYOUHIN_ID"));
SL.setSyouhin_id(syouhin_id);
Date seikyu_date = DataTypeCheck
.StringtoDate(rs.getString("SEIKYU_DATE"));
SL.setSeikyu_date(seikyu_date);
Date kettei_date = DataTypeCheck
.StringtoDate(rs.getString("KETTEI_DATE"));
SL.setKettei_date(kettei_date);
Date hassou_date = DataTypeCheck
.StringtoDate(rs.getString("HASSOU_DATE"));
SL.setHassou_date(hassou_date);
int h_zipcd_mae = Integer
.parseInt(rs.getString("H_ZIPCD_MAE"));
SL.setH_zipcd_mae(h_zipcd_mae);
int h_zipcd_ato = Integer
.parseInt(rs.getString("H_ZIPCD_ATO"));
SL.setH_zipcd_ato(h_zipcd_ato);
String h_atena = StringUtil
.trans_date(rs.getString("H_ATENA"));
SL.setH_atena(h_atena);
String h_jusyo = StringUtil
.trans_date(rs.getString("H_JUSYO"));
SL.setH_jusyo(h_jusyo);
String h_tel = StringUtil
.trans_date(rs.getString("H_TEL"));
SL.setH_tel(h_tel);
Date h_sitei_date = DataTypeCheck
.StringtoDate(rs.getString("H_SITEI_DATE"));
SL.setH_sitei_date(h_sitei_date);
int h_jitaku = Integer
.parseInt(rs.getString("H_JITAKU"));
SL.setH_jitaku(h_jitaku);
String h_jiysku_mei;
if(h_jitaku == 0){
h_jiysku_mei = "???ǒ???";
}
else{
h_jiysku_mei = "?z??";
}
SL.setH_jiysku_mei(h_jiysku_mei);
String syouhin_ryaku = Syouhin
.selectSyouhin_ryaku(nen,hagaki_id,
toukyu_id, syouhin_id);
SL.setSyouhin_ryaku(syouhin_ryaku);
beanList.add(SL);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
con.close();
return beanList;
}
/**
* 該函數(shù)用于分頁顯示時(shí)獲得Seikyu表的List
* 通過sql語句以及分頁信息查詢數(shù)據(jù)庫，將結(jié)果集封裝為L(zhǎng)ist返回????
* @param sqlstr，num每頁顯示條數(shù)，page當(dāng)前頁數(shù)
* @param page
* @return List
* @author 楊麗娟 2006-04-17
*/
public static List getPageBeanList(String sqlstr,int num,int page){
BatchDBConnectionUtil con = new BatchDBConnectionUtil();
ResultSet rs = con.executeQuery(sqlstr);
List beanList = new ArrayList();
try {
int i=0;
while(rs.next())
{
if(i >= (page-1)*num && i < page*num) //通過每頁顯示條數(shù)及當(dāng)前頁數(shù)獲取需要的結(jié)果集
{
Seikyu SL = new Seikyu();
int id = Integer.parseInt(rs.getString("ID"));
SL.setId(id);
int nen = Integer.parseInt(rs.getString("NEN"));
SL.setNen(nen);
SL.setHelinen(nen);
int hagaki_id = Integer
.parseInt(rs.getString("HAGAKI_ID"));
SL.setHagaki_id(hagaki_id);
String hagaki_mie = Hagakicd
.selectHagaki_mei(hagaki_id);
SL.setHagaki_mie(hagaki_mie);
int toukyu_id = Integer
.parseInt(rs.getString("TOUKYU_ID"));
SL.setToukyu_id(toukyu_id);
String toukyu_mie = Toukyucd.selectToukyu_mei(toukyu_id);
SL.setToukyu_mie(toukyu_mie);
int kumi_kubun = Integer
.parseInt(rs.getString("KUMI_KUBUN"));
SL.setKumi_kubun(kumi_kubun);
String kumi = StringUtil
.trans_date(rs.getString("KUMI"));
SL.setKumi(kumi);
String bangou = StringUtil
.trans_date(rs.getString("BANGOU"));
SL.setBangou(bangou);
int ken_id = Integer.parseInt(rs.getString("KEN_ID"));
SL.setKen_id(ken_id);
String kyoku_id = StringUtil
.trans_date(rs.getString("KYOKU_ID"));
SL.setKyoku_id(kyoku_id);
String kyokusyo_mei = Kyokusyo
.selectKyokusyo_mei(ken_id,kyoku_id);
SL.setKyokusyo_mei(kyokusyo_mei);
int syouhin_id = Integer.parseInt(rs.getString("SYOUHIN_ID"));
SL.setSyouhin_id(syouhin_id);
Date seikyu_date = DataTypeCheck
.StringtoDate(rs.getString("SEIKYU_DATE"));
SL.setSeikyu_date(seikyu_date);
Date kettei_date = DataTypeCheck
.StringtoDate(rs.getString("KETTEI_DATE"));
SL.setKettei_date(kettei_date);
Date hassou_date = DataTypeCheck
.StringtoDate(rs.getString("HASSOU_DATE"));
SL.setHassou_date(hassou_date);
int h_zipcd_mae = Integer
.parseInt(rs.getString("H_ZIPCD_MAE"));
SL.setH_zipcd_mae(h_zipcd_mae);
int h_zipcd_ato = Integer
.parseInt(rs.getString("H_ZIPCD_ATO"));
SL.setH_zipcd_ato(h_zipcd_ato);
String h_atena = StringUtil
.trans_date(rs.getString("H_ATENA"));
SL.setH_atena(h_atena);
String h_jusyo = StringUtil
.trans_date(rs.getString("H_JUSYO"));
SL.setH_jusyo(h_jusyo);
String h_tel = StringUtil
.trans_date(rs.getString("H_TEL"));
SL.setH_tel(h_tel);
Date h_sitei_date = DataTypeCheck
.StringtoDate(rs.getString("H_SITEI_DATE"));
SL.setH_sitei_date(h_sitei_date);
int h_jitaku = Integer
.parseInt(rs.getString("H_JITAKU"));
SL.setH_jitaku(h_jitaku);
String h_jiysku_mei;
if(h_jitaku == 0){
h_jiysku_mei = "???ǒ???";
}
else{
h_jiysku_mei = "?z??";
}
SL.setH_jiysku_mei(h_jiysku_mei);
String syouhin_ryaku = Syouhin
.selectSyouhin_ryaku(nen,hagaki_id,
toukyu_id, syouhin_id);
SL.setSyouhin_ryaku(syouhin_ryaku);
beanList.add(SL);
System.out.println("HLnian is **#?<<??>>" + SL.getHelinen());
}
i++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
con.close();
return beanList;
}
/**
* 通過sql語句以及分頁信息查詢數(shù)據(jù)庫
* 獲得總頁數(shù)以及當(dāng)前頁顯示的第一條信息標(biāo)號(hào)和最后一條信息標(biāo)號(hào)?????
* @param num
* @param page
* @param jusuokodo
* @return int[]
* @author 楊麗娟
*/
public static int[] getPagenum(int num,int page,String sqlstr){
BatchDBConnectionUtil con = new BatchDBConnectionUtil();
ResultSet rs = con.executeQuery(sqlstr);
int[] pnum = new int[3];
int pagenum = 0;
int startnum = 0;
int endnum = 0;
try {
if(rs.next()){
rs.last();
int cont = rs.getRow();
rs.beforeFirst();
pagenum = cont/num + 1;
pnum[0] = pagenum;
startnum = (page-1) * num + 1;
pnum[1] = startnum;
if(cont <= num){
endnum = cont;
}
else{
if(cont-(page-1)*num > num){
endnum = page*num;
}
else{
endnum = cont;
}
}
pnum[2] = endnum;
}
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return pnum;
}
/**
* 該函數(shù)用于獲得結(jié)果集的總信息數(shù)
* @param sqlstr
* @return int
* @author 楊麗娟 2006-04-16
*/
public static int getCont(String sqlstr){
BatchDBConnectionUtil con = new BatchDBConnectionUtil();
ResultSet rs = con.executeQuery(sqlstr);
int cont = 0;
try {
if(rs.next()){
rs.last();
cont = rs.getRow();
}
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return cont;
}
/**
* 該函數(shù)用于獲得數(shù)據(jù)庫數(shù)據(jù)的更改時(shí)間
* @param sqlstr
* @return List
* @author? 楊麗娟 2006-04-17
*/
public static List getUpdate_Date(String sqlstr){
List Datelist = new ArrayList();
BatchDBConnectionUtil con = new BatchDBConnectionUtil();
ResultSet rs = con.executeQuery(sqlstr);
try {
if(rs.next()){
String update_date = rs.getString("UPDATE_DATE");
Datelist.add(update_date);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
con.close();
return Datelist;
}
/**
* 該函數(shù)用于獲得數(shù)據(jù)庫中最大id數(shù)
* @return int
* @author? 楊麗娟 2006-04-17
*/
public static int getMaxID(){
int maxid = 0;
String sqlstr = "SELECT MAX(ID) AS CONT FROM SEIKYU";
BatchDBConnectionUtil con = new BatchDBConnectionUtil();
ResultSet rs = con.executeQuery(sqlstr);
try {
if(rs.next()){
maxid = Integer.parseInt(rs.getString("CONT"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return maxid;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -