prepareStatement的简单示例及标准的与数据库连接示例

Connection conn = null;

PreparedStatement stmt = null;
ResultSet rs = null;

try{

String u = req.getParameter("userName");
String p = req.getParameter("passWord");

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","XXXXX","XXXX");

String sql = "select * from shunpingS where id=? and passWord=?";

/*这句话要放在set属性之前*/
stmt = conn.prepareStatement(sql);

if(u!=null){
int x = Integer.parseInt(u);
stmt.setInt(1,x);
stmt.setString(2,p);
}else{
System.out.println("...");
}

rs = stmt.executeQuery();

if(rs.next()){

……

}else{

……

}

}catch(Exception e){

e.printStackTracke();

}finally{

try{

if(rs!=null)

{

rs.close();

rs = null;

}

if(stmt!=null)

{

stmt.close();

stmt = null;

}

if(conn!=null)
{
conn.close();

conn = null;
}

}catch(Exception e){

e.printStackTrace();

}

}