前面是jsp的头文件一些html标签
19行 <%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String strConn = "jdbc:microsoft:sqlserver://localhost:1433;databaseName=mybase;user=sa;password=sasa;";
Connection Conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from remind";
ResultSet rs=stmt.executeQuery(sql);
%>
html标签
<%while(rs.next()) { %>
<tr>
148行 <td width="22%"><%= rs.getString(提醒日期) %></td>
<td width="32%"><%= rs.getString(提醒主题) %></td>
<td width="46%"><%= rs.getString(提醒内容) %></td>
</tr>
<% } %>
153行 <% rs.close();
stmt.close();
conn.close();
}
catch(ClassNotFoundException ex){
out.println(ex.getMessage());
}
catch(SQLException ex){
out.println(ex.getMessage());
}
%>
这个语句有什么问题啊
加了以后提示问题如下
An error occurred at line: 19 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
url cannot be resolved
An error occurred at line: 148 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
提醒日期 cannot be resolved
An error occurred at line: 153 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 153 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
Syntax error on token "Invalid Character", ; expected
19行 <%
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String strConn = "jdbc:microsoft:sqlserver://localhost:1433;databaseName=mybase;user=sa;password=sasa;";
Connection Conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from remind";
ResultSet rs=stmt.executeQuery(sql);
%>
html标签
<%while(rs.next()) { %>
<tr>
148行 <td width="22%"><%= rs.getString(提醒日期) %></td>
<td width="32%"><%= rs.getString(提醒主题) %></td>
<td width="46%"><%= rs.getString(提醒内容) %></td>
</tr>
<% } %>
153行 <% rs.close();
stmt.close();
conn.close();
}
catch(ClassNotFoundException ex){
out.println(ex.getMessage());
}
catch(SQLException ex){
out.println(ex.getMessage());
}
%>
这个语句有什么问题啊
加了以后提示问题如下
An error occurred at line: 19 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
url cannot be resolved
An error occurred at line: 148 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
提醒日期 cannot be resolved
An error occurred at line: 153 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 153 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
Syntax error on token "Invalid Character", ; expected
其他的类似
这个大意了
还有两处错误
An error occurred at line: 19 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
url cannot be resolvedAn error occurred at line: 19 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
user cannot be resolvedAn error occurred at line: 19 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
password cannot be resolvedAn error occurred at line: 19 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 153 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
conn cannot be resolvedAn error occurred at line: 153 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
Syntax error on token "Invalid Character", ; expectedAn error occurred at line: 153 in the jsp file: /bigwork/work/WebContent/sys.jsp
Generated servlet error:
Syntax error on token "Invalid Character", ; expected
而在Connection Conn= DriverManager.getConnection(url,user,password); 你用的是url
改为String url= "jdbc:microsoft:sqlserver://localhost:1433;databaseName=mybase;user=sa;password=sasa;";
Connection Conn= DriverManager.getConnection(url,user,password);
改为
Connection Conn= DriverManager.getConnection(strConn);
你是不是复制的啊,也不改改!哎
刚学习jsp
很多都不懂
其实这个我就知道是加载驱动
然后创建连接其他具体不是很懂啊