goodsdao.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;
import edu.whut.cwts.maintain.bean.Goods;
/**
 * @author dwr
 *
 */
public class GoodsDAO {
	
	public String checkGoodsName(String hwmc)
    {
	    String count="";
	    String sql ="select count(*) from hwxxb where hwmc='"+hwmc.trim()+"'";
	    System.out.println(sql);
	    DBConnect dbconn=new DBConnect();
	    try
	    {
		 ResultSet rs = dbconn.executeQuery(sql);
		 if(rs.next())
		 count=String.valueOf(rs.getInt(1));
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		 dbconn.close();			
	return count;
   }
	
	public static Goods getGoods(String hwmc)
	{
		Goods goods=new Goods();
		DBConnect dbconn=new DBConnect();		
		String sql = "select * from hwxxb ";
		sql += "WHERE ";
		sql += "hwmc = '" + hwmc.trim()+ "' ";			
		
		try
		{
			ResultSet rs = dbconn.executeQuery(sql);
			while(rs.next())
			{
				goods.setGoodsID(rs.getString("hwdm"));
				goods.setGoodsname(rs.getString("hwmc"));
				goods.setGoodslevel(rs.getString("hwjb"));
			}
			} catch (SQLException e) {
				// TODO 自动生成 catch 块
				e.printStackTrace();
			}
			 dbconn.close();			
		return goods;
	}

	
public static boolean addGoods(String hwmc,String hwjb,String jfdw)
{
	boolean flag=false;
	DBConnect dbconn=new DBConnect();
	
	String sqlinsert = "INSERT INTO hwxxb(hwdm,hwmc,hwjb,jfdw) VALUES( ";
	sqlinsert += "' 1' ,";
	sqlinsert += " '" + hwmc.trim() + "' ,";	
	sqlinsert += " '" + hwjb.trim() + "' , "; 			
	sqlinsert += " '" + jfdw.trim() + "') "; 
	try
	{
		flag = dbconn.executeInsert(sqlinsert);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			System.out.println(sqlinsert);
		}	
		 dbconn.close();
	return flag;
}

public boolean deleteGoods(String hwdm)
	{
	 String sql="delete hwxxb where hwdm='"+hwdm.trim()+"'";
	 System.out.println(sql);
	 DBConnect dbconn2=new DBConnect();
	 boolean flag=false;
	 flag = dbconn2.executeDelete(sql);
	 //System.out.println(flag);
	 dbconn2.close();
	 return flag;
	
	}
   
public int updateGoods(String hwdm,String hwmc,String hwjb)
	{
	 String sql="update hwxxb set hwmc='"+hwmc.trim()+"',hwjb='"+hwjb.trim()+"' where hwdm='"+hwdm.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 hwmc="1156";
String hwjb="1";
String jfdw="1";
boolean flag;
flag=addGoods(hwmc,hwjb,jfdw);
System.out.println(flag);
}

}