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原文链接：
