Oracle连接测试

Oracle数据库连接测试：

PrepareStatement 与Statement的主要区别：
1:创建时的区别：
   Statement stm=con.createStatement();
   PreparedStatement pstm=con.prepareStatement (sql);
执行的时候:
    stm.execute(sql);
    pstm.execute(); 
2: pstm一旦绑定了SQL,此pstm就不能执行其他的Sql，即只能执行一条SQL命令。
  stm可以执行多条SQL命令。
3: 对于执行同构的sql（只有值不同，其他结构都相同）,用pstm的执行效率比较的高，对于异构的SQL语句，Statement的执行效率要高。
4：当需要外部变量的时候，pstm的执行效率更高.

 

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

public class OracleTest{

    public static void main(String args[]) throws IllegalAccessException
    {
         //ora92数据库的实例 
         String url = "jdbc:oracle:thin:@localhost:1521:ora92";
         String user = "scott";
         String password = "tiger";

         Connection conn = null;
         Statement  stm = null;
         ResultSet    rs   = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
             conn = DriverManager.getConnection(url, user, password);
             System.out.println("get connection success");
              stm = conn.createStatement();
           
                  rs = stm.executeQuery("select * from emp");
                 while(rs.next()){
                     System.out.println("Employee name:"+rs.getString(2));
                 }
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }finally{
            try {
                 rs.close();
                 stm.close();
                 conn.close();
                System.out.println("Database closed!");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
 }
}

 

 

上面用的是statement：

下面这个是用的preparedStatement：

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 OrcleTest {

	public static void main(String args[]) throws IllegalAccessException
	{
		 String url = "jdbc:oracle:thin:@localhost:1521:ora92";

	     String user = "scott";

	     String password = "tiger";

	     Connection conn = null;
	     PreparedStatement pstm = null;
	     ResultSet  rs = null;
		try {

            Class.forName("oracle.jdbc.driver.OracleDriver");
             conn = DriverManager.getConnection(url, user, password);
             System.out.println("get connection success");
             pstm = conn.prepareStatement("select ename from emp where empno = ?");
             
             	pstm.setInt(1, 7369);
             	rs = pstm.executeQuery();

             	while(rs.next()){
             		System.out.println("员工姓名："+rs.getString(1));
             	}
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }finally{
        	try {
        		pstm.close();
                       rs.close();
		        conn.close();
                      
	        	System.out.println("数据库关闭！");
			} catch (SQLException e) {
				e.printStackTrace();
			}
        }
	}
}

 

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html