DBConnected.java

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

import javax.swing.JOptionPane;

public class DBConnected {
 static PreparedStatement psmt;
 static ResultSet res=null;
 public static Connection conn=null;
 public static void connect(){
 try {
  Class.forName("oracle.jdbc.driver.OracleDriver");
   conn=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid");
   System.out.println("login 1");
 } catch (ClassNotFoundException e1) {
  e1.printStackTrace();
 } catch (SQLException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
 }
 }
// 
// public  DBConnected()
// 
//
// {
//  try {
//   Class.forName("oracle.jdbc.driver.OracleDriver");
//    conn=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid");
//    System.out.println("login 1");
//  } catch (ClassNotFoundException e1) {
//   e1.printStackTrace();
//  } catch (SQLException e) {
//   // TODO Auto-generated catch block
//   e.printStackTrace();
//  }
//  
//  
// }
 
 
 
 
 
 public static ResultSet getMsg(String sql)
 {
  PreparedStatement psmt;
  ResultSet res=null;
  
  
  try {
   psmt = conn.prepareStatement(sql);
    res = psmt.executeQuery();
    System.out.println("login 2");
   // JOptionPane.showMessageDialog(null, "使用者不存在");
   
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   //e.printStackTrace();
   System.out.println("login 3");
  } 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 return res; 
 }
 
// public static void main()
// {
//
// }
 
 
 public static void commit(String sql)
 {
  
 
  
  try {
   psmt = conn.prepareStatement(sql);
   res = psmt.executeQuery();
    if(res.next())
    {
  psmt.executeUpdate(sql);
  JOptionPane.showMessageDialog(null, "成功"); 
    
    
    }
   
  } catch (SQLException e) {
  // TODO Auto-generated catch block
   //e.printStackTrace();
   JOptionPane.showMessageDialog(null, "失敗");
   e.printStackTrace();
   
  }
 }
  

 
// public static void insert(String sql) extends commit
// {
//  
//  
// }
// 
// 
// 
// 
// 
// 
// 
// 
//}
//  abstract class commit
// {
//  PreparedStatement psmt;
//  ResultSet res=null;
//  
// }
// 
// 
 
  
// static
// {
////  static PreparedStatement psmt;
////  static ResultSet res=null;
////  public static Connection conn=null;
//  
//  try {
//   Class.forName("oracle.jdbc.driver.OracleDriver");
//    conn=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1522:stuf1dbsid");
//    System.out.println("login 1");
//  } catch (ClassNotFoundException e1) {
//   e1.printStackTrace();
//  } catch (SQLException e) {
//   // TODO Auto-generated catch block
//   e.printStackTrace();
//  }
// 
//  
//  
//  
//  
//  
//  
// }
  
 

 
}