以下是关于commonBeanl.java 用于连接SQL数据库的java类代码import java.sql.*;
public class commonBean
{
String url="jdbc:odbc:newDatabase";
Connection con;
ResultSet rs;
Statement stmt;
public boolean sort(String s)
{boolean cun=false;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"sa"," ");
stmt=con.createStatement();
rs=stmt.execueQuery(s);
if(rs.next()) cun=true;
stmt.close();
}
catch(Exception ex){
System.err.print("Exception:");
System.err.println(ex.getMessage());
}
return cun;
}
}出现的错误如下:Error: 500
Location: /examples/commonlogin.jsp
Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSP???sun.tools.javac.Main ????
D:\tomcat\webapps\examples\WEB-INF\classes\commonBean.java:15: ? interface java.sql.Statement ?????? execueQuery(java.lang.String)?
rs=stmt.execueQuery(s);
public class commonBean
{
String url="jdbc:odbc:newDatabase";
Connection con;
ResultSet rs;
Statement stmt;
public boolean sort(String s)
{boolean cun=false;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"sa"," ");
stmt=con.createStatement();
rs=stmt.execueQuery(s);
if(rs.next()) cun=true;
stmt.close();
}
catch(Exception ex){
System.err.print("Exception:");
System.err.println(ex.getMessage());
}
return cun;
}
}出现的错误如下:Error: 500
Location: /examples/commonlogin.jsp
Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSP???sun.tools.javac.Main ????
D:\tomcat\webapps\examples\WEB-INF\classes\commonBean.java:15: ? interface java.sql.Statement ?????? execueQuery(java.lang.String)?
rs=stmt.execueQuery(s);
解决方案 »
- java写多线程访问数据库
- 关于POI操作xlsx文件,获取字体颜色
- 如何调用主线程里的实例
- 显示未定义超隐式构造函数Transport(),必须显示调用另一个构造函数。方法main不能声明为静态和无法解析wh。大侠请赐教,偶是初学者。方法main不能声明为静态以及无法解析wh。偶是初学者,请大侠们赐教
- 请懂jdbcrowset的朋友指点一二,来者有分
- 根据路径判断该路径为文件还是目录,显示其内容;如果为目录继续判断,直到根目录为止
- 请问如何写一个时间唤醒程序???
- String对象的replaceAll怎么用:)
- 网站问题
- 为什么安装完JBuilder4.0后, ie 无法看见Applet生成的控件?
- 怎樣把String轉換為一個字一個字這樣子輸出呢?
- 请问如何转换图片格式阿?
s这个参数还没有传过来
请各位帮忙看看那个关于commonBean类出错问题还是没办法解决!!
谢谢!
<%@page contentType="text/html;gb2312" %>
<%@page import="java.util.*" %>
<%@page import="java.io.*"%>
<html>
<body bgcolor="#FFFFFF" text="#000000">
<jsp:useBean id="common" scope="page" class="commonBean"/>
<jsp:setProperty name="common" property="*" />
<%String name="sa",password=" ";%>
<%name=request.getParameter("commoncardnum");%>
<%password=request.getParameter("commonmima");%>
<%String subS="select * from account where cardnum='"+name+"' and cardpassword='"+password+"'";%>
<div align="center">
<%boolean x=false;%>
<%
x=common.sort(subS);
%>
<%if(x)
{
%>
<hr>
<p> </p>
<p><font face="华文行楷" size="7" color="#0000FF">祝贺您登录成功!</font> </p>
<p><br>
<br>
<a href="http://localhost:8080/examples/book/commonlogin.html"><font face="华文行楷" size="5" color="#FF00FF">
<font size="7">进入图书借阅系统</font></font></a> </p>
<br>
<br>
<font size="7" color="#0000FF"> </font>
<hr>
能有高手解释得更清楚一些么?
import java.sql.*;
public class commonBean
{
String url="jdbc:odbc:newDatabase";
Connection con;
ResultSet rs;
Statement stmt;
public boolean sort(String s)
{boolean cun=false;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,"","");
stmt=con.createStatement();
rs=stmt.executeQuery(s);
if(rs.next()) cun=true;
stmt.close();
}
catch(Exception ex){
System.err.print("Exception:");
System.err.println(ex.getMessage());
}
return cun;
}
}