[Java教程]JDBC中prepareStatement 和Statement 的区别
0 2014-05-27 18:00:16
package util;
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 DButil {
public static void main(String[] args) throws SQLException {
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");//加载并注册驱动程序
}catch(ClassNotFoundException e)//加载错误,捕获异常
{
System.out.println("加载驱动失败");
}
Connection con =DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott","tiger"); //创建Connection连接对象
PreparedStatement sta=con.prepareStatement("select * from emp");
ResultSet rs=sta.executeQuery();
/* Statement sta = con.createStatement(); //创建语句对象
ResultSet rs=sta.executeQuery("select * from emp"); //4,执行语句对象,如果查询,要把查询结果 放到结果集当中 */
while(rs.next()){ //当没有到结尾的时候
System.out.print(rs.getInt("empno")+" ");//用Get方法获取字段的值
System.out.print(rs.getString("ename")+" ");
System.out.print(rs.getDouble("sal"));
System.out.println();
}
//5,关闭资源
rs.close();
sta.close();
con.close();
}
}
本文网址:http://www.shaoqun.com/a/92424.html
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:admin@shaoqun.com。
0