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

package superframe.link;

import java.sql.*;
import javax.swing.JOptionPane;
public class SQLRunner{
        ResultSet rs;
        String url="jdbc:oracle:thin:@localhost:1521:yun";
        public static ResultSet getResult(String sql) //查詢
        {
                try{
                   Class.forName("oracle.jdbc.driver.OracleDriver");
                   Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:yun","00647002","00647002");
                   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);

                    //System.out.print(e.toString());
                    return null;
                }

        }
        public static boolean executSql(String sql)//更新，刪除
        {
                try
                {
                         Class.forName("oracle.jdbc.driver.OracleDriver");
                         Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:yun","00647002","00647002");
                         Statement stmt=conn.createStatement();
                         stmt.executeUpdate(sql);
                         conn.commit();
                         return true;
                }
                catch(Exception e)
                {
                        System.out.print("executeSql"+e.toString());

                        JOptionPane.showMessageDialog(null,e.toString(),"系統提示",JOptionPane.ERROR_MESSAGE);
                        return false;
                }
        }
}