java第4次作业

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();
}

上一篇:[转贴].NET3.5新特性,Lambda表达式


下一篇:集成腾讯云、短信宝短信发送的工具类