大家帮我看看数据库连接的小问题,谢谢
时间:2008-07-24 05:26:38
来源:论坛整理 作者: 编辑:chinaitzhe
import java.sql.*;
public class conn{
String DBDdriver="sun.jdbc.odbc.JdbcOdbcDriver";
String rsDBDdriver="jdbc:odbc:vote";
Connection con=null;
ResultSet rs=null;
public conn(){
try{
Class.forName(DBDdriver);
}catch(java.lang.ClassNotFoundException e){
System.err.println(e.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs=null;
try{
con=DriverManager.getConnection(rsDBDdriver);
Statement stmt=con.createStatement();
rs=stmt.executeQuery(sql);
}catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
}
下面是显示表格的jsp文件(show.jsp)
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="voteBean" class="vote.conn" scope="page"/>
<html>
<head>
<title>SQL SHOW! </title>
<meta http-equiv="Content-Type" content="text/http;charset=gb-2312-80">
<meta content="blueriver" name="Author">
<meta http-equiv="refresh" content="10;URl=show.jsp">
</head>
<body bgcolor="red">
<div align="center">
<h1>当前统计票数 </h1>
<table border="1" width="60%">
<tr>
<td width="51%">候选公司名 </td>
<td width="49%">当前票数 </td>
</tr>
<%
ResultSet rst=voteBean.executeQuery("select * from result");
String companyName;
int voteNum;
while(rst.next()){
companyName=rst.getString("candidate");
voteNum=rst.getInt("vote_num");
%>
<tr>
<td width="51%"> <%=companyName%> </td>
<td width="49%"> <%=voteNum%> </td>
</tr>
<%
}
rst.close();
%>
</table>
</div>
<div align="center">
<h1>投票人的具体资料 </h1>
<table border="1" width="100%">
<tr>
<td>投票的公司 </td>
<td>投票人姓名 </td>
<td>投票人所在公司 </td>
<td>投票人所在国家 </td>
<td>投票人的IP地址 </td>
<td>投票时间 </td>
</tr>
<%
ResultSet RS_vote;
RS_vote=voteBean.executeQuery("select * from voter");
String candidate1,name,company1,country,address;
java.util.Date time;
while(RS_vote.next()){
candidate1=RS_vote.getString("candidate");
name=RS_vote.getString("voter_name");
company1=RS_vote.getString("voter_company");
country=RS_vote.getString("voter_country");
address=RS_vote.getString("ip_address");
time=RS_vote.getStrig("voter_time");
%>
<tr>
<td> <%=candidate1%> </td>
<td> <%=name%> </td>
<td> <%=company1> </td>
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </td>
</tr>
<%
}
RS_vote.close();
%>
</table>
</div>
</body>
</html>
编译的时候出现的错误:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected instead
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", invalid Expression
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", delete this token
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected instead
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", invalid Expression
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", delete this token
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected instead
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", invalid Expression
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", delete this token
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", invalid Expression
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token " <", invalid Expression
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, delete these tokens
An error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token ";", delete this token
Generated servlet error:
Syntax error, insert "}" to complete Block
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)
网友回复:此回复为自动发出,仅用于显示而已，并无任何其他非凡作用
楼主【mailghyth】截止到2008-07-21 10:58:04的历史汇总数据(不包括此帖)：
发帖的总数量:39 发帖的总分数:1080 每贴平均分数:27
回帖的总数量:366 得分贴总数量:235 回帖的得分率:64%
结贴的总数量:35 结贴的总分数:1080
无满足结贴数:1 无满足结贴分:100
未结的帖子数:4 未结的总分数:0
结贴的百分比:89.74 % 结分的百分比:100.00%
无满足结贴率:2.86 % 无满足结分率:9.26 %
楼主加油网友回复:63行 <td> <%=company1> </td>
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </td>
修改
<td> <%=company1%> </td>
<td> <%=country%> </td>
<td> <%=address%> </td>
<td> <%=time%> </td>
这样修改以后在试试
网友回复: <td> <%=name%> </td>
<td> <%=company1> </td>
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </td>
网友回复: <td> <%=company1%> </td>
<td> <%=country%> </td>
<td> <%=address%> </td>
<td> <%=time%> </td>
另外,定义字符串是赋初值:
String company1=null,......;
网友回复: <tr>
<td> <%=candidate1%> </td>
<td> <%=name%> </td>
<td> <%=company1> </td>
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </td>
</tr>
网友回复: <td> <%=company1> </td>
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </td>
--->>>
<td> <%=company1%> </td>
<td> <%=country%> </td>
<td> <%=address%> </td>
<td> <%=time%> </td>
关键字：看看,数据库,连接,问题,谢谢,
上一篇：请大家推荐一本好的数据结构的书
下一篇：下面没有链接了
文章评论
共有 0 位网友发表了评论 此处只显示部分留言 点击查看完整评论页面