oraclebean.java

还是超市系统

package oracle;

import java.sql.*;

public class OracleBean{
	
	String serverName = "eda24";
	String driver = "oracle.jdbc.driver.OracleDriver";
	String url = "jdbc:oracle:thin:@"+serverName+":1521:SMarket";
	Connection connect = null;
	ResultSet rs = null;

	public OracleBean(){
		try{
			Class.forName(driver);
		}catch(Exception e){
			e.printStackTrace();
		}
	}

	public ResultSet query(String sql){
	     
		 try{
			 connect = DriverManager.getConnection(url,"scott","tiger");
		     Statement stmt = connect.createStatement();
			 rs = stmt.executeQuery(sql);
		 }catch(Exception e){
			 e.printStackTrace();
		 }
		 return rs;
	}

	public int update(String sql){	
				int flag = 0;		
		try{
			connect = DriverManager.getConnection(url,"scott","tiger");
			Statement stmt = connect.createStatement();
			flag = stmt.executeUpdate(sql);
		}catch(Exception e){
			e.printStackTrace();
		}
		return flag;
		
	}

	
}