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

}

发布者：全栈程序员栈长，转载请注明出处：https://javaforall.cn/100546.html原文链接：