connect.java

在个一个诊所系统,实现数据的查询和删除等的操作.

package clinique;

import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class connect {
    private static Connection con;
   public connect() {
       getConnection();
}
Connection getConnection(){

    try {

        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    } catch (ClassNotFoundException ce) {
        System.out.println(ce);
    }
    try {
        String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique";
        con = DriverManager.getConnection(url,"sa","");
    } catch (SQLException ce) {
    System.out.println(ce);
}
    return con;
   }
}