使用javabean出现的问题,please help me!!!
SqlBean的源代码:
package computer;
import java.sql.*;
public class SqlBean{
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:usedcomputer";
Connection conn=null;
ResultSet rs=null;
public SqlBean(){
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("SqlBean():"+e.getMessage());
}
}
public void executeInsert(String sql){
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("SqlBean.executeUpdate:"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("SqlBean.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeDelete(String sql){
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("SqlBean.executeDelete:"+ex.getMessage());
}
}
}
jsp源代码:
<%@ page language="Java" import="java.sql.*" %>
<jsp:uesBean id="mybean" scope="session" class="computer.SqlBean"/>
<%! String cpu,mainboard,other,note,sql;%>
<%
if(cpu!=""&&mainboard!=""&¬e!="")
{
cpu=request.getParameter("cpu");
mainboard=request.getParameter("mainboard");
other=request.getParameter("other");
note=request.getParameter("note");
sql="INSERT INTO inf (CPU,Mainboard,Other,Note)VALUES('"+cpu+"','"+mainboard+"','"+other+"','"+note+"')";
mybean.executeInsert(sql);
}else{
out.print("<b><font color=red>请输入必要信息</font></b>");
}
%>
<%
ResultSet RScount=mybean.executeQuery("SELECT * FROM inf");
int i=0;
while(RScount.next()){
i++;
}
%>
<p><a name=see><b>现在有<%=i %>条记录</b><a></p>
<%
RScount.close();
%>
<%
ResultSet RS=mybean.executeQuery("SELECT * FROM inf ORDER BY ID");
while(RS.next()){
cpu=RS.getString("CPU");
mainboard=RS.getString("Mainboard");
other=RS.getString("Other");
note=RS.getString("Note");
%>
出错信息:
F:\tomcat\work\localhost_8080%2Ftest\_0002fjsp_0002fjavabeans_0002flogin_0002ejsplogin_jsp_0.java:92: ?????????mybean
mybean.executeInsert(sql);
^
F:\tomcat\work\localhost_8080%2Ftest\_0002fjsp_0002fjavabeans_0002flogin_0002ejsplogin_jsp_0.java:102: ?????????mybean
ResultSet RScount=mybean.executeQuery("SELECT * FROM inf");
^
F:\tomcat\work\localhost_8080%2Ftest\_0002fjsp_0002fjavabeans_0002flogin_0002ejsplogin_jsp_0.java:126: ?????????mybean
ResultSet RS=mybean.executeQuery("SELECT * FROM inf ORDER BY ID");
^
请各位大侠指出出错的原因!谢谢指教