jsp问题!!!!

Question

这段代码老是报错
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page language="java" import="java.sql.*"%>
<%
String userName="root";
String passwd="root";
String hostName="222.177.14.217";
Connection conn=null;
dbName="spcems";
String url = "jdbc:mysql://" + hostName + ":3307/" + dbName+ "?user="+ userName +"&password=" + passwd;
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url);
if(conn==null){ 
system.out.println("get conn error"); 
} 

Statement sta = conn.createStatement();
resultset rs=null;
rs=sta.executequery("select * from alarm_list;");
while(rs.next()){
%>
<%=rs.getString("id")%> 
<% 
} 
rs.close(); 
sta.close(); 
conn.close(); 
%> org.apache.jasper.JasperException: 无法编译JSPAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
dbName cannot be resolvedAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
dbName cannot be resolvedAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
system.out cannot be resolved to a typeAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
resultset cannot be resolved to a typeAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
The method executequery(String) is undefined for the type Statement
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
起 因 org.apache.jasper.JasperException: 无法编译JSPAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
dbName cannot be resolvedAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
dbName cannot be resolvedAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
system.out cannot be resolved to a typeAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
resultset cannot be resolved to a typeAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
The method executequery(String) is undefined for the type Statement
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:414)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:297)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

Answer 1

你先把这里的都去了，看看报不报错<%....%>

Answer 2

去了以后这一行报错了<%=rs.getString("id")%>

Answer 3

首先我想问下，mysql端口号不是默认为3306么？
dbName="spcems";
String url = "jdbc:mysql://222.177.14.217:3306/spcems";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(url,"root","root");

Answer 4

jsp页面数据不用
system.out.println("get conn error"); 
用out.println("get conn error")

Answer 5

dbName cannot be resolvedAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
dbName cannot be resolved你要写String dbName=....An error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
system.out cannot be resolved to a type
System 不是systemAn error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
resultset cannot be resolved to a type
ResultSet resultset 变量要先声明再使用
An error occurred at line: 4 in the jsp file: /WebContent/aa.jsp
Generated servlet error:
The method executequery(String) is undefined for the type StatementexecuteQuery我靠，基本错误，lz你不看错误信息啊

Answer 6

很多。
我没看到ResultSet也写错了你！

Answer 7

rs=sta.executequery("select * from alarm_list;");rs=sta.executeQuery("select * from alarm_list;");太多了！楼主还是把代码写在java里，用jsp掉吧！

Answer 8

1.数据库名字没有定义
2.jsp页面输出用out.println();
3.ResultSet要先定义在使用