internationalcompanydao.java

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

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

package edu.whut.cwts.maintain.action;

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

import edu.whut.cwts.datasource.DBConnect;
/**
 * @author dwr
 *
 */
public class InternationalCompanyDAO {
	

public ArrayList getInternationalCompanyInfo(String cmch) throws SQLException{		
				
		String sql="select * from dzs1 where cmch='"+ cmch.trim() +"' ";			
		ArrayList companylist=new ArrayList();
		companylist.add("请选择......");
		 DBConnect dbconn=new DBConnect();		 			
		 ResultSet rs=dbconn.executeQuery(sql);
		System.out.println(sql);
		while (rs.next()){
			companylist.add(rs.getString("gsdm").trim()+"."+rs.getString("gsmc"));
		}
		dbconn.close();
		return companylist;		
	}
	
	public static boolean addInternationalCompany(String cmch,String gsdm)
	{
	boolean flag=false;
	DBConnect dbconn=new DBConnect();

	String sqlinsert = "INSERT INTO gjcbgsb(cmch,gsdm)";
	sqlinsert +="VALUES( ";
	sqlinsert += " '" + cmch.trim() + "' ,";
	sqlinsert += " '" + gsdm.trim() + "') "; 			
	System.out.println(sqlinsert);
	try
	{
		flag = dbconn.executeInsert(sqlinsert);
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
			System.out.println(sqlinsert);
		}	
		dbconn.close();
	return flag;
	}
	public int updateInternationalCompany(String cmch,String gsdm1,String gsdm2)
	{	 
	 String sql="update gjcbgsb set";
	 sql += " gsdm='"+gsdm2.trim()+"' ";
	 sql += "where cmch= '" + cmch.trim() + "' and gsdm = '" + gsdm1.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 boolean deleteInternationalCompany(String cmch)
	{
	 String sql="delete gjcbgsb where cmch='"+cmch.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 boolean deleteAgentCompany(String cmch,String gsdm)
	{
	 String sql="delete gjcbgsb where cmch='"+cmch.trim()+"' and gsdm='"+gsdm.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 static void main(String[] args) {
//	 TODO 自动生成方法存根
	System.out.println("dd11111111");
	String gsdm="1";
	String cmch="国际航线船舶测试";
	boolean flag;
	System.out.println("dd11");
	flag=addInternationalCompany(cmch,gsdm);
	System.out.println(flag);
	}

	}