- 论坛徽章:
- 0
|
今天写了一个连接并访问数据库的javabean，运行时出现以下错误：The value for the useBean class attribute com.ContactBean is invalid.求教高手！
我的bean代码如下
package com;
import java.sql.*;
public class ContactBean
{
private Connection con;
//初始化连接。
public ContactBean()
{
String url="jdbc racle:thin 59.64.195.143:1521:kuliwa";
String uid="jspdev";
String pwd="jspdev";
try{
Class.forName("oracle.jdbc.driver.OracleDriver" .newInstance();
Connection con=DriverManager.getConnection(url,uid,pwd);
}
catch(exception e){
e.printStackTrace();
}
}
//在数据库中添加信息
public void addContact()throws Exception
{
try
{
PreparedStatement pstmt=con.prepareStatement("insert into Contact values(?,?,?,?,?,?)";
pstmt.setString(1,"hellking";
pstmt.setInt(2,136234234);
pstmt.setString(3,"010455554";
pstmt.setString(4,"lxh@some.com";
pstmt.setDate(5,new java.sql.Date(new java.util.Date().getTime()));
pstmt.setString(6,"other email:ddd@d.com";
pstmt.execute();
// con.close();
}
catch(Exception e)
{
e.printStackTrace();
throw e;
}
}
//查询数据库
public ResultSet getContact()
{
try
{
Statement stm=con.createStatement();
ResultSet result=stm.executeQuery("select * from contact ";
return result;
}
catch(Exception e)
{
}
return null;
}
}
jsp页面代码如下：
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*,com.jspdev.ch12.*"%>
<jsp:useBean id="contact" class="com.ContactBean" scope="page"/>
<html>
<body>
<center>
<html>
<body>
使用JavaBean来操作数据库：<hr>
<table border=1>
<tr><td>姓名</td><td>手机</td><td>电话</td><td>email</td><td>最后的联系时间</td><td>备注</td></tr>
<%
try
{
contact.addContact();
ResultSet rst=contact.getContact("kuliwa";
while(rst.next())
{
out.println("<tr>";
out.println("<td>"+rst.getString("name"+"</td>");
out.println("<td>"+rst.getInt("mobile")+"</td>");
out.println("<td>"+rst.getString("phone")+"</td>");
out.println("<td>"+rst.getString("mail")+"</td>");
out.println("<td>"+rst.getDate("lct")+"</td>");
out.println("<td>"+rst.getString("mem")+"</td>");
out.println("</tr>");
}
rst.close();
}
catch(Exception e)
{
}
%>
</table>
<center>
</body>
</html> |
|
免费注册
发表于 2006-04-20 16:51
