请教各位一个问题:本地的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安装字符集编码请教 水晶报表调用oracle存储过程 访ORACLE92 US7ASCII字符集出现杂码 操作oracle出现maximum open cursors exceeded 请问能否在pl\sql中执行exp备份命令? order by查询时遇到问题 用过oracle xe的进来帮个忙 关于触发器中获取时间类型字段的值的问题. 这个MSsql存储过程.怎样改写成Oracle存储过程啊. 通过触发器记录字段内容的前后修改情况,但是, 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>