新手请教 用JavaBean连接orcal 10g数据库 的代码怎么写 ?
用的 myEclipse 最后后再麻烦讲解下 网上说的设置几个属性,生成一个无参的构造方法,生成get,set 方法 这个是什么意思 要怎么操作 --------------------编程问答-------------------- DBConn.class的代码如下:import java.sql.Connection;
import java.sql.DriverManager;
public class DBConn {
Connection dbConn;
String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
String dbUser = "system";
String dbPwd = "tiger";
String err;
public DBConn() {
err = "";
dbConn = null;
}
// 连接数据库,返回一个 Connection类型对象
public Connection getConn() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
dbConn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
} catch (Exception ex) {
dbConn = null;
err = ex.toString();
System.out.println(err);
}
return dbConn;
}
// 获得错误信息
public String getErr() {
return err;
}
}
index.jsp的代码如下:
<%@ page language="java" import="java.sql.*" pageEncoding="GB2312"%>
<%@page import="jqqdcom.DBConn"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<jsp:useBean id="DBConn" class="jqqdcom.DBConn" scope="page" />
<%!
//定义数据库连接对象dbCon
Connection dbCon;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<h1 align="center">JDBC连接数据库实例</h1>
<%
//获取数据库连接对象
dbCon = DBConn.getConn();
if(dbCon!=null)
{
out.println("<p align=\"center\"><font color=blue>数据库连接成功</font></p>");
}
else
{
out.println("<p align=\"center\"><font color=red>数据库连接失败</font></p>");
out.println(DBConn.getErr());
}
%>
</body>
</html>
补充:Java , Java EE