各位大侠,看看我这代码哪里有错误,谢谢!(一个BEAN)
package NSPG;
import javax.naming.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
public class SWJG_JBXX_Bean extends ProcessData {
public SWJG_JBXX_Bean() {
}
public void execute(HttpServletRequest request, HttpServletResponse response, Status status) throws java.lang.Exception {
try
{
InitialContext ic = new InitialContext();
DataSource dataSource = (DataSource) ic.lookup("RegistrationJDBC");
Connection conn = dataSource.getConnection();
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery("select * from 表");
count =statement.executeQuery("select count(*) from 表");
out.println("<select name=list>");
for(i=1 i<count i++)
{
out.println("<option value="rs.getstring(字段)">"rs.getstring(字段名)"</option>");
}
out.println("</select>");
conn.close();
}
catch(Exception e)
}}