alterlogin.java

简单的学生管理系统

package catking.home.love;
import javax.swing.*;
import java.sql.*;
public class AlterLogin extends PrimaryKey{
	private Connection con;
	public AlterLogin(Connection con,String title,String info)
	{
		super(title,info);
		this.con = con;
	}
	@Override
	protected void isConfirm() {
		// TODO Auto-generated method stub
		if(tf.getText().length() != 10)
			JOptionPane.showMessageDialog(null,"输入栏不能为空");
		else
		{
			String[] info = {"SNO","SN","SEX","DEPT","AGE"};
			try{
				String strSelect = "SELECT * FROM S WHERE SNO=?";
				PreparedStatement ps = con.prepareStatement(strSelect);
				ps.setString(1,tf.getText());
				ResultSet rs = ps.executeQuery();
				if(rs.next())
				{
					for(int i =0; i < info.length-1; ++i)
						info[i] = rs.getString(info[i]);
					//得到age值
					info[4] = ""+rs.getInt("AGE");
				}
				else
					throw new SQLException();
			}catch(SQLException e){
				JOptionPane.showMessageDialog(null,"" +
						"错误","你要修改的客户不存在!",JOptionPane.ERROR_MESSAGE);
				return;
			}
			new AlterInfo(this.con,"修改客户数据",info);
		}
	}
}