当前页面: 开发资料首页 → J2EE 专题 → 怎样通过javabean访问oracle的数据库,将取出的值输出到页面上?
怎样通过javabean访问oracle的数据库,将取出的值输出到页面上?
摘要: 怎样通过javabean访问oracle的数据库,将取出的值输出到页面上?
rt:
我写了两个文件:
1:db.java:
package examples;
import java.net.*;
import java.sql.*;
import java.io.*;
public class db {
static Connection conn;
Statement stmt;
ResultSet rs;
public static void getConnection(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:king","scott","tiger");
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
public void closeConnection(){
try{
if(conn!=null){
conn.close();
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
public boolean executeUpdate(String sql){
try{
getConnection();
if(conn!=null)
{
stmt=conn.createStatement();
stmt.execute(sql);
}
return true;
}
catch(Exception e){
System.out.println(e.getMessage());
return false;
}
}
public int getIntItem(String strSql,String strFld){
int x=0;
Statement st;
Connection con;
try
{
System.out.println("正在连接数据库。。。");
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:king","scott","tiger");
System.out.println("已连接到数据库。。。");
Statement stmt=con.createStatement();
String query="select deptno,dname,loc from dept ";
ResultSet rs=stmt.executeQuery(strSql);
while(rs.next()){
System.out.println(rs.getInt("deptno")+" | "+rs.getString("dname"));
x =rs.getInt(strFld);
}
stmt.close();
con.close();
System.out.println(x);
}
catch(Exception em){
System.out.println("出现的异常为 "+em);
}
return x;
}
public String getStringItem(String strSql,String strFld){
String x="";
Statement st;
Connection con;
try
{
System.out.println("正在连接数据库。。。");
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:king","scott","tiger");
System.out.println("已连接到数据库。。。");
Statement stmt=con.createStatement();
String query="select deptno,dname,loc from dept ";
ResultSet rs=stmt.executeQuery(strSql);
while(rs.next()){
System.out.println(rs.getInt("deptno")+" | "+rs.getString("dname"));
x =rs.getString(strFld);
}
stmt.close();
con.close();
System.out.println(x);
}
catch(Exception em){
System.out.println("出现的异常为 "+em);
}
return x;
}
}
Bean.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<head>
My JSP 'Bean.jsp' starting page