JDBC 连接 SqlServer

三种方式：

1、jdk 1.6 连接sql server 2000, 依赖包：msbase.jar，mssqlserver.jar，msutil.jar
String m_Driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String m_Url = "jdbc:microsoft:sqlserver://Ip:Port;DatabaseName=dbName";


2、jdk 1.6 连接sql server 2005 , 依赖包：jtds-1.2.6.jar
String m_Driver = "net.sourceforge.jtds.jdbc.Driver";
String m_Url = "jdbc:jtds:sqlserver://Ip:Port/dbName";

3、jdk 1.6 连接sql server , 依赖包：sqljdbc4.jar

String m_Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String m_Url = "jdbc:sqlserver://Ip:Port;DatabaseName=dbName";

Demo:

例子中采用sqljdbc方式连接：
java -cp .:/home/xxx/sqljdbc4.jar JdbcSqlserver "dbName" "querySql"

import java.sql.DriverManager;import java.sql.Statement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Connection;/** * Created with IntelliJ IDEA. * User: xxx * Date: 13-11-28 * Time: 下午4:25 * To change this template use File | Settings | File Templates. */public class JdbcSqlserver {    Connection conn = null;    public JdbcSqlserver() {    }    public  void getConnection(String URL, String username, String password) {        if (URL==null || username ==null || password == null                || URL.isEmpty() || username.isEmpty() || password.isEmpty()){            return;        }        String m_Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";        try {            Class.forName(m_Driver).newInstance();            conn = DriverManager.getConnection(URL, username, password);        } catch (Exception e) {            e.printStackTrace();        }        return;    }    public  String[][] executeQuery(String query) {        if(conn==null || query ==null || query.isEmpty())            return null;        Statement m_Statement = null;        ResultSet m_ResultSet = null;        int row = 0;        int column = 0;        try{            m_Statement = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);            m_ResultSet = m_Statement.executeQuery(query);            column = m_ResultSet.getMetaData().getColumnCount(); //获取列数;            m_ResultSet.last();            row = m_ResultSet.getRow();   //获取行数;        } catch (SQLException ex) {            ex.printStackTrace();            return null;        }        String[][] results = new String[row][column];        int i=0;        try{            if(m_ResultSet.first())//回到第一行;            {                  for(int j=1;j<=column;j++){                     results[0][j-1] =  m_ResultSet.getString(j);                     System.out.print(results[i][j-1].trim()+"/t");                 }                 System.out.print("/n");                 i++;            }            while (m_ResultSet.next()) {                for(int j=1;j<=column;j++){                    results[i][j-1] =  m_ResultSet.getString(j);                    System.out.print(results[i][j-1].trim()+"/t");                }                i++;                System.out.print("/n");            }        } catch (SQLException ex) {            ex.printStackTrace();        } finally {            try {                if (m_ResultSet != null)                    m_ResultSet.close();                if (m_Statement != null)                    m_Statement.close();            }            catch (SQLException ex) {                ex.printStackTrace();                return results;            }        }        return results;    }    public void close() {        try {            if(conn != null){                conn.close();            }        } catch (SQLException e) {            e.printStackTrace();        }    }    public static void main(String[] args) {        JdbcSqlserver dbTest = new JdbcSqlserver();        dbTest.getConnection("jdbc:sqlserver://Ip:Port;DatabaseName="+args[0],"userName","password");        dbTest.executeQuery(args[1]);        dbTest.close();    }}