/*
 * conect.java
 *
 * Created on 2007年11月7日, 下午2:13
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package javaapplication1;

/**
 *import java.sql.*; //導入JavaSQL包，連接數據庫必需
import java.util.*;
/*
 * conection.java
 *
 * Created on 2007年10月28日, 下午8:12
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import java.text.*;
import javax.swing.JOptionPane;

/**
 *
 * @author mis05
 */

public class Conect{

String driverName ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=guxia";
String userName="guxia";
String userPwd="123456";
Connection dbConn; //定義連接對象
   public Conect() throws ClassNotFoundException,SQLException{
   try{
       Class.forName(driverName);
       dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
       System.out.println("ConnectionSuccessful!");
      }
   catch(SQLException sqlException){
       JOptionPane.showMessageDialog(null,sqlException.getMessage(),"Driver Not Found",JOptionPane.ERROR_MESSAGE);
       System.exit(0);}
   
   catch(ClassNotFoundException classNotFound){
       JOptionPane.showMessageDialog(null,classNotFound.getMessage(),"Driver Not Found",JOptionPane.ERROR_MESSAGE);
       System.exit(0);}
   }
}