projectupdate.java

来自「一个毕业设计网络招标系统实现了招标的业务逻辑内含了数据库sql server备份」· Java 代码 · 共 70 行

package com.BO;

import java.sql.ResultSet;
import java.util.ArrayList;
import com.CDB.*;
import com.VO.projectMakerVO;
import com.VO.projectVO;

public class projectUpdate {
	dataBase db;
	public projectUpdate(){
		db=new dataBase();
	}
	public ArrayList showUpdataProject(String project_id)
	{
		ArrayList list = new ArrayList();
		String sql = "select * from project where project_id='"+project_id+"'";
		ResultSet rs = db.sqlFind(sql);

		try {
			while (rs.next()) {
			//	String project_id = rs.getString(1);
				String project_name = rs.getString(2);
				String project_time=rs.getString(3);
				String project_company=rs.getString(4);
				String project_cost=rs.getString(5);
				String project_content=rs.getString(6);
				projectVO vo = new projectVO();
				
				//vo.setProject_id(project_id);
				vo.setProject_name(project_name);
				vo.setProject_time(project_time);
				vo.setProject_company(project_company);
				vo.setProject_cost(project_cost);
				vo.setProject_content(project_content);
				
				list.add(vo);
			
			}

		} catch (Exception e) {
			System.out.println("showUpdataProject Error!!" + e.getMessage());
		}
		return list;
	}
	public ArrayList checkVIPList() {
		ArrayList list = new ArrayList();
		String sql = "select * from project where project_check='"+1+"'";
		ResultSet rs = db.sqlFind(sql);
		try {
			while (rs.next()) {
			     String project_id=rs.getString(1);
				String project_name = rs.getString(2);
				
				projectVO vo = new projectVO();
			   vo.setProject_id(project_id);
				vo.setProject_name(project_name);
				

				list.add(vo);

			}
		} catch (Exception e) {
			System.out.println("checkVIPList Error!!" + e.getMessage());
		}
		return list;
	}
	
}