chargestandarddao.java

文件的上传和下载的实现,用JAva编写,非常简单

/** 
* Copyright 2007 Wuhan University of Technology. 
* All right reserved. 
* Create on 2007-3-18
*/

package edu.whut.cwts.maintain.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;

import edu.whut.cwts.datasource.DBConnect;
import edu.whut.cwts.maintain.bean.ChargeStandard;
import edu.whut.cwts.maintain.util.DateUtil;
/**
 * @author dwr
 *
 */
public class ChargeStandardDAO {
	
	public static ChargeStandard getChargeStandard(String fzdm)
	{
		fzdm=fzdm.trim();
		ChargeStandard chargeStandard=new ChargeStandard();
		DBConnect dbconn=new DBConnect();		
		String sql = "select fzmc,sfbz,sfyy,sfjd,sfznj,jfdw from zfbz ";
		sql += "WHERE ";
		sql += "fzdm = '" + fzdm + "' ";			
		
		try
		{
			ResultSet rs = dbconn.executeQuery(sql);
			while(rs.next())
			{
				chargeStandard.setStandardname(rs.getString("fzmc"));
				chargeStandard.setStandardpoint(rs.getFloat("sfbz"));
				chargeStandard.setIsoperating(rs.getString("sfyy"));
				chargeStandard.setIsautomotive(rs.getString("sfjd"));
				chargeStandard.setLatefee(rs.getString("sfznj"));
				chargeStandard.setRevenueunit(rs.getString("jfdw"));
			}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			 dbconn.close();			
		return chargeStandard;
	}

/*	
public static boolean addChargeStandard(String fzmc,String sfbz,String sfyy,String sfjd,String sfznj,String jfdw)
{
	boolean flag=false;    
    String date=DateUtil.getDay(new Date());
    float standard=Float.parseFloat(sfbz.trim());
	DBConnect dbconn=new DBConnect();
	
	String sqlinsert = "INSERT INTO zfbz(fzdm,fzmc,sfbz,fbsj,sfyy,sfjd,sfznj,jfdw) VALUES( ";
	sqlinsert += " ' 1 ',";
	sqlinsert += " '" + fzmc + "' ,";
	sqlinsert += " " + standard + " ,";
	sqlinsert += "  '" + date + "' ,";
	sqlinsert += "  '" + sfyy + "' ,";
	sqlinsert += "  '" + sfjd + "' ,";
	sqlinsert += "  '" + sfznj + "' ,";
	sqlinsert += "  '" + jfdw + "' )";
	System.out.println(sqlinsert);
	try
	{
		flag = dbconn.executeInsert(sqlinsert);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			System.out.println(sqlinsert);
		}	
	return flag;
}

public boolean deleteChargeStandard(String fzdm)
	{ 	 
     String sql="delete zfbz where fzdm='"+fzdm+"'";
	 System.out.println(sql);
	 DBConnect dbconn2=new DBConnect();
	 boolean flag=false;
	 flag = dbconn2.executeDelete(sql);
	 //System.out.println(flag);
	 return flag;
	
	}
   */
public static int updateChargeStandard(String fzdm,String sfbz)
	{
	 float standard=Float.parseFloat(sfbz.trim());
	 String date=DateUtil.getDay(new Date());
     String sql="update zfbz set sfbz="+standard+",fbsj='"+ date +"' where fzdm='"+fzdm.trim()+"' ";
	 System.out.println(sql);
	 DBConnect dbconn = new DBConnect();
	 int flag=0;
	 try {
		flag = dbconn.executeUpdate(sql);
		
	 } catch (SQLException e) {
		// TODO 自动生成 catch 块
		e.printStackTrace();
	 }
	 //System.out.println(flag);
	 dbconn.close();
	 return flag;
	
	 }
public static void main(String[] args) {
	// TODO 自动生成方法存根
System.out.println("dd");
String fzdm="1";
String sfbz="1";
int flag;
flag=updateChargeStandard(fzdm,sfbz);
System.out.println(flag);
/*ChargeStandard standardinfo=new ChargeStandard();
standardinfo=getChargeStandard("10");
System.out.println(standardinfo.getStandardname());
System.out.println(standardinfo.getIsautomotive());
System.out.println(standardinfo.getIsoperating());
System.out.println(standardinfo.getRevenueunit());
System.out.println(standardinfo.getStandardpoint());*/
}

}