dblink.java~3~

只是一网站项目不错的可以看看的不看会后悔啊

package com.hugj.sunqi.mybank.model;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class DBLink {
  private java.sql.Connection conn;
  private java.sql.Statement stmt;
  private java.sql.ResultSet rs;
  private String classForName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  private String url="jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=HUGJ";
  public DBLink() {
  }

  //数据库连接
  public java.sql.Statement conn(){
    try{
      Class.forName(classForName);
      conn = java.sql.DriverManager.getConnection(url,"sa","qaz123");
      stmt = conn.createStatement();
      return stmt;
    }catch(Exception e){
      System.out.println(e.getMessage());
      return null;
    }
  }

}