projecttypebo.java

一个毕业设计网络招标系统实现了招标的业务逻辑内含了数据库sql server备份文件

package com.BO;
import java.sql.ResultSet;
import java.util.ArrayList;

import com.CDB.dataBase;
import com.VO.projectTypeVO;
public class projectTypeBO {
	dataBase db;
	public projectTypeBO()
	{
		db=new dataBase();
	}
	public ArrayList showType()
	{
		ArrayList list=new ArrayList();
		String sql="select * from type";
		ResultSet rs=db.sqlFind(sql);
		
		try{
			while(rs.next())
			{
	        	String Type_id=rs.getString("Type_id");
	        	String Type_name =rs.getString("Type_name");
	        	projectTypeVO vo=new projectTypeVO();
	        	vo.setType_id(Type_id);
	        	vo.setType_name(Type_name);
	        	list.add(vo);
			}
		}catch(Exception e )
		{
			System.out.println("showType Error!!"+e.getMessage());
		}
		return list;
	}
	public boolean dealType(String Type_id)
	{
		String sql="delete type where Type_id='"+Type_id+"'";
		db.sqlUpdata(sql);
		return true;
	}
	public boolean addType(String Type_name,String Type_content)
	{
		String sql="insert type values('"+Type_name+"','"+Type_content+"')";
		try{
		sql = new String(sql.getBytes("ISO-8859-1"),"GB2312");
		db.sqlUpdata(sql);
		}catch(Exception e)
		{
			System.out.println("addType Error!!"+e.getMessage());
		}
		return true;
	}
	

}