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");
}
}
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