请教各位一个问题:本地的ORACLE数据库怎么和JSP相连 一般用thin jdbc,你把错误详细贴出来不过,你应该在JSP版面上提问 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你用这个BEAN测一下吧!/** * 功能:此类用于操作数据库 */import java.sql.*;import oracle.jdbc.driver.*;public class clsDB { //初始化变量 String sDBDriver = ""; String sConnStr = ""; String sHint = ""; String Username=""; String Pwd=""; ResultSet rs = null; Connection conn = null; Statement stmt = null; /*得到状态提示*/ public String getHint() { return sHint; } /*设置驱动连接串*/ public void setDBDriver(String s) { sDBDriver = "" + s; } /*获得驱动连接串*/ public String getDBDriver() { return sDBDriver; } /*获得连接字符串*/ public String getConnStr() { return sConnStr; } //初始化数据库 public boolean Initialiaztion(String dbDrive,String dbConn,String dbUser,String dbPwd) throws InstantiationException, IllegalAccessException { sDBDriver = dbDrive; sConnStr = dbConn; Username = dbUser; Pwd = dbPwd; return Initialiaztion(); } public boolean Initialiaztion() throws InstantiationException, IllegalAccessException { try { Class.forName(sDBDriver).newInstance(); sHint = "Initialization sucessfully!"; return true; } catch(ClassNotFoundException e){ sHint = "Initialization:"+e.getMessage()+"失败!"; return false; } } //运行SQL段代码获取记录集 public ResultSet ExecuteQuery(String sql) { rs = null; try{ DriverManager.registerDriver(new OracleDriver()); conn = DriverManager.getConnection(sConnStr,Username,Pwd); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch(SQLException ex) { sHint = "ExecuteQuery:" + ex.getMessage(); } return rs; } //运行不返回记录集的SQL代码 public boolean ExcuteUpdate(String sql) { try{ conn = DriverManager.getConnection(sConnStr); stmt = conn.createStatement(); stmt.executeUpdate(sql); return true; } catch(SQLException ex) { sHint = "ExecuteQuery:" + ex.getMessage(); return false; } } //关闭连接 public boolean closeConn() { try { if (rs!=null) rs.close(); if (stmt!=null) stmt.close(); if (conn!=null) conn.close(); return true; } catch(SQLException ex) { sHint = "ExecuteQuery:" + ex.getMessage(); return false; } }} <%@ page language="java" %><%@ page contentType="text/html;charset=GB2312"%><%@ page import="java.sql.*"%><%@ page import="clsDB"%><jsp:useBean id="commonDBBean" class="clsDB" scope="session"/><html><head><title>测试数据库操作</title></head><body bgcolor="#FFFFFF"><% if ((request.getParameter("DBDriver")==null)|| (request.getParameter("ConnStr")==null)|| (request.getParameter("SQLStr")==null)|| (request.getParameter("Username")==null)|| (request.getParameter("Pwd")==null)) {%> <form method=get> 输入数据库驱程:<input type="text" name="DBDriver" size="40" value="oracle.jdbc.driver.OracleDriver"><BR> 输入连接串:<input type="text" name="ConnStr" size="30" value="java:oracle:thin:@10.0.13.96:1521:ocrl"><BR> 用户名:<input type="text" name="Username" value="user1"> 密码:<input type="text" name="Pwd" value="ww"><BR> 测试的SQL串:<input type="text" name="SQLStr" size="30" value="SELECT a,b from test"><BR> <input type=submit value="提交"> </form> <% }else{ if(!commonDBBean.Initialiaztion(request.getParameter("DBDriver"), request.getParameter("ConnStr"), request.getParameter("Username"), request.getParameter("Pwd"))){ out.println(commonDBBean.getHint()+"<br>"); out.println(commonDBBean.getConnStr()+"不行呀!<br>"); }else{ ResultSet rs; rs = commonDBBean.ExecuteQuery(request.getParameter("SQLStr")); int j= rs.getMetaData().getColumnCount(); out.println(j+"columns!");%> <table border=1> <tr><% for(int i=1;i<=j;++i){%> <td><%=rs.getMetaData().getColumnName(i)%></td><% }%> </tr><% //Print record content while (rs.next()) { out.println("<tr>"); for(int i =1;i<=j;++i) { out.println("<td>"+rs.getString(i)+"</td>"); } out.println("</tr>"); }%> </table><% } } if(!commonDBBean.closeConn()){ out.println(commonDBBean.getHint()+"<br>"); }%></body></html> 新手求解oracle配置问题 电子文档存储管理表单设计 oracle中函数中可以使用group by 吗? 字符串中取数字,所取值分别update 一个困扰了很长时间的问题 調查:大家所處的環境oracle是裝在甚麼操作系統上的,windows,linux,還是unix? 触发器无效且未通过重新验证? 以SYSTEM用户连接数据库的时候出现如下错误如何解决? 急的想吐血自杀! Oracle 8.1.7 personal edition 为什么不能在WINDOWS 2000 PROFESSIONAL 上安装? 急! 通过触发器记录字段内容的前后修改情况,但是, oracle 问题
/**
* 功能:此类用于操作数据库
*/import java.sql.*;
import oracle.jdbc.driver.*;public class clsDB {
//初始化变量
String sDBDriver = "";
String sConnStr = "";
String sHint = "";
String Username="";
String Pwd="";
ResultSet rs = null;
Connection conn = null;
Statement stmt = null; /*得到状态提示*/
public String getHint()
{
return sHint;
} /*设置驱动连接串*/
public void setDBDriver(String s)
{
sDBDriver = "" + s;
} /*获得驱动连接串*/
public String getDBDriver()
{
return sDBDriver;
} /*获得连接字符串*/
public String getConnStr()
{
return sConnStr;
} //初始化数据库
public boolean Initialiaztion(String dbDrive,String dbConn,String dbUser,String dbPwd)
throws InstantiationException, IllegalAccessException
{
sDBDriver = dbDrive;
sConnStr = dbConn;
Username = dbUser;
Pwd = dbPwd;
return Initialiaztion(); }
public boolean Initialiaztion()
throws InstantiationException, IllegalAccessException
{
try
{
Class.forName(sDBDriver).newInstance();
sHint = "Initialization sucessfully!";
return true;
}
catch(ClassNotFoundException e){
sHint = "Initialization:"+e.getMessage()+"失败!";
return false;
}
} //运行SQL段代码获取记录集
public ResultSet ExecuteQuery(String sql)
{
rs = null;
try{
DriverManager.registerDriver(new OracleDriver());
conn = DriverManager.getConnection(sConnStr,Username,Pwd);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
sHint = "ExecuteQuery:" + ex.getMessage();
} return rs;
} //运行不返回记录集的SQL代码
public boolean ExcuteUpdate(String sql)
{
try{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
return true;
}
catch(SQLException ex)
{
sHint = "ExecuteQuery:" + ex.getMessage();
return false;
}
} //关闭连接
public boolean closeConn()
{
try
{
if (rs!=null) rs.close();
if (stmt!=null) stmt.close();
if (conn!=null) conn.close();
return true;
}
catch(SQLException ex)
{
sHint = "ExecuteQuery:" + ex.getMessage();
return false;
}
}}
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="clsDB"%>
<jsp:useBean id="commonDBBean" class="clsDB" scope="session"/>
<html>
<head>
<title>测试数据库操作</title>
</head>
<body bgcolor="#FFFFFF">
<%
if ((request.getParameter("DBDriver")==null)||
(request.getParameter("ConnStr")==null)||
(request.getParameter("SQLStr")==null)||
(request.getParameter("Username")==null)||
(request.getParameter("Pwd")==null))
{
%>
<form method=get>
输入数据库驱程:<input type="text" name="DBDriver" size="40" value="oracle.jdbc.driver.OracleDriver"><BR>
输入连接串:<input type="text" name="ConnStr" size="30" value="java:oracle:thin:@10.0.13.96:1521:ocrl"><BR>
用户名:<input type="text" name="Username" value="user1">
密码:<input type="text" name="Pwd" value="ww"><BR>
测试的SQL串:<input type="text" name="SQLStr" size="30" value="SELECT a,b from test"><BR>
<input type=submit value="提交">
</form>
<%
}else{
if(!commonDBBean.Initialiaztion(request.getParameter("DBDriver"),
request.getParameter("ConnStr"),
request.getParameter("Username"),
request.getParameter("Pwd"))){ out.println(commonDBBean.getHint()+"<br>");
out.println(commonDBBean.getConnStr()+"不行呀!<br>");
}else{
ResultSet rs;
rs = commonDBBean.ExecuteQuery(request.getParameter("SQLStr"));
int j= rs.getMetaData().getColumnCount();
out.println(j+"columns!");%>
<table border=1>
<tr>
<%
for(int i=1;i<=j;++i){
%>
<td><%=rs.getMetaData().getColumnName(i)%></td><%
}
%>
</tr>
<%
//Print record content
while (rs.next())
{
out.println("<tr>");
for(int i =1;i<=j;++i)
{
out.println("<td>"+rs.getString(i)+"</td>"); }
out.println("</tr>");
}
%>
</table>
<% }
} if(!commonDBBean.closeConn()){
out.println(commonDBBean.getHint()+"<br>");
}
%>
</body>
</html>