newpassword.java

使用java编写的一个学生选课系统

package Srs;

import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPasswordField;
import javax.swing.JTable;

public class NewPassword extends JFrame implements ActionListener{

	private JPasswordField passwordField_1;
	private JPasswordField passwordField;
	private JButton button_2;
	private JButton button_3;
	private String Id_0;
	/**
	 * Launch the application
	 * @param args
	 */
	

	/**
	 * Create the frame
	 */
	public NewPassword(String Id) {
		super();
		Id_0 = Id;
		getContentPane().setLayout(null);
		setBounds(100, 100, 500, 375);
		this.setLocationRelativeTo(null);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.BOLD, 22));
		label.setText("修改密码");
		label.setBounds(193, 28, 176, 44);
		getContentPane().add(label);

		button_2 = new JButton();
		button_2.setText("提交修改");
		button_2.setBounds(119, 260, 106, 28);
		button_2.addActionListener(this);
		getContentPane().add(button_2);

		button_3 = new JButton();
		button_3.setText("取  消");
		button_3.setBounds(263, 260, 106, 28);
		button_3.addActionListener(this);
		getContentPane().add(button_3);

		passwordField = new JPasswordField();
		passwordField.setBounds(233, 108, 130, 28);
		getContentPane().add(passwordField);

		passwordField_1 = new JPasswordField();
		passwordField_1.setBounds(233, 171, 130, 25);
		getContentPane().add(passwordField_1);

		final JLabel label_1 = new JLabel();
		label_1.setFont(new Font("", Font.PLAIN, 16));
		label_1.setText("新密码：");
		label_1.setBounds(121, 111, 66, 18);
		getContentPane().add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setFont(new Font("", Font.PLAIN, 16));
		
		
		
		label_2.setText("密码确认：");
		label_2.setBounds(121, 172, 80, 18);
		getContentPane().add(label_2);
		//
	}
	
	public void actionPerformed(ActionEvent e){
		if(e.getSource() == button_2){
			if(String.valueOf(passwordField.getPassword()).equals
					("")||String.valueOf(passwordField_1.getPassword()).equals
					("")){
				JOptionPane newone = new JOptionPane();
				newone.showMessageDialog(null, "密码不能为空");
			}
			else{ if(!String.valueOf(passwordField.getPassword()).equals
					(String.valueOf(passwordField_1.getPassword()))){
				JOptionPane newone = new JOptionPane();
				newone.showMessageDialog(null, "前后密码输入不一致");
			}
			else{
				String m = String.valueOf(passwordField.getPassword());
				try {
		            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载access数据库驱动
		           } catch (ClassNotFoundException e1) {
		        	System.out.println("加载驱动不成功");
		            e1.printStackTrace();
		           }
		           try{

		        	   Connection conn = DriverManager.getConnection(
		        		"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=mydb.mdb");
		               Statement stmt = conn.createStatement();
		               String sql_1 = "update students set password ='" +
						m+"' where id = '"+Id_0+"'";
		               stmt.execute(sql_1);
		               JOptionPane newone = new JOptionPane();
						newone.showMessageDialog(null, "修改成功");
		               this.dispose();
		               AfterLoad after = new AfterLoad(Id_0);
		               after.setVisible(true);
		             
		           }catch(SQLException e1){
		        	   System.out.println("连接数据库未成功");
		               e1.printStackTrace();
		           }
				
			}
			}
				
	}
		else if(e.getSource() == button_3){
			this.dispose();
            AfterLoad after = new AfterLoad(Id_0);
            after.setVisible(true);
		}
		
		

}

}