oracletest.java

改源码用来对Oracle性能进行测试

package Test;
import java.sql.*;

public class OracleTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		try
		{
			OracleTest oracle=new OracleTest();
			long start=System.currentTimeMillis();
			Connection con=oracle.connect();
			long end=System.currentTimeMillis();
			System.out.println("创建Oracle连接时间为"+(end-start)+"毫秒");
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery("select * from emp");
			System.out.println("Oracle数据库EMP表相关信息如下：");
			while(rs.next())
			{
				System.out.println(rs.getString(1)+"||"+rs.getString(2)+"||"+rs.getString(3)+"||"+rs.getString(4)+"||"+rs.getString(5)+"||"+rs.getString(6));
			}
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}
	public Connection connect()
	{
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MYDATA","scott","tiger");
			System.out.println("Oracle数据库已经连接...");
			return con;
		}
		catch(Exception ex)
		{
			ex.printStackTrace();
			return null;
		}
	}
}