java数据库连接及测试(sqlserver)

package com.test.util;

import java.sql.*;

public class ConnectDB {
 private Connection conn=null;
 private PreparedStatement pt=null;
 private ResultSet rs=null;
 private String uname="sa";
 private String upwd="sa";
 private String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=vsktest";
 
 
 public Connection getConnection() throws Exception{
  Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  conn=DriverManager.getConnection(url, uname, upwd);
  return conn;  
 }
 public void closeDB() throws Exception{
  if(rs!=null){
   rs.close();
  }
  if(pt!=null){
   pt.close();
  }
  if(conn!=null){
   conn.close();
  }
   
 }

 public static void main(String[] args) throws Exception {
  Connection conn=new ConnectDB().getConnection();
  PreparedStatement pt=conn.prepareStatement("select * from test");
  ResultSet rs=pt.executeQuery();
  while(rs.next())
  {
   System.out.println(rs.getString("testname"));
  }
   
 }//end main

}