|
public static void main(String[] args) throws SQLException {
? ? getconn();
? ? String selectsql="select * from info";
（所有查询代码为：
select * from info where tel like '?%';
select * from info where sex=?;
select * from info where tel like '?%';
select * from info where sex=?;
）
? ? Object[] obj = {};
? ?select(selectsql,obj);
? ? demonext();
? ? democlose();
}
?
private static void democlose() throws SQLException {
? ? resultSet.close();
? ? pstat.close();
? ? conn.close();
}
private static void demonext() throws SQLException {
? ? while (resultSet.next()){
? ? ? ? System.out.println("id="+resultSet.getString("id")
? ? ? ? ? ? ? ? +" name="+resultSet.getString("name")
? ? ? ? ? ? ? ? +" tel="+resultSet.getString("tel")
? ? ? ? ? ? ? ? +" sex="+resultSet.getString("sex"));
? ? }
}
private static void select(String selectsql,Object[] obj) throws SQLException {
? ? pstat = conn.prepareCall(selectsql);
? ?for (int i = 0; i < obj.length; i++) {
? ? ? ? pstat.setObject(i+1,obj[i]);
? ?}
? ? resultSet =pstat.executeQuery();
}
?
?
|