两个javabean.一个是连接数据库:DBConnectionManager.java
package bookshop;
import java.sql.*;public class DBConnectionManager
{
private String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=bookshop";
private String user="admin";
private String password="123456";
public void setDriverName(String newDriverName){
this.driverName=newDriverName;
}
public String getDriverName(){
return driverName;
}
public void setUrl(String newUrl){
this.url=newUrl;
}
public String getUrl(){
return url;
}
public void setUser(String newUser){
this.user=newUser;
}
public String getUser(){
return user;
}
public void setPassword(String newPassword){
this.password=newPassword;
}
public String getPassword(){
return password;
}
public Connection getConnection(){
try
{
Class.forName(driverName);
return DriverManager.getConnection(url,user,password);
}
catch(Exception e){
e.printStackTrace();
return null;
}
}
}另一个是操作数据库:DBSQLManager.java
package bookshop;import java.sql.*;
import bookshop.*;public class DBSQLManager
{
protected Connection conn=null; //Connection对象
protected Statement stmt=null; //Statement 对象
protected ResultSet rs=null; //记录结果集
protected String sqlStr; //SQL语句
public DBSQLManager(){
try
{
sqlStr="";
DBConnectionManager dcm=new DBConnectionManager();
conn=dcm.getConnection();
stmt=conn.createStatement();
}
catch(Exception e){
System.out.println(e);
}
}
public Statement getStmt(){
return stmt;
}
public Connection getConn(){
return conn;
}
public ResultSet getRs(){
return rs;
}
public void setSqlStr(String newSqlStr){
this.sqlStr=newSqlStr;
}
public String getSqlStr(){
return sqlStr;
}
public void executeQuery() throws Exception{
rs=stmt.executeQuery(sqlStr);
}
public void executeUpdate() throws Exception{
stmt.executeUpdate(sqlStr);
}
public void close() throws SQLException{
if(stmt!=null){
stmt.close();
stmt=null;
}
conn.close();
conn=null;
}
}
两个编译都通过
主程序:index.jsp,没问题
booklist.jsp程序:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="incoming/common.jsp"%>
<%@ include file="incoming/check.jsp"%>
<jsp:useBean id="dbcm" class="bookshop.DBConnectionManager"/>
<jsp:useBean id="dbsm" class="bookshop.DBSQLManager"/><html>
<head>
<title>网上书店</title>
<link href="incoming/style.css" rel="stylesheet" type="text/css">
</head><body>
<%@ include file="incoming/header.jsp"%>
<br><a class="title">在线购物</a><br>
<%
dbcm.getConnection();
dbsm.DBSQLManager();
String sql="select * from bookinfo";
dbsm.setSqlStr(sql);
dbsm.executeQuery();
ResultSet rs=dbsm.getRs();
%><table width="700" boder="1" cellpadding="0" cellspacing="0">
<tr>
<td width="43%" height="26"><div align="center">书名</div><td>
<td width="17%"><div align="center">作者</div><td>
<td width="17%"><div align="center">出版社</div><td>
<td width="5%"><div align="center">价格</div><td>
<td width="9%"><div align="center">操作</div><td>
</tr>
<%while(rs.next()){%>
<tr>
<td height="32"><div align="center"><%=rs.getString("title")%></div></td>
<td><div align="center"><%=rs.getString("author")%></div></td>
<td><div align="center"><%=rs.getString("publisher")%></div></td>
<td><div align="center"><%=rs.getFloat("price")%></div></td>
<td><div align="center"><a href="bookdetail.jsp?isbn=<%=rs.getString("isbn")%>">
<img src="" width="45" height="16" border="0"></a></div></td>
</tr>
<%}%>
</table>
<p> </p>
<%@ include file="incoming/footer.jsp"%>
</body>
</html>问题:C:\tomcat\work\Standalone\localhost\bookshop\booklist_jsp.java:169: 找不到符号
符号： 方法 DBSQLManager()
位置： 类 bookshop.DBSQLManager
dbsm.DBSQLManager();
^
注意： C:\tomcat\work\Standalone\localhost\bookshop\booklist_jsp.java 使用或覆盖了已过时的 API。
注意： 要了解详细信息，请使用 -Xlint:deprecation 重新编译。
注意： C:\tomcat\work\Standalone\localhost\bookshop\booklist_jsp.java 使用了未经检查或不安全的操作。
注意： 要了解详细信息，请使用 -Xlint:unchecked 重新编译。我的意见;我已经设定了调用javabean为什么还会出现这种情况呢?类的位置我也没有放错.
盼高手回复
package bookshop;
import java.sql.*;public class DBConnectionManager
{
private String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=bookshop";
private String user="admin";
private String password="123456";
public void setDriverName(String newDriverName){
this.driverName=newDriverName;
}
public String getDriverName(){
return driverName;
}
public void setUrl(String newUrl){
this.url=newUrl;
}
public String getUrl(){
return url;
}
public void setUser(String newUser){
this.user=newUser;
}
public String getUser(){
return user;
}
public void setPassword(String newPassword){
this.password=newPassword;
}
public String getPassword(){
return password;
}
public Connection getConnection(){
try
{
Class.forName(driverName);
return DriverManager.getConnection(url,user,password);
}
catch(Exception e){
e.printStackTrace();
return null;
}
}
}另一个是操作数据库:DBSQLManager.java
package bookshop;import java.sql.*;
import bookshop.*;public class DBSQLManager
{
protected Connection conn=null; //Connection对象
protected Statement stmt=null; //Statement 对象
protected ResultSet rs=null; //记录结果集
protected String sqlStr; //SQL语句
public DBSQLManager(){
try
{
sqlStr="";
DBConnectionManager dcm=new DBConnectionManager();
conn=dcm.getConnection();
stmt=conn.createStatement();
}
catch(Exception e){
System.out.println(e);
}
}
public Statement getStmt(){
return stmt;
}
public Connection getConn(){
return conn;
}
public ResultSet getRs(){
return rs;
}
public void setSqlStr(String newSqlStr){
this.sqlStr=newSqlStr;
}
public String getSqlStr(){
return sqlStr;
}
public void executeQuery() throws Exception{
rs=stmt.executeQuery(sqlStr);
}
public void executeUpdate() throws Exception{
stmt.executeUpdate(sqlStr);
}
public void close() throws SQLException{
if(stmt!=null){
stmt.close();
stmt=null;
}
conn.close();
conn=null;
}
}
两个编译都通过
主程序:index.jsp,没问题
booklist.jsp程序:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ include file="incoming/common.jsp"%>
<%@ include file="incoming/check.jsp"%>
<jsp:useBean id="dbcm" class="bookshop.DBConnectionManager"/>
<jsp:useBean id="dbsm" class="bookshop.DBSQLManager"/><html>
<head>
<title>网上书店</title>
<link href="incoming/style.css" rel="stylesheet" type="text/css">
</head><body>
<%@ include file="incoming/header.jsp"%>
<br><a class="title">在线购物</a><br>
<%
dbcm.getConnection();
dbsm.DBSQLManager();
String sql="select * from bookinfo";
dbsm.setSqlStr(sql);
dbsm.executeQuery();
ResultSet rs=dbsm.getRs();
%><table width="700" boder="1" cellpadding="0" cellspacing="0">
<tr>
<td width="43%" height="26"><div align="center">书名</div><td>
<td width="17%"><div align="center">作者</div><td>
<td width="17%"><div align="center">出版社</div><td>
<td width="5%"><div align="center">价格</div><td>
<td width="9%"><div align="center">操作</div><td>
</tr>
<%while(rs.next()){%>
<tr>
<td height="32"><div align="center"><%=rs.getString("title")%></div></td>
<td><div align="center"><%=rs.getString("author")%></div></td>
<td><div align="center"><%=rs.getString("publisher")%></div></td>
<td><div align="center"><%=rs.getFloat("price")%></div></td>
<td><div align="center"><a href="bookdetail.jsp?isbn=<%=rs.getString("isbn")%>">
<img src="" width="45" height="16" border="0"></a></div></td>
</tr>
<%}%>
</table>
<p> </p>
<%@ include file="incoming/footer.jsp"%>
</body>
</html>问题:C:\tomcat\work\Standalone\localhost\bookshop\booklist_jsp.java:169: 找不到符号
符号： 方法 DBSQLManager()
位置： 类 bookshop.DBSQLManager
dbsm.DBSQLManager();
^
注意： C:\tomcat\work\Standalone\localhost\bookshop\booklist_jsp.java 使用或覆盖了已过时的 API。
注意： 要了解详细信息，请使用 -Xlint:deprecation 重新编译。
注意： C:\tomcat\work\Standalone\localhost\bookshop\booklist_jsp.java 使用了未经检查或不安全的操作。
注意： 要了解详细信息，请使用 -Xlint:unchecked 重新编译。我的意见;我已经设定了调用javabean为什么还会出现这种情况呢?类的位置我也没有放错.
盼高手回复
1,dbsm.DBSQLManager(); 是DBSQLManager构造函数,你不能那样调用2,在你<jsp:useBean id="dbsm" class="bookshop.DBSQLManager"/> 时,已经调用了
DBSQLManager(),所以不用在调用3,关于使用了未经检查或不安全的操作,分析你可能用了JDK5.0版本,在其中你又使用了被5.0默认为过期的类,造成,这个不算打问题注意看手册就行,4,我的QQ 号是 25436476 有事可以和我交流,互相学习