使用JDBC创建数据库访问程序

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

  2004-1-16 补充高级内容

  关于调用SQLServer存储过程的例子：（用到了我们开发的数据库连接类）

   
   
  CREATE PROCEDURE [dbo].[sp_getStudentByName](@name char(10))
 AS
  Select * from Students where [Name]=@name
  GO

    DbObject DbO = new DbObject(new SqlServerConnectionFactory("localhost",

上一页 [1] [2] [3] [4] [5] [6] [7] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:JAVA实例:学会数字签名

下一篇:Java学习:线程池的简单构建