首頁猿問怎么解決？

怎么解決？

Java JavaScript SQL Server

葉子 2016-12-07 22:31:12

<%@ page language="java" contentType="text/html; charset=UTF-8"? ? pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Insert title here</title></head><body><% try{ String url ="jdbc:sqlserver://localhost:1433;DatabaseName=QiYe"; String username = "sa"; String password = "sa"; Connection conn =null; Statement statement = null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn =DriverManager.getConnection(url,username,password); statement sql = "select * from staff"; ResultSet rs =statement.executeQuery(sql);%> <table border="0" cellpadding="4" cellspacing="1" bgcolor="#CBD8AC" width="100%"> <tr align="center" bgcolor="#FAFA1"> <td>編號</td><td>姓名</td><td>性別</td><td>年齡<td></td>部門</td> </tr> <%while (rs.next()){ <tr> <td><%=rs.getString("Sno")%></td> <td><%=rs.getString("Sname")%></td> <td><%=rs.getString("Ssex")%></td> <td><%=rs.getString("sage")%></td> <td><%=rs.getString("sdepeterment")%></td> <td><a href="bookUpdate.jsp?id=<%=rs.getString("Sno") %>"></a><a href="bookSerblet?id=<%=rs.getString("Sno") %>"></a> </tr> <% } conn.close(); }catch(Exception e){ e.printStackTrace(); }%> </table> </body></html>報(bào)錯(cuò)：Multiple annotations found at this line: - Syntax error on tokens, Expression expected? insteadSyntax error, insert "super ( ) ;" to complete BlockStatements

查看完整描述

1 回答

慕粉3291149

TA貢獻(xiàn)71條經(jīng)驗(yàn) 獲得超52個(gè)贊

while循環(huán)那里 ? while循環(huán)本來就在<% ?%>之中你在其中使用<%= %>

還有你<tr><td>標(biāo)簽應(yīng)該放在<%%>之外

反對回復(fù) 2016-12-07

葉子
帥哥詳細(xì)點(diǎn)好嗎？拜托了

回復(fù) 2016-12-10
慕粉3291149
第一處錯(cuò)誤: statement sql = ""select * from ; 改為 String sql = "select * from staff"; 第二處錯(cuò)誤: statement沒有初始化,加上 statement = conn.createStatement(); 第三處錯(cuò)誤: while語句那塊改為: <% while(rs.next()){ %> <tr> <td><%=rs.getString("Sno")%></td> <td><%=rs.getString("Sname")%></td> <td><%=rs.getString("Ssex")%></td> <td><%=rs.getString("sage")%></td> <td><%=rs.getString("sdepeterment")%></td> <td><a href="bookUpdate.jsp?id=<%=rs.getString("Sno") %>"></a><a href="bookSerblet?id=<%=rs.getString("Sno") %>"></a> </tr> <% }%>

回復(fù) 2016-12-10