database.java~1~

医疗管理系统

package cliniquemanager;

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

/**
 * <p>Title: CliniqueManager</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: shine</p>
 *
 * @author robin
 * @version 1.0
 */
public class Database {
        Connection con;
        Statement s;
        ResultSet rs;
    public Database() {

    }
    public ResultSet getResultSet(String strSQL){
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ce) {
            System.out.println(ce);
        }
        try {
            String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JDBC";
            Connection con = DriverManager.getConnection(url, "sa", "");
             s = con.createStatement();
             rs = s.executeQuery(strSQL);
        } catch (SQLException ce) {
            System.out.println(ce);
        }
         return rs;
    }

}