java 1.定义一个数据表（比如图书信息表等） 2.为这个表建立一个类，设置和得到实例信息3.建立一个DAO类，实现对数据表的增删改查

于 2019-04-29 13:02:17 发布
阅读量1k 收藏 4
点赞数
文章标签： Java SQL Swing
若转载，请附上原文链接
本文链接：https://blog.csdn.net/Simons24/article/details/89648337
版权

1.定义一个数据表
2.为这个表建立一个类，成员变量是表的字段、方法是每个成员变量的getter与setter
3.建立一个DAO类，实现对这个表的数据的添加、删除、更新、查询（包括查询单条记录与查询多条记录）
4.建立一个Swing程序、控制台程序（二选一），实现对这个数据表的增删改查功能。

步骤：

定义一个数据表，直接在SQL数据库中定义就行。如果不清楚怎么在Java和SQL数据库中搭建JDBC，请看我的用JDBC连接SQL Server2017数据库。在这里我建立了一个学生信息的数据表。

做准备工作：

建一个Java链接SQL数据库的类：

DbTools.java:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import cn.model.www.Students;

public class DbTools {
	Connection conn;
	public Connection getConn(){
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			String url="jdbc:sqlserver://localhost:1433;DatabaseName=填写你的表格名";
			String user="你的SQL账户";
			String password="账户密码";
			conn=DriverManager.getConnection(url, user, password);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	}
	
	
}

 

为这个表建立一个Students的类：

public class Students {
	private int id;
	private String sname;
	private String sex;
	private int age;
	private String hobby;
	private String sclass;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public String getHobby() {
		return hobby;
	}
	public void setHobby(String hobby) {
		this.hobby = hobby;
	}
	public String getSclass() {
		return sclass;
	}
	public void setSclass(String sclass) {
		this.sclass = sclass;
	}

}

 

建立一个更新数据的类：

public class UpDateNumber {
	private int number;
	static int n;

	public  int getNumber() {
		return number;
	}

	public  void setNumber(int number) {
		this.number = number;
		n=number;
	}
	public static int getN(){
		return n;
	}

}

 

建立一个DAO类，实现对这个表的数据的添加、删除、更新、查询（包括查询单条记录与查询多条记录）：

package cn.dao.www;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import cn.db.www.DbTools;
import cn.model.www.Students;

public class StuDao {
	
	public int addusers(Students stu){	// 添加学生信息
		int i=0;
		DbTools db=new DbTools();
		Connection conn=db.getConn();
		try {
			String sql="insert into tb_student (sname,sex,age,hobby,sclass)values(?,?,?,?,?)";
			PreparedStatement ps=conn.prepareStatement(sql);
			ps.setString(1, stu.getSname());
			ps.setString(2, stu.getSex());
			ps.setInt(3, stu.getAge());
			ps.setString(4, stu.getHobby());
			ps.setString(5, stu.getSclass());
			i=ps.executeUpdate();
			ps.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return i;
	}
	public int updateusers(Students stu,int id){	// 修改学生信息
		int i=0;
		DbTools db=new DbTools();
		Connection conn=db.getConn();
		try {
			String sql="update tb_student set sname=?,sex=?,age=?,hobby=?,sclass=? where id=?";
			PreparedStatement ps=conn.prepareStatement(sql);
			ps.setString(1, stu.getSname());
			ps.setString(2, stu.getSex());
			ps.setInt(3, stu.getAge());
			ps.setString(4, stu.getHobby());
			ps.setString(5, stu.getSclass());
			ps.setInt(6, id);
			i=ps.executeUpdate();
			ps.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return i;
	}
	public List selectAll(){				// 查询所有学生信息
		String sql="select * from tb_student";
		DbTools db=new DbTools();
		Connection conn=db.getConn();
		ResultSet rs=null;
		List<Students> ls=new ArrayList<Students>();
		try {
			Statement st=conn.createStatement();
			rs=st.executeQuery(sql);
			
			while(rs.next()){
				Students stu=new Students();
				stu.setId(rs.getInt("id"));
				stu.setSname(rs.getString("sname"));
				stu.setSex(rs.getString("sex"));
				stu.setAge(rs.getInt("age"));
				stu.setHobby(rs.getString("hobby"));
				stu.setSclass(rs.getString("sclass"));
				ls.add(stu);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ls;
	}
	public Students getOne(int id){		// 查询一个学生信息
		Students stu=new Students();
		String sql="select * from tb_student where id="+id;
		DbTools db=new DbTools();
		Connection conn=db.getConn();
		ResultSet rs=null;
		try {
			Statement st=conn.createStatement();
			rs=st.executeQuery(sql);
			while(rs.next()){
				stu.setSname(rs.getString("sname"));
				stu.setSex(rs.getString("sex"));
				stu.setAge(rs.getInt("age"));
				stu.setHobby(rs.getString("hobby"));
				stu.setSclass(rs.getString("sclass"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return stu;
	}
	
	public void deleteStu(int id){		// 删除一个学生信息
		String sql="delete from tb_student where id="+id;
		DbTools db=new DbTools();
		Connection conn=db.getConn();
		ResultSet rs=null;
		try {
			Statement st=conn.createStatement();
			st.execute(sql);
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

开始设计Swing程序窗口对数据库进行增删改查：

包含三个窗口：一个主窗口（MainFrame），一个添加窗口（InsertStuFrame），一个更新窗口（UpdateStuFrame）

MainFrame.java:

package cn.frame.www;

import java.awt.EventQueue;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;

import cn.dao.www.StuDao;
import cn.model.www.Students;
import cn.model.www.UpDateNumber;

public class MainFrame extends JFrame {

	private JPanel contentPane;
	private JTable table;
	private StuDao dao = new StuDao();
	JScrollPane scrollPane = new JScrollPane();
	private DefaultTableModel defaultModel;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					MainFrame frame = new MainFrame();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public MainFrame() {
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 426, 357);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);

		JPanel panel = new JPanel();
		panel.setBounds(0, 0, 576, 417);
		contentPane.add(panel);
		panel.setLayout(null);

		JLabel messageLabel = new JLabel("\u5B66\u751F\u4FE1\u606F");
		messageLabel.setFont(new Font("华文中宋", Font.PLAIN, 16));
		messageLabel.setBounds(149, 26, 108, 34);
		panel.add(messageLabel);

		scrollPane.setBounds(33, 70, 346, 204);
		panel.add(scrollPane);

		selecttable();
		JButton deleteButton = new JButton("删除");
		deleteButton.addActionListener(

				new ActionListener() {
					public void actionPerformed(ActionEvent arg0) {
						do_deleteButton_actionPerformed(arg0);
					}
				}

		);
		deleteButton.setBounds(209, 284, 73, 23);
		panel.add(deleteButton);

		JButton closeButton = new JButton("关闭");
		closeButton.addActionListener(

				new ActionListener() {
					public void actionPerformed(ActionEvent arg0) {
						do_button_1_actionPerformed(arg0);
					}
				}

		);
		closeButton.setBounds(292, 284, 73, 23);
		panel.add(closeButton);

		JButton button = new JButton("\u4FEE\u6539");
		button.addActionListener(

				new ActionListener() {
					public void actionPerformed(ActionEvent e) {
						do_button_actionPerformed(e);
					}
				}

		);
		button.setBounds(126, 284, 73, 23);
		panel.add(button);

		JButton button_1 = new JButton("\u6DFB\u52A0");
		button_1.addActionListener(

				new ActionListener() {
					public void actionPerformed(ActionEvent e) {
						addstu(e);
					}
				}

		);
		button_1.setBounds(43, 284, 73, 23);
		panel.add(button_1);
	}

	public void selecttable() {
		table = new JTable();

		defaultModel = (DefaultTableModel) table.getModel();// 获得表格模型
		defaultModel.setRowCount(0);// 清空表格模型中的数据

		defaultModel.setColumnIdentifiers(new Object[] { "学号", "姓名", "性别", "年龄", "班级" });// 定义表头

		table.getTableHeader().setReorderingAllowed(false);
		table.setModel(defaultModel);// 设置表格模型
		List list = dao.selectAll();
		for (int i = 0; i < list.size(); i++) {
			Students stu = (Students) list.get(i);
			defaultModel
					.addRow(new Object[] { stu.getId(), stu.getSname(), stu.getSex(), stu.getAge(), stu.getSclass() });
		}
		scrollPane.setViewportView(table);
	}

	// 删除按钮的单击事件
	protected void do_deleteButton_actionPerformed(ActionEvent arg0) {
		int row = table.getSelectedRow();
		if (row == -1) { // 如果用户没有选择任何行，则进行提示
			JOptionPane.showMessageDialog(this, "请选择要删除的学生", "", JOptionPane.WARNING_MESSAGE);
			return;
		}

		if (row >= 0) {
			int n = JOptionPane.showConfirmDialog(getContentPane(), "确认删除吗？", "删除对话框",
					JOptionPane.YES_NO_CANCEL_OPTION);
			if (n == JOptionPane.YES_OPTION) { // 如果用户确认信息
				dao.deleteStu(Integer.parseInt(table.getValueAt(row, 0).toString()));
			}
			selecttable();
		}

	}

	// 关闭按钮的单击事件
	protected void do_button_1_actionPerformed(ActionEvent arg0) {
		int n = JOptionPane.showConfirmDialog(getContentPane(), "确认关闭吗？", "关闭对话框", JOptionPane.YES_NO_CANCEL_OPTION);
		if (n == JOptionPane.YES_OPTION) { // 如果用户确认信息
			System.exit(0);
		}
	}

	protected void addstu(ActionEvent arg0) {// 添加按钮的单击事件
		InsertStuFrame insert = new InsertStuFrame();
		insert.setVisible(true);
		selecttable();
	}

	// 修改按钮的单击事件
	protected void do_button_actionPerformed(ActionEvent e) {
		int row = table.getSelectedRow();
		if (row == -1) { // 如果用户没有选择任何行，则进行提示
			JOptionPane.showMessageDialog(this, "请选择要修改的学生", "", JOptionPane.WARNING_MESSAGE);
			return;
		}
		UpDateNumber up = new UpDateNumber();
		up.setNumber(Integer.parseInt(table.getValueAt(row, 0).toString()));
		UpdateStuFrame uf = new UpdateStuFrame();
		uf.setVisible(true);
		selecttable();
	}
}

InsertStuFrame.java:

package cn.frame.www;


import java.awt.EventQueue;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.border.EmptyBorder;

import cn.dao.www.StuDao;
import cn.model.www.Students;

public class InsertStuFrame extends JDialog {
    
    private JPanel contentPane;
    private JTextField sname;
    private JTextField age;
    private JTextField sclass;
    private JComboBox sexComboBox;
    
    JCheckBox checkBox, checkBox_1, checkBox_2, checkBox_3;
	private JTextField userNameTextField;
	private JCheckBox checkBox_4;
	private JCheckBox checkBox_5;
	StringBuffer buff = new StringBuffer();
    /**
     * Launch the application.
     */
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    InsertStuFrame frame = new InsertStuFrame();
                    frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }
    
    /**
     * Create the frame.
     */
    public InsertStuFrame() {
    	setModal(true);
		setResizable(false);
		setModalExclusionType(ModalExclusionType.TOOLKIT_EXCLUDE);
        setBounds(100, 100, 331, 363);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
        setContentPane(contentPane);
        contentPane.setLayout(null);
        setTitle("添加学生信息");
        JPanel panel = new JPanel();
        panel.setBounds(0, 0, 324, 338);
        contentPane.add(panel);
        panel.setLayout(null);
        
        JLabel nameLabel = new JLabel("姓名：");
        nameLabel.setBounds(29, 24, 45, 15);
        panel.add(nameLabel);
        
        sname = new JTextField();
        sname.setBounds(84, 21, 194, 21);
        panel.add(sname);
        sname.setColumns(10);
        
        JLabel sexLabel = new JLabel("性别：");
        sexLabel.setBounds(29, 58, 45, 15);
        panel.add(sexLabel);
        
        age = new JTextField();
        age.setBounds(214, 52, 66, 21);
        panel.add(age);
        age.setColumns(10);
        
        String[] sex = new String[] { "男", "女" };
        sexComboBox = new JComboBox(sex);
        sexComboBox.setBounds(84, 52, 55, 21);
        panel.add(sexComboBox);
        
        JLabel ageLabel = new JLabel("年龄：");
        ageLabel.setBounds(159, 58, 45, 15);
        panel.add(ageLabel);
        
        JLabel deptLabel = new JLabel("\u73ED\u7EA7\uFF1A");
        deptLabel.setBounds(29, 198, 45, 15);
        panel.add(deptLabel);
        
        
        checkBox = new JCheckBox("旅游");						// 添加复选框
    	checkBox.setBounds(84, 106, 63, 23);
    	panel.add(checkBox);	
    	checkBox_1 = new JCheckBox("看书");					// 添加复选框
    	checkBox_1.setBounds(149, 106, 63, 23);
    	panel.add(checkBox_1);
    	checkBox_2 = new JCheckBox("上网");					// 添加复选框
    	checkBox_2.setBounds(84, 143, 63, 23);
    	panel.add(checkBox_2);
    	checkBox_3 = new JCheckBox("音乐");					// 添加复选框
    	checkBox_3.setBounds(214, 106, 103, 23);
    	panel.add(checkBox_3);
    	checkBox_4 = new JCheckBox("羽毛球");					// 添加复选框
    	checkBox_4.setBounds(149, 143, 66, 23);
    	panel.add(checkBox_4);
    	checkBox_5 = new JCheckBox("乒乓球");						// 添加复选框
    	checkBox_5.setBounds(214, 143, 74, 23);
    	panel.add(checkBox_5);

        
        sclass = new JTextField();
        sclass.setBounds(84, 195, 194, 21);
        panel.add(sclass);
        sclass.setColumns(10);
        
        JButton insertButton = new JButton("添加");
        insertButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                do_insertButton_actionPerformed(arg0);
            }
        });
        insertButton.setBounds(84, 281, 66, 23);
        panel.add(insertButton);
        
        JButton closeButton = new JButton("关闭");
        closeButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                do_closeButton_actionPerformed(arg0);
            }
        });
        closeButton.setBounds(159, 281, 66, 23);
        panel.add(closeButton);
        
        JLabel label = new JLabel("\u7231\u597D\uFF1A");
        label.setBounds(29, 110, 54, 15);
        panel.add(label);
    }
    
    // 关闭按钮的单击事件
    protected void do_closeButton_actionPerformed(ActionEvent arg0) {
    	this.setVisible(false);
    }
    
    // 添加按钮的单击事件
    protected void do_insertButton_actionPerformed(ActionEvent arg0) {
        StuDao dao = new StuDao();
        Students stu = new Students();
        if (checkBox.isSelected()) {
			buff.append(checkBox.getText() + "、");
		}
		if (checkBox_1.isSelected()) {
			buff.append(checkBox_1.getText() + "、");
		}
		if (checkBox_2.isSelected()) {
			buff.append(checkBox_2.getText() + "、");
		}
		if (checkBox_3.isSelected()) {
			buff.append(checkBox_3.getText() + "、");
		}
		if (checkBox_4.isSelected()) {
			buff.append(checkBox_4.getText() + "、");
		}
		if (checkBox_5.isSelected()) {
			buff.append(checkBox_5.getText() + "、");
		}
		String strLoves = buff.toString();
        stu.setSname(sname.getText());
        stu.setSex(sexComboBox.getSelectedItem().toString());
        stu.setAge(Integer.parseInt(age.getText()));
        stu.setSclass(sclass.getText());
        stu.setHobby(strLoves);
        if (!(sname.getText().equals(""))
                && (!sclass.getText().equals(""))
                && (!age.getText().equals(""))) {
            dao.addusers(stu);
            
            JOptionPane.showMessageDialog(getContentPane(), "数据添加成功！", "信息提示框",
                    JOptionPane.WARNING_MESSAGE);
        } else {
            JOptionPane.showMessageDialog(getContentPane(), "请将信息添加完整！",
                    "信息提示框", JOptionPane.WARNING_MESSAGE);
        }
    }
}

UpdateStuFrame.java:

package cn.frame.www;

import java.awt.EventQueue;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.border.EmptyBorder;

import cn.dao.www.StuDao;
import cn.model.www.Students;
import cn.model.www.UpDateNumber;

public class UpdateStuFrame extends JDialog {

	private JPanel contentPane;
	private JTextField sname;
	private JTextField age;
	private JTextField sclass;
	private JComboBox sexComboBox;

	JCheckBox checkBox, checkBox_1, checkBox_2, checkBox_3;
	private JTextField userNameTextField;
	private JCheckBox checkBox_4;
	private JCheckBox checkBox_5;
	StringBuffer buff = new StringBuffer();
	StuDao dao = new StuDao();
	int id=UpDateNumber.getN();
	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					UpdateStuFrame frame = new UpdateStuFrame();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public UpdateStuFrame() {
    	setModal(true);
		setResizable(false);
		setModalExclusionType(ModalExclusionType.TOOLKIT_EXCLUDE);
        setBounds(100, 100, 329, 380);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
        setContentPane(contentPane);
        contentPane.setLayout(null);
        setTitle("添加学生信息");
        JPanel panel = new JPanel();
        panel.setBounds(0, 0, 325, 356);
        contentPane.add(panel);
        panel.setLayout(null);
        
        JLabel nameLabel = new JLabel("姓名：");
        nameLabel.setBounds(29, 64, 45, 15);
        panel.add(nameLabel);
        
        sname = new JTextField();
        sname.setBounds(84, 61, 194, 21);
        panel.add(sname);
        sname.setColumns(10);
        
        JLabel sexLabel = new JLabel("性别：");
        sexLabel.setBounds(29, 110, 45, 15);
        panel.add(sexLabel);
        
        age = new JTextField();
        age.setBounds(204, 107, 66, 21);
        panel.add(age);
        age.setColumns(10);
        
        String[] sex = new String[] { "男", "女" };
        sexComboBox = new JComboBox(sex);
        sexComboBox.setBounds(84, 107, 55, 21);
        panel.add(sexComboBox);
        
        JLabel ageLabel = new JLabel("年龄：");
        ageLabel.setBounds(149, 110, 45, 15);
        panel.add(ageLabel);
        
        JLabel deptLabel = new JLabel("\u73ED\u7EA7\uFF1A");
        deptLabel.setBounds(29, 241, 45, 15);
        panel.add(deptLabel);
        
        
        checkBox = new JCheckBox("旅游");						// 添加复选框
    	checkBox.setBounds(84, 155, 63, 23);
    	panel.add(checkBox);	
    	checkBox_1 = new JCheckBox("看书");					// 添加复选框
    	checkBox_1.setBounds(149, 155, 63, 23);
    	panel.add(checkBox_1);
    	checkBox_2 = new JCheckBox("上网");					// 添加复选框
    	checkBox_2.setBounds(84, 191, 63, 23);
    	panel.add(checkBox_2);
    	checkBox_3 = new JCheckBox("音乐");					// 添加复选框
    	checkBox_3.setBounds(214, 155, 103, 23);
    	panel.add(checkBox_3);
    	checkBox_4 = new JCheckBox("羽毛球");					// 添加复选框
    	checkBox_4.setBounds(149, 191, 66, 23);
    	panel.add(checkBox_4);
    	checkBox_5 = new JCheckBox("乒乓球");						// 添加复选框
    	checkBox_5.setBounds(214, 191, 74, 23);
    	panel.add(checkBox_5);

        
        sclass = new JTextField();
        sclass.setBounds(84, 238, 194, 21);
        panel.add(sclass);
        sclass.setColumns(10);
        
        JButton insertButton = new JButton("\u4FEE\u6539");
        insertButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                do_insertButton_actionPerformed(arg0);
            }
        });
        insertButton.setBounds(84, 306, 66, 23);
        panel.add(insertButton);
        
        JButton closeButton = new JButton("关闭");
        closeButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {
                do_closeButton_actionPerformed(arg0);
            }
        });
        closeButton.setBounds(160, 306, 66, 23);
        panel.add(closeButton);
        
        JLabel label = new JLabel("\u7231\u597D\uFF1A");
        label.setBounds(29, 159, 54, 15);
        panel.add(label);
        
        JLabel label_1 = new JLabel("\u5B66\u53F7\uFF1A");
        label_1.setBounds(29, 28, 45, 15);
        panel.add(label_1);
        
        JLabel stuid = new JLabel(UpDateNumber.getN()+"");
        stuid.setBounds(84, 28, 84, 15);
        panel.add(stuid);
        
        // 获得要修改的学生信息
    	
    	Students stu=dao.getOne(id);
    	sname.setText(stu.getSname());
    	age.setText(stu.getAge()+"");
    	sclass.setText(stu.getSclass());
    	String[] hy=stu.getHobby().split("、");
    	if(hy.length>0){
    		for(int i=0;i<hy.length;i++){			// 为爱好赋值
    			if(hy[i].equals("旅游")){
    				checkBox.setSelected(true);
    			}
    			if(hy[i].equals("看书")){
    				checkBox_1.setSelected(true);
    			}
    			if(hy[i].equals("上网")){
    				checkBox_2.setSelected(true);
    			}
    			if(hy[i].equals("音乐")){
    				checkBox_3.setSelected(true);
    			}
    			if(hy[i].equals("羽毛球")){
    				checkBox_4.setSelected(true);
    			}
    			if(hy[i].equals("乒乓球")){
    				checkBox_5.setSelected(true);
    			}
    		}
    	}
    	if("男".equals(stu.getSex())){				// 为性别赋值
    		sexComboBox.setSelectedIndex(0);
    	}else{
    		sexComboBox.setSelectedIndex(1);
    	}
    	
    }

	// 关闭按钮的单击事件
	protected void do_closeButton_actionPerformed(ActionEvent arg0) {
		this.setVisible(false);
	}

	// 添加按钮的单击事件
	protected void do_insertButton_actionPerformed(ActionEvent arg0) {
		StuDao dao = new StuDao();
		Students stu = new Students();

		if (checkBox.isSelected()) {
			buff.append(checkBox.getText() + "、");
		}
		if (checkBox_1.isSelected()) {
			buff.append(checkBox_1.getText() + "、");
		}
		if (checkBox_2.isSelected()) {
			buff.append(checkBox_2.getText() + "、");
		}
		if (checkBox_3.isSelected()) {
			buff.append(checkBox_3.getText() + "、");
		}
		if (checkBox_4.isSelected()) {
			buff.append(checkBox_4.getText() + "、");
		}
		if (checkBox_5.isSelected()) {
			buff.append(checkBox_5.getText() + "、");
		}
		String strLoves = buff.toString();

		stu.setSname(sname.getText());
		stu.setSex(sexComboBox.getSelectedItem().toString());
		stu.setAge(Integer.parseInt(age.getText()));
		stu.setSclass(sclass.getText());
		stu.setHobby(strLoves);
		if (!(sname.getText().equals("")) && (!sclass.getText().equals(""))
				&& (!age.getText().equals(""))) {
			dao.updateusers(stu,id);

			JOptionPane.showMessageDialog(getContentPane(), "数据修改成功！", "信息提示框",
					JOptionPane.WARNING_MESSAGE);
		} else {
			JOptionPane.showMessageDialog(getContentPane(), "请将信息添加完整！",
					"信息提示框", JOptionPane.WARNING_MESSAGE);
		}

	}
}

全部代码请访问：https://gitee.com/simons24/Java_study.git

解忧杂货店员
关注
  • 0
    点赞
  • 踩
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值