Sqlserver 存储过程 jdbc

最新推荐文章于 2025-11-25 01:29:45 发布

原创最新推荐文章于 2025-11-25 01:29:45 发布 · 78 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#JDBC #Go #.net

本文详细介绍了如何使用Java的JDBC驱动连接SQL Server数据库，实现存储过程调用及自定义SQL查询，并通过代码实例展示了具体的实现步骤。

CREATE PROCEDURE dbo.simplest AS
select * from dbo.[user]

Class.forName("net.sourceforge.jtds.jdbc.Driver");
  Connection connection = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost/hahaha;tds=8.0;lastupdatecount=true", "sa", "******");
  CallableStatement proc_stmt = connection.prepareCall("{ call dbo.simplest() }");
  ResultSet resultSet = proc_stmt.executeQuery();
  while(resultSet.next()) {
   System.out.println(resultSet.getObject("id") + ":" + resultSet.getObject("name"));
  }
  connection.close();

CREATE PROCEDURE dbo.commonpro
            @name    varchar(255)
       AS
         select * from dbo.[user] where name = @name
       GO

Class.forName("net.sourceforge.jtds.jdbc.Driver");
  Connection connection = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost/qiandai;tds=8.0;lastupdatecount=true", "sa", "123abc");
  CallableStatement proc_stmt = connection.prepareCall("{ call dbo.commonpro(?) }");
  proc_stmt.setString(1, "asd");
  ResultSet resultSet = proc_stmt.executeQuery();
  while(resultSet.next()) {
   System.out.println(resultSet.getObject("id") + " : " + resultSet.getObject("name"));
  }
  resultSet.close();
  proc_stmt.close();
  connection.close();