/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

package StudentManageSystem.link;

import java.sql.*;
import javax.swing.JOptionPane;
public class SQLRunner{
    public static String jdbcDriver="oracle.jdbc.driver.OracleDriver";
    public static String url="jdbc:oracle:thin:@localhost:1521:yun";
    public static String userID="00647002";
    public static String password="00647002";
        public static ResultSet getResult(String sql) //查詢
        {
                try{
                   Class.forName(jdbcDriver);
                   Connection conn=DriverManager.getConnection(url,userID,password);
                   Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
                   ResultSet rs=stmt.executeQuery(sql);
                   return rs;
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,e.toString(),"系統提示",JOptionPane.ERROR_MESSAGE);
                    return null;
                }

        }
        public static boolean executSql(String sql)//更新，刪除
        {
                try
                {
                    Class.forName(jdbcDriver);
                    Connection conn=DriverManager.getConnection(url,userID,password);
                    Statement stmt=conn.createStatement();
                    stmt.executeUpdate(sql);
                    conn.commit();
                    return true;
                }
                catch(Exception e)
                {
                    JOptionPane.showMessageDialog(null,e.toString(),"系統提示",JOptionPane.ERROR_MESSAGE);
                    return false;
                }
        }
}