Wednesday, 18 September 2013

update connectivity

   private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String admno= jTextField1.getText();
    String rollno= jTextField2.getText();
    String name = jTextField3.getText();
    String address =jTextField4.getText();
    String marks=jTextField5.getText();


    try

    {
        Class.forName("java.sql.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/school","root","1234");
            Statement stmt =  con.createStatement();
            String query= "Update student set rollno='"+rollno+"',name='"+name+"',address='"+address+"', marks='"+marks+"'  where admno="+admno+";";
;

                 JOptionPane.showMessageDialog(this,query);
            stmt.executeUpdate(query);


    }

    catch(Exception e)
    {
        JOptionPane.showMessageDialog(this,e.getMessage());
    }


1 comment:

  1. Play now Blackjack at the casino - Goyang FC
    Play now 토토사이트중계 Blackjack at the casino. Learn more 저녁 메뉴 추천 룰렛 about the exciting and exciting 이 스포츠 Blackjack game. We will show you the best strategies bet analysis to play when playing 딥 슬롯 트위터

    ReplyDelete