mydatabase.java

医疗管理系统

package cliniquemanager;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.SQLException;
import javax.swing.JOptionPane;

/**
 * <p>Title: CliniqueManager</p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: shine</p>
 *
 * @author robin
 * @version 1.0
 */
public class MyDatabase {
        static String username;
        Connection con;
        Statement s;
        ResultSet rs;
        Boolean flag=false;
        public MyDatabase(){
            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", "");
                s = con.createStatement();

            } catch (SQLException ce) {
                System.out.println(ce);
                JOptionPane.showMessageDialog(null,ce.toString(),"",JOptionPane.INFORMATION_MESSAGE);
            }

        }
    public ResultSet getResultSet(String strSQL) {
        try{
            rs = s.executeQuery(strSQL);
        }catch(SQLException se){
            se.printStackTrace();
        }
        flag=true;
        return rs;
    }
    public Statement getStatement(){
        return s;
    }
    public void close(){
        try{
            if(flag==true){
                rs.close();
                flag=false;
            }
            s.close();
            con.close();
        }catch(SQLException se){
            se.printStackTrace();
        }
    }
}