基于java+mysql的swing+mysql学生管理系统java基础gui(java+gui)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于java+mysql的Swing+MySQL学生管理系统java基础gui(java+gui)
功能介绍:
学生信息管理,姓名,编号,性别,成绩,学号住址
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 重置表单
*/
private void resetValue(){
this.idTxt.setText("");
this.nameTxt.setText("");
this.snTxt.setText("");
this.deptTxt.setText("");
this.manJrb.setSelected(true);
this.addressTxt.setText("");
if(this.schoolClassJcb.getItemCount()>0){
this.schoolClassJcb.setSelectedIndex(0);
}
}
/**
* 表格行点击事件处理
* @param met
*/
private void studentTableMousePressed(MouseEvent met) {
int row=this.studentTable.getSelectedRow();
this.idTxt.setText((String)studentTable.getValueAt(row, 0));
this.nameTxt.setText((String)studentTable.getValueAt(row, 1));
this.snTxt.setText((String)studentTable.getValueAt(row, 2));
String sex=(String)studentTable.getValueAt(row, 3);
if("男".equals(sex)){
this.manJrb.setSelected(true);
}else if("女".equals(sex)){
this.femaleJrb.setSelected(true);
}
this.deptTxt.setText(studentTable.getValueAt(row, 4)+"");
this.addressTxt.setText((String)studentTable.getValueAt(row, 5));
String className=(String)this.studentTable.getValueAt(row, 6);
int n=this.schoolClassJcb.getItemCount();
for(int i=0;i<n;i++){
SchoolClass item=(SchoolClass)this.schoolClassJcb.getItemAt(i);
if(item.getClassName().equals(className)){
this.schoolClassJcb.setSelectedIndex(i);
}
}
}
/**
}
}
}
/**
* 学生信息修改事件处理
* @param evt
*/
private void studentUpdateActionPerformed(ActionEvent evt) {
String id=this.idTxt.getText();
if(StringUtil.isEmpty(id)){
JOptionPane.showMessageDialog(null, "请选择要修改的记录");
return;
}
String sname=this.nameTxt.getText();
String sn=this.snTxt.getText();
String dept=this.deptTxt.getText();
String address=this.addressTxt.getText();
if(StringUtil.isEmpty(sname)){
JOptionPane.showMessageDialog(null, "学生信息名称不能为空!");
return;
}
if(StringUtil.isEmpty(sn)){
JOptionPane.showMessageDialog(null, "学生信息作者不能为空!");
return;
}
if(StringUtil.isEmpty(dept)){
JOptionPane.showMessageDialog(null, "学生信息价格不能为空!");
return;
}
String sex="";
if(manJrb.isSelected()){
sex="男";
}else if(femaleJrb.isSelected()){
sex="女";
}
.addComponent(lblNewLabel_1)
.addComponent(lblNewLabel_2)
.addComponent(btnNewButton))
.addGap(32)
.addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
.addComponent(btnNewButton_1)
.addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING, false)
.addComponent(passwordTxt)
.addComponent(userNameTxt, GroupLayout.DEFAULT_SIZE, 128, Short.MAX_VALUE)))))
.addContainerGap(111, Short.MAX_VALUE))
);
gl_contentPane.setVerticalGroup(
gl_contentPane.createParallelGroup(Alignment.LEADING)
.addGroup(gl_contentPane.createSequentialGroup()
.addGap(30)
.addComponent(lblNewLabel)
.addGap(26)
.addGroup(gl_contentPane.createParallelGroup(Alignment.LEADING)
.addGroup(gl_contentPane.createSequentialGroup()
.addComponent(lblNewLabel_1)
.addGap(29)
.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
.addComponent(lblNewLabel_2)
.addComponent(passwordTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)))
.addComponent(userNameTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(36)
.addGroup(gl_contentPane.createParallelGroup(Alignment.BASELINE)
.addComponent(btnNewButton)
.addComponent(btnNewButton_1))
.addContainerGap(60, Short.MAX_VALUE))
);
contentPane.setLayout(gl_contentPane);
// 设置JFrame居中显示
this.setLocationRelativeTo(null);
}
/**
* 登录事件处理
* @param e
*/
sex="男";
}else if(femaleJrb.isSelected()){
sex="女";
}
SchoolClass bookType=(SchoolClass) schoolClassJcb.getSelectedItem();
int bookTypeId=bookType.getId();
Student book=new Student(bookName,author, sex, price , bookTypeId, bookDesc);
Connection con=null;
try{
con=dbUtil.getCon();
int addNum=studentDao.add(con, book);
if(addNum==1){
JOptionPane.showMessageDialog(null, "学生添加成功!");
resetValue();
}else{
JOptionPane.showMessageDialog(null, "学生添加失败!");
}
}catch(Exception e){
e.printStackTrace();
JOptionPane.showMessageDialog(null, "学生添加失败!");
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 重置表单
*/
private void resetValue(){
this.studentTxt.setText("");
this.snTxt.setText("");
this.deptTxt.setText("");
this.manJrb.setSelected(true);
this.addressTxt.setText("");
if(this.schoolClassJcb.getItemCount()>0){
this.schoolClassJcb.setSelectedIndex(0);
}
}
/**
* 初始化学生类别下拉框
* @throws Exception
*/
public boolean existStudentByclassId(Connection con,String classId)throws Exception{
String sql="select * from t_student where classId=?";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1, classId);
ResultSet rs=pstmt.executeQuery();
return rs.next();
}
}
/**
* 班级Dao类
*
*/
public class SchoolClassDao {
/**
* 班级添加
* @param con
* @param schoolClass
* @return
* @throws Exception
*/
public int add(Connection con,SchoolClass schoolClass)throws Exception{
String sql="insert into t_school_class values(null,?,?)";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1, schoolClass.getClassName());
System.out.println(schoolClass.getClassName());
pstmt.setString(2, schoolClass.getCalssDesc());
return pstmt.executeUpdate();
}
/**
* 查询班级集合
* @param con
* @param schoolClass
* @return
* @throws Exception
*/
public ResultSet list(Connection con,SchoolClass schoolClass)throws Exception{
StringBuffer sb=new StringBuffer("select * from t_school_class");
if(StringUtil.isNotEmpty(schoolClass.getClassName())){
* 班级信息搜索事件处理
* @param evt
*/
private void schoolClassSearchActionPerformed(ActionEvent evt) {
String s_className=this.s_classNameTxt.getText();
SchoolClass schoolClass=new SchoolClass();
schoolClass.setClassName(s_className);
this.fillTable(schoolClass);
}
/**
* 初始化表格
* @param schoolClass
*/
private void fillTable(SchoolClass schoolClass){
DefaultTableModel dtm=(DefaultTableModel) schoolClassTable.getModel();
dtm.setRowCount(0); // 设置成0行
Connection con=null;
try{
con=dbUtil.getCon();
ResultSet rs=schoolClassDao.list(con, schoolClass);
while(rs.next()){
Vector v=new Vector();
v.add(rs.getString("id"));
v.add(rs.getString("className"));
v.add(rs.getString("classDesc"));
dtm.addRow(v);
}
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 重置表单
*/
private void resetValue(){
this.idTxt.setText("");
this.classNameTxt.setText("");
this.classDescTxt.setText("");
}
}
private String calssDesc; // 备注
public SchoolClass() {
super();
// TODO Auto-generated constructor stub
}
public SchoolClass(String className, String calssDesc) {
super();
this.className = className;
this.calssDesc = calssDesc;
}
public SchoolClass(int id, String className, String calssDesc) {
super();
this.id = id;
this.className = className;
this.calssDesc = calssDesc;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getClassName() {
return className;
}
public void setClassName(String className) {
this.className = className;
}
public String getCalssDesc() {
return calssDesc;
}
public void actionPerformed(ActionEvent e) {
bookTypeAddActionPerformed(e);
}
});
btnNewButton.setIcon(new ImageIcon(SchoolClassAddInterFrm.class.getResource("/images/add.png")));
JButton btnNewButton_1 = new JButton("重置");
btnNewButton_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
resetValueActionPerformed(e);
}
});
btnNewButton_1.setIcon(new ImageIcon(SchoolClassAddInterFrm.class.getResource("/images/reset.png")));
GroupLayout groupLayout = new GroupLayout(getContentPane());
groupLayout.setHorizontalGroup(
groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(86)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addComponent(lblNewLabel)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(classNameTxt, GroupLayout.PREFERRED_SIZE, 185, GroupLayout.PREFERRED_SIZE))
.addGroup(groupLayout.createSequentialGroup()
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addComponent(lblNewLabel_1)
.addComponent(btnNewButton))
.addPreferredGap(ComponentPlacement.UNRELATED)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addComponent(btnNewButton_1)
.addComponent(classDescTxt))))
.addContainerGap(69, GroupLayout.PREFERRED_SIZE))
);
groupLayout.setVerticalGroup(
groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(56)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(lblNewLabel)
.addComponent(classNameTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(29)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addComponent(lblNewLabel_1)
.addComponent(classDescTxt, GroupLayout.PREFERRED_SIZE, 85, GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED, 29, Short.MAX_VALUE)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(snTxt)))
.addGap(26)
.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING, false)
.addGroup(gl_panel_1.createSequentialGroup()
.addComponent(label_3)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(manJrb)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(femaleJrb))
.addGroup(gl_panel_1.createSequentialGroup()
.addComponent(label_5)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(schoolClassJcb, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))))
.addContainerGap(86, Short.MAX_VALUE))))
);
gl_panel_1.setVerticalGroup(
gl_panel_1.createParallelGroup(Alignment.LEADING)
.addGroup(gl_panel_1.createSequentialGroup()
.addGap(21)
.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
.addComponent(lblNewLabel)
.addComponent(idTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(lblNewLabel_1)
.addComponent(nameTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_3)
.addComponent(manJrb)
.addComponent(femaleJrb))
.addGap(18)
.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
.addComponent(label_4)
.addComponent(deptTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(lblNewLabel_2)
.addComponent(snTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_5)
.addComponent(schoolClassJcb, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(18)
.addGroup(gl_panel_1.createParallelGroup(Alignment.LEADING)
.addComponent(label_6)
.addComponent(addressTxt, GroupLayout.PREFERRED_SIZE, 35, GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED, 20, Short.MAX_VALUE)
.addGroup(gl_panel_1.createParallelGroup(Alignment.BASELINE)
.addComponent(button_1)
.addComponent(button_2)))
);
panel_1.setLayout(gl_panel_1);
private DbUtil dbUtil=new DbUtil();
private SchoolClassDao schoolClassDao=new SchoolClassDao();
private StudentDao studentDao=new StudentDao();
/**
* Create the frame.
*/
public StudentAddInterFrm() {
setClosable(true);
setIconifiable(true);
setTitle("添加学生信息");
setBounds(100, 100, 450, 467);
JLabel label = new JLabel("学生姓名");
studentTxt = new JTextField();
studentTxt.setColumns(10);
JLabel label_1 = new JLabel("学生学号");
snTxt = new JTextField();
snTxt.setColumns(10);
JLabel label_2 = new JLabel("学生性别");
manJrb = new JRadioButton("男");
buttonGroup.add(manJrb);
manJrb.setSelected(true);
femaleJrb = new JRadioButton("女");
buttonGroup.add(femaleJrb);
JLabel label_3 = new JLabel("成绩分数");
deptTxt = new JTextField();
deptTxt.setColumns(10);
JLabel label_4 = new JLabel("家庭住址");
addressTxt = new JTextArea();
JLabel label_5 = new JLabel("所在班级");
schoolClassJcb = new JComboBox();
gradeTxt = new JTextField();
public class MainFrm extends JFrame {
private JPanel contentPane;
private JDesktopPane table =null;
/**
* Create the frame.
*/
public MainFrm() {
setTitle("学生信息管理系统主界面");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 450, 300);
JMenuBar menuBar = new JMenuBar();
setJMenuBar(menuBar);
JMenu mnNewMenu = new JMenu("基本数据维护");
mnNewMenu.setIcon(new ImageIcon(MainFrm.class.getResource("/images/base.png")));
menuBar.add(mnNewMenu);
JMenu mnNewMenu_1 = new JMenu("班级信息管理");
mnNewMenu_1.setIcon(new ImageIcon(MainFrm.class.getResource("/images/bookTypeManager.png")));
mnNewMenu.add(mnNewMenu_1);
JMenuItem menuItem = new JMenuItem("班级信息添加");
menuItem.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
SchoolClassAddInterFrm bookTypeAddInterFrm=new SchoolClassAddInterFrm();
bookTypeAddInterFrm.setVisible(true);
table.add(bookTypeAddInterFrm);
}
});
menuItem.setIcon(new ImageIcon(MainFrm.class.getResource("/images/add.png")));
mnNewMenu_1.add(menuItem);
JMenuItem menuItem_1 = new JMenuItem("班级信息整改");
menuItem_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
SchoolClassManageInterFrm bookTypeManageInterFrm=new SchoolClassManageInterFrm();
bookTypeManageInterFrm.setVisible(true);
table.add(bookTypeManageInterFrm);
}
});
menuItem_1.setIcon(new ImageIcon(MainFrm.class.getResource("/images/edit.png")));
});
button_1.setIcon(new ImageIcon(StudentAddInterFrm.class.getResource("/images/reset.png")));
GroupLayout groupLayout = new GroupLayout(getContentPane());
groupLayout.setHorizontalGroup(
groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(42)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addComponent(button)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(button_1)
.addGap(232))
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addComponent(label_5)
.addGroup(groupLayout.createSequentialGroup()
.addGroup(groupLayout.createParallelGroup(Alignment.TRAILING)
.addComponent(label_4)
.addComponent(label_2)
.addComponent(label))
.addPreferredGap(ComponentPlacement.RELATED)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING, false)
.addComponent(studentTxt, GroupLayout.PREFERRED_SIZE, 88, GroupLayout.PREFERRED_SIZE)
.addGroup(groupLayout.createSequentialGroup()
.addComponent(manJrb)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(femaleJrb))
.addComponent(schoolClassJcb, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(35)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING, false)
.addGroup(groupLayout.createSequentialGroup()
.addComponent(label_1)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(snTxt, GroupLayout.PREFERRED_SIZE, 91, GroupLayout.PREFERRED_SIZE))
.addGroup(groupLayout.createSequentialGroup()
.addComponent(label_3)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(deptTxt))))
.addComponent(studentTxt, GroupLayout.PREFERRED_SIZE, 188, GroupLayout.PREFERRED_SIZE)
.addComponent(addressTxt))
.addContainerGap(44, Short.MAX_VALUE)))))
);
groupLayout.setVerticalGroup(
groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(42)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(label)
.addComponent(studentTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(studentTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_1)
.addComponent(snTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(29)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(label_2)
.addComponent(manJrb)
.addComponent(femaleJrb)
.addComponent(label_3)
.addComponent(deptTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(33)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(label_5)
.addComponent(schoolClassJcb, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(30)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addComponent(label_4)
.addComponent(addressTxt, GroupLayout.PREFERRED_SIZE, 137, GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED, 37, Short.MAX_VALUE)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(button)
.addComponent(button_1))
.addGap(42))
// .addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
// .addComponent(label)
// .addComponent(gradeTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
// .addComponent(label_1)
// .addComponent(snTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
);
getContentPane().setLayout(groupLayout);
// 设置文本域边框
addressTxt.setBorder(new LineBorder(new java.awt.Color(127,157,185), 1, false));
fillBookType();
}
/**
* 重置事件处理
* @param e
*/
private void resetValueActionPerformed(ActionEvent e) {
this.resetValue();
}
/**
* 学生添加事件处理
* @param e
}
}
}
}
/**
* 班级信息修改事件处理
* @param evt
*/
private void schoolClassUpdateActionEvent(ActionEvent evt) {
String id=idTxt.getText();
String className=classNameTxt.getText();
String classDesc=classDescTxt.getText();
if(StringUtil.isEmpty(id)){
JOptionPane.showMessageDialog(null, "请选择要修改的记录");
return;
}
if(StringUtil.isEmpty(className)){
JOptionPane.showMessageDialog(null, "班级信息名称不能为空");
return;
}
SchoolClass bookType=new SchoolClass(Integer.parseInt(id),className,classDesc);
Connection con=null;
try{
con=dbUtil.getCon();
int modifyNum=schoolClassDao.update(con, bookType);
if(modifyNum==1){
JOptionPane.showMessageDialog(null, "修改成功");
this.resetValue();
this.fillTable(new SchoolClass());
}else{
JOptionPane.showMessageDialog(null, "修改失败");
}
}catch(Exception e){
e.printStackTrace();
JOptionPane.showMessageDialog(null, "修改失败");
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
int n=this.schoolClassJcb.getItemCount();
for(int i=0;i<n;i++){
SchoolClass item=(SchoolClass)this.schoolClassJcb.getItemAt(i);
if(item.getClassName().equals(className)){
this.schoolClassJcb.setSelectedIndex(i);
}
}
}
/**
* 学生信息查询事件处理
* @param e
*/
private void bookSearchActionPerformed(ActionEvent evt) {
String bookName=this.s_nameTxt.getText();
String author=this.s_snTxt.getText();
SchoolClass bookType=(SchoolClass) this.s_schoolClassJcb.getSelectedItem();
int bookTypeId=bookType.getId();
Student book=new Student(bookName,author,bookTypeId);
this.fillTable(book);
}
/**
* 初始化下拉框
* @param type 下拉框类型
*/
private void fillBookType(String type){
Connection con=null;
SchoolClass schoolClass=null;
try{
con=dbUtil.getCon();
ResultSet rs=schoolClassDao.list(con, new SchoolClass());
if("search".equals(type)){
schoolClass=new SchoolClass();
schoolClass.setClassName("请选择...");
schoolClass.setId(-1);
this.s_schoolClassJcb.addItem(schoolClass);
}
while(rs.next()){
schoolClass=new SchoolClass();
schoolClass.setClassName(rs.getString("className"));
schoolClass.setId(rs.getInt("id"));
if("search".equals(type)){
this.s_schoolClassJcb.addItem(schoolClass);
}else if("modify".equals(type)){
this.schoolClassJcb.addItem(schoolClass);
}
}
}catch(Exception e){
e.printStackTrace();
}finally{
.addComponent(femaleJrb))
.addComponent(schoolClassJcb, 0, GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(35)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING, false)
.addGroup(groupLayout.createSequentialGroup()
.addComponent(label_1)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(snTxt, GroupLayout.PREFERRED_SIZE, 91, GroupLayout.PREFERRED_SIZE))
.addGroup(groupLayout.createSequentialGroup()
.addComponent(label_3)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(deptTxt))))
.addComponent(studentTxt, GroupLayout.PREFERRED_SIZE, 188, GroupLayout.PREFERRED_SIZE)
.addComponent(addressTxt))
.addContainerGap(44, Short.MAX_VALUE)))))
);
groupLayout.setVerticalGroup(
groupLayout.createParallelGroup(Alignment.LEADING)
.addGroup(groupLayout.createSequentialGroup()
.addGap(42)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(label)
.addComponent(studentTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_1)
.addComponent(snTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(29)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(label_2)
.addComponent(manJrb)
.addComponent(femaleJrb)
.addComponent(label_3)
.addComponent(deptTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(33)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(label_5)
.addComponent(schoolClassJcb, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
.addGap(30)
.addGroup(groupLayout.createParallelGroup(Alignment.LEADING)
.addComponent(label_4)
.addComponent(addressTxt, GroupLayout.PREFERRED_SIZE, 137, GroupLayout.PREFERRED_SIZE))
.addPreferredGap(ComponentPlacement.RELATED, 37, Short.MAX_VALUE)
.addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
.addComponent(button)
.addComponent(button_1))
.addGap(42))
// .addGroup(groupLayout.createParallelGroup(Alignment.BASELINE)
// .addComponent(label)
// .addComponent(gradeTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
// .addComponent(label_1)
// .addComponent(snTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE))
);
getContentPane().setLayout(groupLayout);
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
bookSearchActionPerformed(e);
}
});
button.setIcon(new ImageIcon(StudentManageInterFrm.class.getResource("/images/search.png")));
GroupLayout gl_panel = new GroupLayout(panel);
gl_panel.setHorizontalGroup(
gl_panel.createParallelGroup(Alignment.LEADING)
.addGroup(gl_panel.createSequentialGroup()
.addGap(19)
.addComponent(label)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(s_nameTxt, GroupLayout.PREFERRED_SIZE, 77, GroupLayout.PREFERRED_SIZE)
.addGap(18)
.addComponent(label_1)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(s_snTxt, GroupLayout.PREFERRED_SIZE, 74, GroupLayout.PREFERRED_SIZE)
.addPreferredGap(ComponentPlacement.UNRELATED)
.addComponent(label_2)
.addPreferredGap(ComponentPlacement.RELATED)
.addComponent(s_schoolClassJcb, GroupLayout.PREFERRED_SIZE, 78, GroupLayout.PREFERRED_SIZE)
.addGap(18)
.addComponent(button)
.addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
gl_panel.setVerticalGroup(
gl_panel.createParallelGroup(Alignment.TRAILING)
.addGroup(gl_panel.createSequentialGroup()
.addContainerGap(GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(gl_panel.createParallelGroup(Alignment.BASELINE)
.addComponent(label)
.addComponent(s_nameTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_1)
.addComponent(s_snTxt, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(label_2)
.addComponent(s_schoolClassJcb, GroupLayout.PREFERRED_SIZE, GroupLayout.DEFAULT_SIZE, GroupLayout.PREFERRED_SIZE)
.addComponent(button))
.addGap(16))
);
panel.setLayout(gl_panel);
studentTable = new JTable();
studentTable.addMouseListener(new MouseAdapter() {
@Override
public void mousePressed(MouseEvent met) {
studentTableMousePressed(met);
}