jdbc连接sqlserver2005数据库

package com.sea.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnectToSqlserver {
  /*
     jtds-1.2连接sqlserver2005
  String dataDriver = "net.sourceforge.jtds.jdbc.Driver";
  String dataUrl = "jdbc:jtds:sqlserver://localhost:4577/test";
   */
        //msbase.jar,mssqlserver.jar,msutil.jar连接sqlserver2005
  private String  dataDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  private String dataUrl = "jdbc:microsoft:sqlserver://localhost:4577;DatabaseName=test";
  private String username = "sa";
  private String password = "sa";
  private Statement stam;
  private ResultSet rs=null;
  private Connection conn = null;
  public Connection getC(){
   return this.conn;
  }
        public ConnectToSqlserver(){
         try{
          Class.forName(dataDriver);
          conn = DriverManager.getConnection(dataUrl, username, password);
          stam=conn.createStatement();
         }catch(Exception e){
          e.printStackTrace();
         }
        }
        /**
         *
         * @return
         */
  public Connection getConn() {
   try {// 获取数据库驱动连接
    Class.forName(dataDriver);
    // 连接数据库
    conn = DriverManager.getConnection(dataUrl, username, password);
    if (conn == null || conn.isClosed()) {
     System.out.println("连接数据库失败");
    } else
     System.out.println("连接数据库成功");
   } catch (Exception e) {
    e.printStackTrace();
   }
   return conn;
  }
  /**
   *
   * @param sql
   * @return
   */
  public ResultSet executeQuery(String sql){
   rs=null;
   try{
    rs=stam.executeQuery(sql);
   }catch(SQLException e){
    e.printStackTrace();
   }
   return rs;
  }
  /**
   *
   * @param sql
   * @return
   */
  public boolean executeUpdate(String sql){
   try{
    stam.executeUpdate(sql);
    return true;
   }catch(SQLException e){
    e.printStackTrace();
       return false;
   }
  }
  /**
   *
   */
  public void close(){
   try{
    stam.close();
    conn.close();
   }catch(Exception e){
    e.printStackTrace();
   }
  }
  /**
   *
   * @param str
   * @return
   */
  public String ex_chinese(String str){
        if(str==null){
        str  ="" ;
        }
        else{
            try {
           str = new String(str.getBytes("iso-8859-1"),"gb2312") ;
            }
            catch (Exception ex) {
            }
        }
        return str ;
     }
  /**
   *
   * @return
   */
     public String getTime() {
       String datestr =  "" ;
       try {
       java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy年MM月dd日 HH点ss分") ;
       java.util.Date date = new java.util.Date() ;
       datestr = df.format(new java.util.Date()) ;
       System.out.println(datestr);
       }
       catch (Exception ex) {

       }

       return datestr ;
    }
  /**
   * @param args
   */
  public static void main(String[] args) {
   // TODO Auto-generated method stub
   ConnectToSqlserver cts=new ConnectToSqlserver();
   ResultSet rs=cts.executeQuery("select * from STUDENT");
   try{
    while(rs.next()){
     System.out.println(rs.getString("ID"));
     System.out.println(rs.getString("NAME"));
     System.out.println(rs.getString("SCORE"));
    }
   }catch(Exception e){
    e.printStackTrace();
   }
  }

}