package com.xx.work.data;
 
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
 
import com.aheadsoft.work.dao.DBConnect;
 
public class Add {
	private int ID;
	private String workType;
	public int getID() {
		return ID;
	}
	public void setID(int id) {
		ID = id;
	}
	public String getWorkType() {
		return workType;
	}
	public void setWorkType(String workType) {
		this.workType = workType;
	}
	public Add(){
		ID = 0;
		workType = "";
	}
	public Add(int ID, String workType){
		this.ID = ID;
		this.workType = workType;
	}
	public void setID(String newID) {
		if (newID != null)
			this.ID = Integer.parseInt(newID);
	}
	public static Vector  excute() throws Exception{
		Vector list = new Vector();
		String Str = "select * from workType";
		DBConnect dbc = null;
		ResultSet rs = null;
		try {
			dbc = new DBConnect();
			try{
				rs = dbc.executeQuery(Str);
				while (rs.next()) {
					Add add = new Add();
					add.setWorkType(rs.getString("workType"));
					list.add(add);
				}
			}catch(SQLException e){
				e.printStackTrace();
			}finally{
				if(rs != null)
					rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			if(dbc !=  null)
				dbc.close();
		}
		return list;
	}
	public static void main(String [] args){
	}
}

<%@ page import="com.aheadsoft.work.data.Add"%>
//其它略
<select name="workType" style="width: 160; height: 23">
	<option selected value="">
		选择工作类型
	</option>
	<%
		Vector work = Add.excute();
                for(int i=0;i<work.size();i++){
                    Add add = (Add)work.get(i);
	 %>
<option><%=add.getWorkType()%></option>
<%}%>
</select>