下面是个连接数据库的小程序,用SQL2000建立数据库Vote,然后建两个表voter和result.下面的javaBean文件名(conn.java)package vote;
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 reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected insteadAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected insteadAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected insteadAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, delete these tokensAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token ";", delete this tokenGenerated 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)
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 reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected insteadAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected insteadAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, Expression expected insteadAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", delete this tokenAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token "<", invalid ExpressionAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on tokens, delete these tokensAn error occurred at line: 63 in the jsp file: /show.jsp
Generated servlet error:
Syntax error on token ";", delete this tokenGenerated 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 %
楼主加油
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </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>
<td> <%=country%> </td>
<td> <%=address%> </td>
<td> <%=time%> </td>
另外,定义字符串是赋初值:
String company1=null,......;
<td> <%=candidate1%> </td>
<td> <%=name%> </td>
<td> <%=company1> </td>
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </td>
</tr>
<td> <%=country> </td>
<td> <%=address> </td>
<td> <%=time> </td> --->>>
<td> <%=company1%> </td>
<td> <%=country%> </td>
<td> <%=address%> </td>
<td> <%=time%> </td>