javabean连接mysql问题,急
bozy 2004-08-05 11:26:17 classes/jn/ 下jdbc.class的原代码:
----------------------------------------------
package jn;
import java.sql.*;
public class jdbc {
public jdbc() {
}
Connection conn = null ;
String re = "" ;
//设置你的数据库ip
String dbip = "127.0.0.1" ;
//设置你的数据库用户名和密码:
String use = "root" ;
String pass = "" ;
public java.sql.Connection getConn(){
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://"+dbip+":3306/"+use+"?user="+use+"&password="+pass+"&useUnicode=true&characterEncoding=gb2312" ;
conn= DriverManager.getConnection(url);
}
catch(Exception e){
e.printStackTrace();
}
return this.conn ;
}
}
-------------------------------
根目录下 index.jsp(调用数据库部分)
---------------------------------------------------
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="jn.jdbc" %>
<jsp:useBean id="jdbc" scope="page" class="jn.jdbc" />
<%
Connection con = getConn() ;
Statement stmt = con.createStatement() ;
String sql = "select * from notes order by id desc" ;
ResultSet rs = stmt.executeQuery(sql) ;
%>
----------------------------------------------------
错误提示(还有其他错误的)
----------------------------
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 15 in the jsp file: /index.jsp
Generated servlet error:
D:\tomcat5\work\Catalina\localhost\bozy\org\apache\jsp\index_jsp.java:69: cannot resolve symbol
symbol : method getConn ()
location: class org.apache.jsp.index_jsp
Connection con = getConn() ;
----------------------------
不用javabean,同样的设置,连接成功。
请问大侠,是什么问题,该怎么解决???
[偶刚从asp/php转做jsp]