添加时间:[2009-9-19 8:32:38]
PreparedStatementprep=null;
ResultSetrset=null;
try{
Class.forName("<driver>").newInstance();
conn=DriverManager.getConnection("<database>");
Stringsql="SELECT*FROM<table>WHERE<columnname>=?";
prep=conn.prepareStatement(sql);
prep.setString(1,"<columnvalue>");
rset=prep.executeQuery();
if(rset.next()){
System.out.println(rset.getString("<columnname"));
}
}catch(SExceptione){
e.printStackTrace();
}finally{
rset.close();
prep.close();
conn.close();
}
}
Stringsql="SELECT*FROM<table>WHERE<columnname>=?";
try{
Mysqlmsql=newmysql(sql);
prep.setString(1,"<columnvalue>");
rset=prep.executeQuery();
if(rset.next()){
System.out.println(rset.getString("<columnname"));
}
}catch(SExceptione){
e.printStackTrace();
}finally{
mysql.close();
mysql=null;
}
}