Saturday, 1 November 2014

JDBC program logic for Update Password when Username and Password is correct

package studentdb;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.swing.JOptionPane;
{

Connection con;
     
       try
       {
           Class.forName("com.mysql.jdbc.Driver");
           con=DriverManager.getConnection("jdbc:mysql://localhost/college","root","root");
           if(t3.getText().equals(t4.getText()))
           {
           String sq="update student set pass=? where uname=? and pass=?";
           PreparedStatement ps=con.prepareStatement(sq);
           ps.setString(1,t3.getText());
           ps.setString(2,t1.getText());
           ps.setString(3,t2.getText());
         
           int i=ps.executeUpdate();
           if(i==1)
         JOptionPane.showMessageDialog(null,"Password Updated");
           }
           else
           {
            JOptionPane.showMessageDialog(null,"Password not Updated");
           
           }
         
       }
       catch(Exception e)
       {
                    JOptionPane.showMessageDialog(null,"SQl Error");
       }
}

No comments:

Post a Comment