📄 set_classes.java
字号:
/*
* @author 黎龙飞 , 创建日期 2008-5-19
*
* Blog : http://lilongfei1030.blog.163.com
*/
package stu.view;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.border.TitledBorder;
import javax.swing.table.TableModel;
import stu.util.ConnectDatabase;
import stu.util.getResults;
public class Set_classes extends JFrame {
private JTable table;
private JTextField textField_3;
private JTextField textField_2;
private JTextField textField_1;
private JTextField textField;
final JScrollPane scrollPane = new JScrollPane();
private static final long serialVersionUID = 5135526258914557696L;
public Set_classes() {
super();
setTitle("班级信息设置");
getContentPane().setFont(new Font("宋体", Font.PLAIN, 12));
getContentPane().setLayout(null);
setBounds(100, 100, 488, 337);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setResizable(false);
final Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
final Dimension my = this.getSize();
setLocationByPlatform(true);
setLocation((screen.width - my.width) / 2,
(screen.height - my.height) / 2);
setVisible(true);
final JLabel label = new JLabel();
label.setFont(new Font("宋体", Font.PLAIN, 14));
label.setText("班级编号:");
label.setBounds(33, 46, 63, 22);
getContentPane().add(label);
final JLabel label_1 = new JLabel();
label_1.setFont(new Font("", Font.PLAIN, 14));
label_1.setText("班级名称:");
label_1.setBounds(33, 92, 66, 18);
getContentPane().add(label_1);
final JLabel label_2 = new JLabel();
label_2.setFont(new Font("", Font.PLAIN, 14));
label_2.setText("专业名称:");
label_2.setBounds(33, 141, 66, 18);
getContentPane().add(label_2);
textField = new JTextField();
textField.setBounds(105, 47, 90, 22);
getContentPane().add(textField);
textField_1 = new JTextField();
textField_1.setBounds(105, 91, 90, 22);
getContentPane().add(textField_1);
textField_2 = new JTextField();
textField_2.setBounds(105, 140, 90, 22);
getContentPane().add(textField_2);
final JLabel label_3 = new JLabel();
label_3.setFont(new Font("", Font.PLAIN, 14));
label_3.setText("所属院系:");
label_3.setBounds(33, 190, 66, 19);
getContentPane().add(label_3);
textField_3 = new JTextField();
textField_3.setBounds(105, 189, 90, 22);
getContentPane().add(textField_3);
scrollPane.setBorder(new TitledBorder(null, "班级信息设置",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null));
scrollPane.setBounds(219, 10, 240, 225);
getContentPane().add(scrollPane);
String sql = "select * from 班级表";
TableModel tableModel;
try {
tableModel = new getResults().Results(sql);
table = new JTable(tableModel);
scrollPane.setViewportView(table);
table.setSelectionForeground(Color.RED);
} catch (Exception e3) {
//e3.printStackTrace();
}
table.addMouseListener(new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
int currow = table.getSelectedRow();
textField.setText((String) table.getValueAt(currow, 0));
textField_1.setText((String) table.getValueAt(currow, 1));
textField_2.setText((String) table.getValueAt(currow, 2));
textField_3.setText((String) table.getValueAt(currow, 3));
}
});
/*System.out.println("行数: " + table.getRowCount() + " 列数: "
+ table.getColumnCount());
System.out.println("表中共有: " + table.getRowCount() + " 条记录");*/
final JButton button = new JButton();
button.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
String sql = "delete from 班级表 where 班级号='"
+ textField.getText().trim() + "'and 班级名='"+textField_1.getText().trim()+"'";
String sql2="delete from 授课关系表 where 班级名='"+textField_1.getText().trim()+"'";
String sql3="delete from 学生表 where 班级名='"+textField_1.getText().trim()+"'";
String sql4="delete from 考勤表 where 班级名='"+textField_1.getText().trim()+"'";
String sql5="delete from 成绩表 where 成绩表.学号=(select 成绩表.学号 from 学生表,成绩表 where 学生表.学号=成绩表.学号 and 班级名='"+textField_1.getText().trim()+"')";
Connection con = new ConnectDatabase().getResultString();
int result = JOptionPane.showOptionDialog(null, "是否删除班级设置信息?",
"系统提示", JOptionPane.YES_NO_OPTION,
JOptionPane.QUESTION_MESSAGE, null, new String[] { "是",
"否" }, "否");
if (result == JOptionPane.OK_OPTION) {
try {
con.createStatement().execute(sql);
con.createStatement().execute(sql2);
con.createStatement().execute(sql3);
con.createStatement().execute(sql4);
con.createStatement().execute(sql5);
//System.out.println("sql = " + sql);
String infoStr = "删除";
if (textField.getText().trim().equals(""))
JOptionPane.showMessageDialog(null, "没有你要"
+ infoStr + "的数据!!!", "系统提示",
JOptionPane.INFORMATION_MESSAGE);
else
JOptionPane.showMessageDialog(null, infoStr
+ "数据成功!!!", "系统提示",
JOptionPane.INFORMATION_MESSAGE);
flash();
} catch (SQLException e1) {
e1.printStackTrace();
}
} else {
}
}
});
button.setText("删除");
button.setBounds(125, 256, 63, 28);
getContentPane().add(button);
final JButton button_1 = new JButton();
button_1.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
String Class_id = textField.getText();
String Class_name = textField_1.getText();
String Professional = textField_2.getText();
String Department = textField_3.getText();
if(Class_id.equals("")) JOptionPane.showMessageDialog(null, "请输入班级编号!","系统提示",JOptionPane.WARNING_MESSAGE);
else if(Class_name.equals(""))JOptionPane.showMessageDialog(null, "请输入班级名!","系统提示",JOptionPane.WARNING_MESSAGE);
else if(Professional.equals(""))JOptionPane.showMessageDialog(null, "请输入专业名称!","系统提示",JOptionPane.WARNING_MESSAGE);
else if(Department.equals(""))JOptionPane.showMessageDialog(null, "请输入院系名称!","系统提示",JOptionPane.WARNING_MESSAGE);
else{
String sql = "insert into 班级表 values ( '" + Class_id.trim()
+ "','" + Class_name.trim() + "','"
+ Professional.trim() + "','" + Department.trim()
+ "')";
boolean flag = true;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager
.getConnection("jdbc:odbc:DB_Student");
Statement stm = con.createStatement();
try {
stm.executeUpdate(sql);
} catch (SQLException e1) {
JOptionPane.showMessageDialog(null, "数据已经存在!!!",
"系统提示", JOptionPane.WARNING_MESSAGE);
flag = false;
}
if (flag)
JOptionPane.showMessageDialog(null, "添加数据成功!!!",
"系统提示", JOptionPane.INFORMATION_MESSAGE);
flash();
} catch (Exception e1) {
}
}
}
});
button_1.setText("添加");
button_1.setBounds(207, 256, 63, 28);
getContentPane().add(button_1);
final JButton button_2 = new JButton();
button_2.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
dispose();
}
});
button_2.setText("退出");
button_2.setBounds(369, 256, 66, 28);
getContentPane().add(button_2);
final JLabel label_4 = new JLabel();
label_4.setBorder(new TitledBorder(null, "新建班级",
TitledBorder.DEFAULT_JUSTIFICATION,
TitledBorder.DEFAULT_POSITION, null, null));
label_4.setBounds(21, 10, 192, 225);
getContentPane().add(label_4);
final JButton button_3 = new JButton();
button_3.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
flash();
}
});
button_3.setText("刷新");
button_3.setBounds(44, 256, 63, 28);
getContentPane().add(button_3);
final JButton button_4 = new JButton();
button_4.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
int result = JOptionPane.showOptionDialog(null, "是否存盘班级设置信息?",
"系统提示", JOptionPane.YES_NO_OPTION,
JOptionPane.QUESTION_MESSAGE, null, new String[] { "是",
"否" }, "否");
if (result == JOptionPane.OK_OPTION) {
String sql = "update 班级表 set 班级名='"
+ textField_1.getText().trim() + "',专业='"
+ textField_2.getText().trim() + "',院系='"
+ textField_3.getText().trim() + "' where 班级号='"
+ textField.getText().trim() + "'";
//System.out.println(sql);
Connection con = new ConnectDatabase().getResultString();
try {
Statement stm = con.createStatement();
stm.executeUpdate(sql);
// / stm.executeUpdate(sql1);
//System.out.println("sql = " + sql);
JOptionPane.showMessageDialog(null, "数据存盘成功!!!",
"系统提示", JOptionPane.INFORMATION_MESSAGE);
flash();
} catch (SQLException e2) {
JOptionPane.showMessageDialog(null, "数据存盘失败!!!",
"系统提示", JOptionPane.ERROR_MESSAGE);
//e2.printStackTrace();
}
} else {
}
}
});
button_4.setText("存盘");
button_4.setBounds(291, 256, 60, 28);
getContentPane().add(button_4);
//
}
public void flash() {
textField.setText("");
textField_1.setText("");
textField_2.setText("");
textField_3.setText("");
TableModel tableModel;
try {
tableModel = new getResults().Results("select * from 班级表");
table = new JTable(tableModel);
scrollPane.setViewportView(table);
table.setSelectionForeground(Color.RED);
table.addMouseListener(new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
int currow = table.getSelectedRow();
textField.setText((String) table.getValueAt(currow, 0));
textField_1.setText((String) table.getValueAt(currow, 1));
textField_2.setText((String) table.getValueAt(currow, 2));
textField_3.setText((String) table.getValueAt(currow, 3));
}
});
} catch (Exception e1) {
//e1.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -