我写的一个博客,这个页面是显示日志的标题等正文的<%@ 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>
<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>
解决方案 »
- java文件修改后,MyEclipse总不能自动更新,每次都要从新发布才能更新,有怎么好的办法
- 大量用户访问web速度太慢 struts+hibernate mysql数据库
- Spring 3.0 MVC 出现如下错误
- struts2 log4j的配置
- 问一个超级变态的Hibernate问题
- Create CMP 2.0 Entity Bean 创建实体bean中没有field
- 用JS如何限制上传文件格式
- 50分....求达人帮忙,写出服务器监听8080端口接收客户端信息过程!!!!!!!!!!!!!!!!!
- 请filippo1980(管药师★吾辈岂是池中物,一遇风云便化龙)和keke1(龙)进来领分!谢谢你们的帮助,请再谈谈你们对XML的前景的看法!
- 请教大家 看这种问题能否实现
- tomcat如何实现重新加载class
- Java EE中用POI将结果导出为Excel报表文件的实现
<%@ 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>
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 causejava.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"%> //将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);
%>
空了 ,ConnDb 里先测试好使了在使用吧