您所在位置：主题：请问这个错误如何解决？？？
sunlights
[专家分：30] 发布于 2006-04-10 17:31:00
我用的是ＪＳＰ＋ＳＱＬ ＳＥＲＶＥＲ实现添家，删除功能时遇到如下问题：
tomcat提示executeQuery［Ｍicrosoft］[ODBC:SQL SERVER DRIVER][]SQL SERVER]第一行： ＂awd_info＂附近有语法错误，请问各位如何解决呢？？
顺便说下，我用了ＪＡＶＡＢＥＥＮ连接数据库，封在一个包中并调用以下是awd_info.jsp的代码：
<%@page language="java" import="java.sql.*,java.io.*,java.util.*" %>
<%@page contentType="text/html;charset=GBK"%>
<jsp:useBean id="DBall_bean" scope="page" class="DBall.DBall"/>
<jsp:useBean id="b2" scope="page" class="DBall.DBall"/>
<jsp:useBean id="b3" scope="page" class="DBall.DBall"/>
<html>
<head>
<title>生物工程</title>
<link rel="stylesheet" href="../css/mycss1.css">
<link rel="stylesheet" href="../css/mycss2.css">
<link rel="stylesheet" href="../css/mycss3.css">
<link rel="stylesheet" href="../css/mycss4.css">
<link rel="stylesheet" href="../css/mycss5.css">
<link rel="stylesheet" href="../css/mycss6.css">
</head>
<%
DBall_bean.Connect();
b2.Connect();
b3.Connect();
%>
<body>
<center>
<table border="1" bgcolor="#CCCCFF" bordercolordark="#FFFFFF" bordercolorlight="#6666FF">
<tr>
<td height="18">
<a href="N_awd_info.jsp"> 添加获奖信息 </a>
</td>
</tr>
</table>
<center>
<table width="840" border="0" bgcolor="#CCCCFF">
<tr>
<td height="18" width="110"><div align="center"><b></b></div></td>
<td height="18" width="110"><div align="center"><b>党员姓名</b></div></td>
<td height="18" width="110"><div align="center"><b>获奖名称</b></div></td>
<td height="18" width="110"><div align="center"><b>获奖日期</b></div></td>
<td height="18" width="110"><div align="center"><b>批准机关</b></div></td>
<td height="18" width="110"><div align="center"><b>先进事迹</b></div></td>
<td height="18" width="50"><div align="center"><b>操作</b></div></td>
</tr>
<%
String query="select * from awd_info ";
ResultSet rs=DBall_bean.executeQuery(query);
while(rs.next()){%>
<tr>
<div align="center"><%String mbid=rs.getString("mbid");%></div>
<div align="center"><%String awdid=rs.getString("awdid");%></div>
<div align="center"><%String awddt=rs.getString("awddt");%></div>
<div align="center"><%String auth=rs.getString("auth");%></div>
<div align="center"><%String awdnt=rs.getString("awdnt");%></div>
<%
ResultSet rs2=b2.executeQuery("select nm from member_info2 where mbid='" + mbid + "' ");
String nm="没有数据";
while(rs2.next())
{nm=rs2.getString("nm");
}
ResultSet rs3=b3.executeQuery("select * from awdtp_info where awdid='" + awdid + "' ");
String awdnm="没有数据";
while (rs3.next())
{awdnm=rs3.getString("awdnm");
}
%>
tomcat提示executeQuery［Ｍicrosoft］[ODBC:SQL SERVER DRIVER][]SQL SERVER]第一行： ＂awd_info＂附近有语法错误，请问各位如何解决呢？？
顺便说下，我用了ＪＡＶＡＢＥＥＮ连接数据库，封在一个包中并调用以下是awd_info.jsp的代码：
<%@page language="java" import="java.sql.*,java.io.*,java.util.*" %>
<%@page contentType="text/html;charset=GBK"%>
<jsp:useBean id="DBall_bean" scope="page" class="DBall.DBall"/>
<jsp:useBean id="b2" scope="page" class="DBall.DBall"/>
<jsp:useBean id="b3" scope="page" class="DBall.DBall"/>
<html>
<head>
<title>生物工程</title>
<link rel="stylesheet" href="../css/mycss1.css">
<link rel="stylesheet" href="../css/mycss2.css">
<link rel="stylesheet" href="../css/mycss3.css">
<link rel="stylesheet" href="../css/mycss4.css">
<link rel="stylesheet" href="../css/mycss5.css">
<link rel="stylesheet" href="../css/mycss6.css">
</head>
<%
DBall_bean.Connect();
b2.Connect();
b3.Connect();
%>
<body>
<center>
<table border="1" bgcolor="#CCCCFF" bordercolordark="#FFFFFF" bordercolorlight="#6666FF">
<tr>
<td height="18">
<a href="N_awd_info.jsp"> 添加获奖信息 </a>
</td>
</tr>
</table>
<center>
<table width="840" border="0" bgcolor="#CCCCFF">
<tr>
<td height="18" width="110"><div align="center"><b></b></div></td>
<td height="18" width="110"><div align="center"><b>党员姓名</b></div></td>
<td height="18" width="110"><div align="center"><b>获奖名称</b></div></td>
<td height="18" width="110"><div align="center"><b>获奖日期</b></div></td>
<td height="18" width="110"><div align="center"><b>批准机关</b></div></td>
<td height="18" width="110"><div align="center"><b>先进事迹</b></div></td>
<td height="18" width="50"><div align="center"><b>操作</b></div></td>
</tr>
<%
String query="select * from awd_info ";
ResultSet rs=DBall_bean.executeQuery(query);
while(rs.next()){%>
<tr>
<div align="center"><%String mbid=rs.getString("mbid");%></div>
<div align="center"><%String awdid=rs.getString("awdid");%></div>
<div align="center"><%String awddt=rs.getString("awddt");%></div>
<div align="center"><%String auth=rs.getString("auth");%></div>
<div align="center"><%String awdnt=rs.getString("awdnt");%></div>
<%
ResultSet rs2=b2.executeQuery("select nm from member_info2 where mbid='" + mbid + "' ");
String nm="没有数据";
while(rs2.next())
{nm=rs2.getString("nm");
}
ResultSet rs3=b3.executeQuery("select * from awdtp_info where awdid='" + awdid + "' ");
String awdnm="没有数据";
while (rs3.next())
{awdnm=rs3.getString("awdnm");
}
%>