connoracle.java

还是超市系统

package db;

import java.sql.*;

public class   ConnOracle{
	
	String serverName = "eda24";
	String driver = "oracle.jdbc.driver.OracleDriver";
	String sConnstr = "jdbc:oracle:thin:@"+serverName+":1521:SMarket";
	Connection connect = null;
	ResultSet rs = null;
	
	public ConnOracle(){
		try{
			Class.forName(driver);
		}catch(java.lang.ClassNotFoundException e){
				e.printStackTrace();
			}
	}
	
	public ResultSet query(String sql){
		try{
			connect = DriverManager.getConnection(sConnstr,"scott","tiger");
			Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);
		}catch(SQLException e){
			e.printStackTrace();
		}
		return rs;
	}
	
	public void update(String sql){
		try{
			connect = DriverManager.getConnection(sConnstr,"scott","tiger");
			Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
		}catch(SQLException e){
			e.printStackTrace();	
		}
	}
}