新手jsp代码疑问大家来找茬请高手指教

2009-03-18 11:58:40 241 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

JSP_运维_JSP项目部署到服务器(适合0经验新手) 实战：真正服务器端部署jsp项目经验总结与记录（完整过程从0到10适合对服务器端部署0经验新手） jsp+tomcat+mysql项目部署到真正服务器; 服务器mysq安装; 服务器jdk安装; 服务器tomcat安装; 服务器sql文件管理; 服务器jsp项目与服务器mysql连接;第一步是安装jdk，jdk应该是所有需要安装的软件中最先安装的。jdk具体如何安装可以参考这篇我截取了可以参考的阅读详情

public List find(int i){
List list = new ArrayList();
Ticket t = null;
Connection conn = super.getConn();
PreparedStatement psmt = null;
ResultSet rs= null;

String sql = "select top ? * from dbo.Ticket ";

try {
psmt=conn.prepareStatement(sql);
psmt.setInt(1, 5);
rs = psmt.executeQuery();
while(rs.next()){
String num = rs.getString(1);
boolean flag = rs.getBoolean(2);
t = new Ticket(num,flag);
list.add(t);
System.out.println("查询完成");
}
} catch (Exception e) {
System.out.println("查询失败");
e.printStackTrace();
}finally{
super.close(conn, psmt, rs);
System.out.println("关闭完成");
}

return list;
}

使用该方法后报错谢谢高手指教
com.microsoft.sqlserver.jdbc.SQLServerException: '@P0' 附近有语法错误。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)关闭完成
-------------------

at dao.ticketDao.Scriptlet(ticketDao.java:54)
at dao.test.main(test.java:12)

...全文