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