hsqujy
发贴: 4
|
于 2006-03-22 22:05
初学JSP求教,JBulider2005提示错误! addwork.jsp内容如下:
<html> <head> <title> addwork </title> </head> <body bgcolor="#ffffff"> <h1> 添加工作任务:</h1> <form method="post" action=""> <br> <br> <select name="dept" size="1"> <option value="" selected>--选择部门--</option> <% =DeptList.getDeptList() %> </select> </form> </body> </html>
DeptList内容如下:
package work;
import java.sql.*;
public class DeptList {
//获取HTML下拉框的部门列表代码 public static String getDeptList() { Connection conn = null; StringBuffer sBuf = new StringBuffer(); sBuf =null; try { conn = DBConnection.getConnection(); PreparedStatement pStat = conn.prepareStatement( "select distinct(dept) dept from sys_user"); ResultSet rs = pStat.executeQuery(); while (rs.next()) { sBuf.append("<option value='" + rs.getString("dept") + "'>" + "</option>\n"); } return sBuf.toString(); } catch (SQLException ex) { ex.printStackTrace(); return ""; } finally { try { if (conn != null) { conn.close(); conn = null; } } catch (SQLException ex1) { } } }
public static void main(String[] args) { System.out.println(""+getDeptList()); }
} 还有一个DBConnection.java连接数据库 现在在JBulider2005中测试有错误提示:"addwork.jsp": illegal start of expression
大家给讲讲吧,我刚刚学JSP!!!
|