feepointdao.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 edu.whut.cwts.datasource.DBConnect;
/**
 * @author dwr
 *
 */
public class FeePointDAO {

	/**
	 * @param args
	 */
	public static int getFeePoint(String jflx)
	{		
		int point=0;
		DBConnect dbconn=new DBConnect();		
		String sql = "select jfxs from tjjfxs ";
		sql += "WHERE ";
		sql += "jflx = '" + jflx.trim() + "' ";			
		
		try
		{
			ResultSet rs = dbconn.executeQuery(sql);
			while(rs.next())
			{
				point=rs.getInt("jfxs");
			}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			 dbconn.close();			
		return point;
	}


public static int updateFeePoint(String jflx,String jfxs)
	{
	 int point=Integer.parseInt(jfxs.trim());
	 String sql="update tjjfxs set jfxs="+point+" where jflx='"+jflx.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 yhdm="1156";
String yhxm="1256";
int flag;
flag=updateFeePoint(yhdm,yhxm);
System.out.println(flag);
}

}