alterinfo.java

简单的学生管理系统

package catking.home.love;

import java.sql.*;
import java.awt.*;
import javax.swing.*;


public class AlterInfo extends EditClientInfo{
	private Connection con;
	private String id;
	public AlterInfo(Connection con,String title,String[]oldItems)
	{
		//oldItems[0]为id
		super(title,"编号为"+oldItems[0]+"客户信息");
		this.id = oldItems[0];
		this.con = con;
		//不能修改主键
		for(int i= 0; i < tf.length; ++i)
			tf[i].setText(oldItems[i]);
		tf[0].setEditable(false);
		tf[0].setBackground(Color.red);
	}
	@Override
	protected void isConfirm() {
		// TODO Auto-generated method stub
		//检测是否有空值
		for(int i =1; i < tf.length; ++i)
		{
			if(tf[i].getText().equals(""))
			{
				JOptionPane.showMessageDialog(null, 
						"输入错误", this.itemNames[i] + "栏不能为空",
							 JOptionPane.ERROR_MESSAGE);
				return;
			}
		}
		//尝试插入操作
		String name,sex,dept;
		int age;
		String sqlUpdate = "UPDATE S SET AGE=?,SN=?,SEX=?,DEPT=? WHERE SNO=?";
		try{
			name = tf[1].getText();
			sex = tf[2].getText();
			dept = tf[3].getText();
			age = Integer.parseInt(tf[4].getText());
			PreparedStatement ps = con.prepareStatement(sqlUpdate);
			ps.setInt(1,age);
			ps.setString(2,name);
			ps.setString(3,sex);
			ps.setString(4,dept);
			ps.setString(5,id);
			System.out.print(name+sex+dept+id+age);
			//更新
			ps.executeUpdate();
			JOptionPane.showMessageDialog(null, 
					"添加成功", "您插入记录已经成功了！",
						 JOptionPane.PLAIN_MESSAGE);
			//关闭ps
			ps.close();
		}catch(SQLException e)
		{
			e.printStackTrace();
			JOptionPane.showMessageDialog(null, 
					"输入错误", "对不起，添加数据失败！",
					JOptionPane.ERROR_MESSAGE);
		}
			
	}
	protected void isClear()
	{
		for(int i=1; i < tf.length; ++i)
			tf[i].setText("");
	}

}