connoracle3.java

来自「大型超市购物系统。该系统分为10大模块」· Java 代码 · 共 59 行

package db;

import java.sql.*;

public class ConnOracle3 {
	String serverName = "localhost";
	String sDBDriver = "oracle.jdbc.driver.OracleDriver";
	String sConnStr = "jdbc:oracle:thin:@"+serverName+":1521:XDF";
	Connection connect = null;
	ResultSet rs = null;

	public ConnOracle3() {
		try {
			Class.forName(sDBDriver); 
		}
		catch(java.lang.ClassNotFoundException e) {
			System.err.println( e.getMessage());
		}
	}
	
	public ResultSet executeQuery(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 ex) { 
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	
	public int executeUpdate(String sql) {
		int result = 0;
		try {
			connect = DriverManager.getConnection(sConnStr, "scott", "tiger"); 
			Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			result = stmt.executeUpdate(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return result;
	}
	
	public static void main(String[] args) throws Exception{
		ConnOracle3 co3 = new ConnOracle3();
		String sql="select * from student where rownum <= 5 ";//where r > 5 and r <=10 ";

		ResultSet rs = co3.executeQuery(sql);	
		while(rs.next()){
			System.out.print(rs.getString(1).trim() + "\t");	
			System.out.print(rs.getString(2).trim() + "\t");	
			System.out.print(rs.getString(3).trim() + "\t");	
			System.out.print(rs.getString(4).trim() + "\n");	
		}
	}
}