sql server jdbc

最新推荐文章于 2025-07-24 14:47:55 发布

原创最新推荐文章于 2025-07-24 14:47:55 发布 · 633 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #sql server #sqlserver #null #string #microsoft

本文提供两种使用Java连接Microsoft SQL Server的方法。一种是通过jTDS驱动连接SQL Server，另一种是利用Microsoft官方提供的JDBC驱动。每种方法都包括加载驱动、建立连接、执行查询并打印结果的完整步骤。

package com.cjt.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class MssqlJtds {

   /**
   * @param args
   * @throws ClassNotFoundException
   * @throws SQLException
   */
   public static void main(String[] args) throws ClassNotFoundException, SQLException {
       // TODO Auto-generated method stub

       Class.forName("net.sourceforge.jtds.jdbc.Driver");

       Connection conn = null;

       Statement stmt = null;

       ResultSet rs =null;
       String url = "jdbc:jtds:sqlserver://localhost:1433/pubs";
       conn = DriverManager.getConnection(url,"sa","sa");
       stmt = conn.createStatement();

       rs = stmt.executeQuery("select * from authors");

       while(rs.next())
       {
           System.out.println(rs.getObject(1));
       }

       stmt.close();

       conn.close();

   }

}

//另一种方法
package com.cjt.jdbc;

import java.sql.Connection;

public class MssqlCom {

    /**
    * @param args
    * @throws ClassNotFoundException
    * @throws SQLException
    */
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // TODO Auto-generated method stub

        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

        Connection conn = null;

        Statement stmt = null;

        ResultSet rs =null;
        String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
        conn = DriverManager.getConnection(url,"sa","sa");
        stmt = conn.createStatement();

        rs = stmt.executeQuery("select * from authors");

        while(rs.next())
        {
            System.out.println(rs.getObject(1));
        }

        stmt.close();

        conn.close();

    }

}