projectmakerupdate.java

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

package com.BO;

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

public class projectMakerUpdate {

	dataBase db;

	public projectMakerUpdate() {
		db = new dataBase();
	}

	public ArrayList showMakerUpdate(String Maker_id) {
		ArrayList list = new ArrayList();
		String sql = "select* from maker where Maker_id='"+Maker_id+"'";
		ResultSet rs = db.sqlFind(sql);
		
		try {
			
			while (rs.next()) {
				
			//	String Maker_id = rs.getString("Maker_id");
				String userName=rs.getString("userName");
				String userPass=rs.getString("userPass");
				String Maker_name = rs.getString("Maker_name");
				String Maker_address = rs.getString("Maker_address");
				String Maker_Cr_time = rs.getString("Maker_Cr_time");
				String Maker_Cr_address = rs.getString("Maker_Cr_address");
				String Maker_Cr_cost = rs.getString("Maker_Cr_cost");
				String Maker_fr_name = rs.getString("Maker_fr_name");
				String Maker_fr_position = rs.getString("Maker_fr_position");
				String Maker_Attribute = rs.getString("Maker_Attribute");
                String Maker_phone=rs.getString("Maker_phone");
                String Maker_email=rs.getString("Maker_email");
				
				projectMakerVO vo = new projectMakerVO();
			//	vo.setMaker_id(Maker_id);
				vo.setUserName(userName);
				vo.setUserPass(userPass);
				vo.setMaker_name(Maker_name);
				vo.setMaker_address(Maker_address);
				vo.setMaker_Cr_time(Maker_Cr_time);
				vo.setMaker_Cr_address(Maker_Cr_address);
				vo.setMaker_Cr_cost(Maker_Cr_cost);
				vo.setMaker_fr_name(Maker_fr_name);
				vo.setMaker_fr_position(Maker_fr_position);
				vo.setMaker_Attribute(Maker_Attribute);
				vo.setMaker_phone(Maker_phone);
				vo.setMaker_email(Maker_email);

				list.add(vo);
			

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