高分求在weblogic61中能运行的SERVLET通过JDBC连ORACEL8的例子,希望有SELECT,UPDATE,DELETE功能

luobutou 2002-04-27 03:10:04

...全文

22 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

luobutou 2002-04-27

打赏
举报

JB是指JBUILDER吗?

worldheart 2002-04-27

打赏
举报

在JB的目录下有这方面的例子！
estore

broze 2002-04-27

打赏
举报

会用控制台吗？(http://127.0.0.1:7001/console)
然后看一下，把JDBC Connection Pool和JDBC Tx Data Source都建起来了.
我的JDBC Connection Pool是这样建的，你可以参考一下。
Name: oraclePool
URL: jdbc:oracle:thin:@192.168.0.39:1521:dbname
Driver Classname: oracle.jdbc.driver.OracleDriver
Properties(key=value): user=yourUser
server=192.168.0.39:1521:db
我的JDBC Tx Data Source是这样建的，你可以参考一下。
Name: oraTxDataSource
JNDI Name: weblogic.jdbc.jts.oraclePool
Pool Name: oraclePool

下面是Servlet的程序

package jdbc;
import java.sql.*;
import java.util.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class simplesql extends HttpServlet {

public void service(HttpServletRequest req, HttpServletResponse res)
throws IOException
{
res.setContentType("text/html");
PrintWriter out = res.getWriter();
out.println("<html><head><title>Hello datasource!</title></head><body>");
out.println("<img src=images/BEA_Button_Final_web.gif align=right>");
out.println("<H1>simplesql.java</h1> Attempting connection....");
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
try {

// ============== Make connection to database ==================
// Obtain a Datasource connection from the WebLogic JNDI tree.

// Get a context for the JNDI look up
Context ctx = new InitialContext();

// Look up myDataSource
javax.sql.DataSource ds
= (javax.sql.DataSource) ctx.lookup ("weblogic.jdbc.jts.oraclePool");
//Create a connection object
conn = ds.getConnection();

out.println("Connection successful...Executing SQL...");

// execute some SQL statements to demonstrate the connection.
stmt = conn.createStatement();

stmt.execute("select * from notebook");

ResultSet rs = stmt.getResultSet();
out.println("<hr>Querying data ... ");

while (rs.next())
{
out.println(" TITLE: " + rs.getString("title") +
" CONTENT: " + rs.getString("content") + "<hr>");
}

//读取表的信息
ResultSetMetaData rsmd = rs.getMetaData();
out.println("Querying table meta data...");
out.println("Number of Columns: " + rsmd.getColumnCount() + "");
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
out.println("Column Name: " + rsmd.getColumnName(i));
out.println(" Nullable: " + rsmd.isNullable(i));
out.println(" Precision: " + rsmd.getPrecision(i));
out.println(" Scale: " + rsmd.getScale(i));
out.println(" Size: " + rsmd.getColumnDisplaySize(i));
out.println(" Column Type: " + rsmd.getColumnType(i));
out.println(" Column Type Name: " + rsmd.getColumnTypeName(i));
out.println(" <hr>");
}
}
catch (Exception e)
{
out.println("Connection error:" + e);
}
finally
{
try
{
if (stmt != null) stmt.close();
if (conn != null) conn.close();
}
catch (SQLException sqle)
{
out.println("Exception during close()" + sqle.getMessage());
}
}
out.println("<h3>Example finished...</h3></body></html>");
}
}

luobutou 2002-04-27