seikyu.java

用strutshibernate做的项目

			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) {
					/**当商是除不尽的小数*/
					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;
	}
	
	/**
	 * ���̊֐��̍�该函数用于获得Seikyu表的List
	 * 通过sql语句查询数据库，将结果集封装为List返回
	 * @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;
	}

	/**
	 * 该函数用于分页显示时获得Seikyu表的List
	 * 通过sql语句以及分页信息查询数据库，将结果集封装为List返回����
	 * @param sqlstr，num每页显示条数，page当前页数
	 * @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) //通过每页显示条数及当前页数获取需要的结果集
				{
					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语句以及分页信息查询数据库
	 * 获得总页数以及当前页显示的第一条信息标号和最后一条信息标号���܂�
	 * @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;
	}
	
	/**
	 * 该函数用于获得结果集的总信息数
	 * @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;
	}
	
	/**
	 * 该函数用于获得数据库数据的更改时间
	 * @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;
	}
	
	/**
	 * 该函数用于获得数据库中最大id数
	 * @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;
	}

}