java连接 mssql的代码。

//package com.qiaole.conn;

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

public class DBUtil{
 public static void main(String[] args) 
 {
  try
  {
	   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
	   String url = "jdbc:sqlserver://localhost:1434;databasename=db_CCCM";
	   Connection conn = DriverManager.getConnection(url, "sa", "k");
	   String sql = "select * from 部门信息";
	   PreparedStatement psStatement = conn.prepareStatement(sql);
	   ResultSet rSet = psStatement.executeQuery();
	   System.out.println("\tMssql查询数据");
	   while (rSet.next()) 
	   {
	    System.out.println(rSet.getString(1) + "\t" +rSet.getString(2) + "\t");
	   	}
	   close(rSet);//关闭连接
	   close(psStatement);
	   close(conn);
  } 
  catch (InstantiationException e) 
  {
   e.printStackTrace();
  } 
  catch (IllegalAccessException e) 
  {
   e.printStackTrace();
  } 
  catch (ClassNotFoundException e) 
  {
   e.printStackTrace();
  }
  catch (SQLException e) 
  {
   e.printStackTrace();
  }
 }
 
	public static void close(Connection conn) {
		try {
			if(conn != null) {
				conn.close();
				conn = null;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static void close(PreparedStatement stmt) {
		try {
			if(stmt != null) {
				stmt.close();
				stmt = null;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static void close(ResultSet rs) {
		try {
			if(rs != null) {
				rs.close();
				rs = null;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}