getparts.jsp

来自「一款采用java技术编写的OA办公软件系统」· JSP 代码 · 共 16 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<select name="parentpart" style="width:320px ">
<option  value="0"> ==  省   农  委  ==</option>
<%
	dbc.getConnection();
	String sql = "select partname,id from  parts";
	ResultSet  rs = dbc.getRS(sql);
	while(rs.next()){
		out.println("<option  value='"+rs.getString(2)+"'>"+charset.ISO_2_GBK(rs.getString(1))+"</option>");
	}
	rs = null;
	dbc.close();

%>
</select>