新手请教 用JavaBean连接orcal 10g数据库 的代码怎么写 ? 用的 myEclipse 最后后再麻烦讲解下 网上说的设置几个属性,生成一个无参的构造方法,生成get,set 方法 这个是什么意思 要怎么操作 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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> InputStream 可以读两次吗? myeclipse debug的时候有问题 润乾报表支持复杂的自定义报表吗? 本人一名大学生一心想成为程序员,我想成为一名专注软件开发的程序员希望能指点一二 ! hibernate 多对多修改的一个问题 大家开发hibernate用的eclipse是什么版本? structs中服务器+客户端验证,请会的大哥帮帮忙 关于异常的问题 请问JbuilderX,jboss-3.2.1_tomcat-4.1.24,jakarta-tomcat-5.0.19能否整合到一起 Login 的问题 求助ibatis引入报错 petstore2 没法下?
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>