1、jsp页面中
现根据oracle数据库版本号,在项目的lib下导入oracle连接驱动包
<%
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin://localhost:1521:orac", "sss", "ttt");
PreparedStatement sta=con.prepareStatement("select * from text where bh=?");
sta.setString(1, "001");
ResultSet res=sta.executeQuery();
if(res.next()){
String bh=res.getString("bh");
String xm=res.getString("xm");
}
%>
2、类中
现根据oracle数据库版本号,在项目的lib下导入oracle连接驱动包
try{
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin://localhost:1521:orac", "sss", "ttt");
//下面声明方式可以防止sql注入,比较安全
PreparedStatement sta=con.prepareStatement("insert into test(bh.xm,dh) values(?,?,?)");
sta.setString(1, "001");
sta.setString(2, "张安");
sta.setString(3, "13500000");
sta.executeUpdate()
}catch(Exception e){
}