閺€鎯版 (0) +1 鐠э拷 (0) +1 闊拷 (0) +1
閺€鎯版閹存劕濮�閺屻儳婀呴弨鎯版>>

正在阅读:使用JDBC创建数据库访问程序使用JDBC创建数据库访问程序

2004-02-14 09:34 出处:PConline 作者:曾青松 责任编辑:linjixiong


            results = stmt.executeQuery("select * from  客户;");
            ResultSetMetaData resultMetaData = results.getMetaData();
            int cols = resultMetaData.getColumnCount();
            String resultRow = "";
            for (int i = 1; i < cols; i++) {
                resultRow += resultMetaData.getColumnName(i) + ";";
            }
            System.out.println(resultRow);
            while (results.next()) {
                resultRow = "";
                for (int i = 1; i < cols; i++) {
                    try {
                        resultRow += results.getString(i) + ";";
                    } catch (NullPointerException e) {
                        System.out.println(e.getMessage());
                    }
                }
                System.out.println(resultRow);
            }
        } catch (Exception e) {
            System.out.println("query exception");
        } finally {
            results.close();
        }
    }
  }

 

察看评论详细内容 我要发表评论
作者笔名简短内容 发表时间
:
键盘也能翻页,试试“← →”键

相关文章

关注我们

最新资讯离线随时看 聊天吐槽赢奖品
閹靛婧€鐠佸潡妫�閸ョ偛鍩屾い鍫曞劥