Page 46 - 3-2
P. 46

rs2 = stmt.executeUpdate(sql);
                                                            stmt.close();
                                                            con.close();
                                            } catch (ClassNotFoundException e) {
                                            e.printStackTrace();
                                            System.out.println("DB Driver Error!");
                                            } catch (SQLException se) {
                                            se.printStackTrace();
                                            System.out.println("DB Connection Error!");
                                                    } finally{
                                                            try{
                                                                    if(stmt!=null)


                                    stmt.close();
                                                    }catch(SQLException se2){
                                                    }
                                                    try{
                                                                    if(con!=null)
                                                                    con.close();
                                                                    }catch(SQLException se) {
                                                                    se.printStackTrace();
                                                                    }
                                                    }
                                            }
                                    }
                            });
                                            }
            }


            ******************************MDP_Project3****************************


            import com.pi4j.io.gpio.GpioController;
            import com.pi4j.io.gpio.GpioFactory;
            import com.pi4j.io.gpio.GpioPinDigitalInput;
            import com.pi4j.io.gpio.PinPullResistance;
            import com.pi4j.io.gpio.RaspiPin;
            import com.pi4j.io.gpio.event.GpioPinDigitalStateChangeEvent;
            import com.pi4j.io.gpio.event.GpioPinListener;
            import com.pi4j.io.gpio.event.GpioPinListenerDigital;
            import java.awt.EventQueue;
            import javax.swing.JFrame;
            import javax.swing.JPanel;
            import javax.swing.border.EmptyBorder;
            import javax.swing.JButton;
            import java.awt.Font;


                                                         - 46 -
   41   42   43   44   45   46   47   48   49   50   51