connect.java

图书管理系统

/*
 * connect.java
 *
 * Created on 2007年6月21日, 下午1:00
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package 图书管理系统;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;

public class connect {
    private static Connection con=null;
    private static Statement stmt=null;
    /** Creates a new instance of connect */
   private connect() {
        try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
            con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=图书管理系统","sa","123456");
             stmt=con.createStatement();
        }
             catch(Exception ee)
         {
 ee.printStackTrace();
}
   }
  public static Connection getcon()
  {
      if(con==null)
         new connect();
      return con;
  }
    public static Statement getstmt()
    {
        if(stmt==null)
        new connect();
        return stmt;
    }
}