oraclebean.java

来自「还是那个超市系统都是组员的成品」· Java 代码 · 共 72 行

/**
*@author EvilSun
*@version 0.1  2006-07-27
*
*/


package javabean;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class OracleBean {
	String url = "jdbc:oracle:thin:@eda21:1521:EvilSun";
	String driver = "oracle.jdbc.driver.OracleDriver";
    Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	
public OracleBean(){
		
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@eda21:1521:EvilSun","scott","tiger");
		}catch(Exception e){
			e.printStackTrace();
		}
					
	}
	
	
	public ResultSet query(String sql){
		try{
			conn = DriverManager.getConnection(url,"scott","tiger");
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		return rs;
	}
	public Connection getConn(){
		  return conn;
	}
	public void update(String sql){
		try{
			conn = DriverManager.getConnection(url,"scott","tiger");
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	
	
	public void close(){
	  try{
	  	conn.close();
	  }catch(Exception e){
	  	e.printStackTrace();
	  }	
	}
	
	
	
	
}