Topic: 初学JSP求教,JBulider2005提示错误!

  Print this page

1.初学JSP求教,JBulider2005提示错误! Copy to clipboard
Posted by: hsqujy
Posted on: 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!!!


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923