userinfomodiframe.java

java小程序

import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.*;
public class UserInfoModiFrame extends JFrame implements ActionListener
{
private Container c;
private JLabel nameLabel,passLabel,newPassLabel,newLabelAgain;
private JTextField nameText;
private JPasswordField passText,newPassText,newPassAgainText;
private JPanel panel1,panel2;
private JButton updateButton,cancel;
private int findFlag=0;
public UserInfoModiFrame()
{
super("更改密码");
c=getContentPane();
c.setLayout(new BorderLayout());
nameLabel=new JLabel("用户名字",JLabel.CENTER);
passLabel=new JLabel("原密码",JLabel.CENTER);
newPassLabel=new JLabel("新密码",JLabel.CENTER);
newLabelAgain=new JLabel("确认新密码",JLabel.CENTER);
updateButton=new JButton("修改");
cancel=new JButton("取消");
nameText=new JTextField(10);
passText=new JPasswordField(12);
newPassText=new JPasswordField(12);
newPassAgainText=new JPasswordField(12);
panel1=new JPanel();
panel2=new JPanel();
panel1.setLayout(new GridLayout(4,2));
panel1.add(nameLabel);
panel1.add(nameText);
panel1.add(passLabel);
panel1.add(passText);
panel1.add(newPassLabel);
panel1.add(newPassText);
panel1.add(newLabelAgain);
panel1.add(newPassAgainText);
panel2.add(updateButton);
panel2.add(cancel);
updateButton.addActionListener(this);
cancel.addActionListener(this);
c.add(panel1,BorderLayout.CENTER);
c.add(panel2,BorderLayout.SOUTH);
setSize(300,200);
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
String perPass,newPass,newPassAgian;
perPass=new String(passText.getPassword());
newPass=new String(newPassText.getPassword());
newPassAgian=new String(newPassAgainText.getPassword());

//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select userName from regist");
while(rs.next())
{
if(nameText.getText().equals(rs.getString("userName")))
{
findFlag=1;
break;
}
}
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//连接数据库结束


if(e.getSource()==updateButton)
{
if(findFlag==1)
{
if(nameText.getText().equals(""))
JOptionPane.showMessageDialog(null,"用户名不能为空");
else if(perPass.equals(""))
JOptionPane.showMessageDialog(null,"原密码不能为空");
else if(newPass.equals(""))
JOptionPane.showMessageDialog(null,"新密码不能为空");
else if(newPassAgian.equals(""))
JOptionPane.showMessageDialog(null,"确认密码不能为空");
else if(!newPass.equals(newPassAgian))
{
JOptionPane.showMessageDialog(null,"两次输入的密码不一样，请重新输入！");
newPassText.setText("");
newPassAgainText.setText("");
}
//连接数据库
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
System.out.println(e1.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:bookbase");
Statement stmt=con.createStatement();
PreparedStatement pstmt=con.prepareStatement("update regist set userPass=? where userName=?");
pstmt.setString(1,newPass);
pstmt.setString(2,nameText.getText());
pstmt.executeUpdate();
stmt.close();
con.close();
passText.setText("");
newPassText.setText("");
newPassAgainText.setText("");
}
catch(SQLException ex)
{
System.out.println("SQLException:"+ex.getMessage());
}
//数据库连接结束
}
else if(findFlag==0)
{
JOptionPane.showMessageDialog(null,"用户帐号不存在!");
passText.setText("");
newPassText.setText("");
newPassAgainText.setText("");
nameText.setText("");
}
}
else if(e.getSource()==cancel)
this.dispose();
}
}