67,513
社区成员
发帖
与我相关
我的任务
分享
<%@ page language="java" import="java.util.*,java.sql.*,com.conn.db.*;" pageEncoding="gb2312"%>
<body>
<% String biaohao= request.getParameter("biaohao");
String sql="select * from vote where id = " + biaohao;
ConnDb con = new ConnDb();
ResultSet rs = con.query(sql);
%>
<center>
<table bgColor="#dffad6" width="50%" height="50%">
<%
%>
<tr>
<td><h1><%=rs.getString("voteTitle")%></h1></td>
</tr>
<tr>
<td><%=rs.getString("voteContent") %></td>
</tr>
</table>
</center>
</body>
<%@ page language="java" import="java.util.*,java.sql.*,com.conn.db.*;" pageEncoding="gb2312"%> //将import里的;号去掉。
<body>
<% //没有连接数据库。
Class.forName("com.mysql.jdbc.driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/database?user=root&password=password"); //自已改一下数据库名和用户名和密码。
String biaohao= request.getParameter("biaohao");
String sql="select * from vote where id = " + biaohao;
Statement st = con.createStatement();
ResultSet rs = st.query(sql);
%>
org.apache.jasper.JasperException: An exception occurred processing JSP page /vote.jsp at line 49
46: ConnDb con = new ConnDb();
47: ResultSet rs = con.query(sql);
48:
49: if(rs.next())
50: {
51: out.println("<center>");
52: out.println("<h1>");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.lang.NullPointerException
org.apache.jsp.vote_jsp._jspService(vote_jsp.java:110)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.
<%@ page language="java" import="java.util.*,java.sql.*,com.conn.db.*;" pageEncoding="gb2312"%> <body> <% String biaohao= request.getParameter("biaohao"); String sql="select * from vote where id = " + biaohao; ConnDb con = new ConnDb(); ResultSet rs = con.query(sql); %> <center> <table bgColor="#dffad6" width="50%" height="50%"> <% %> <tr> <td><h1><%=rs.getString("voteTitle")%></h1></td> </tr> <tr> <td><%=rs.getString("voteContent") %></td> </tr> </table> </center> </body>