📄 classinfo.java
字号:
package xiangmu;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import javax.swing.table.JTableHeader;
import javax.swing.border.EtchedBorder;
import javax.swing.border.Border;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;
import java.awt.event.MouseEvent;
import java.awt.event.MouseMotionAdapter;
import java.awt.event.MouseAdapter;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;
/**
* <p>Title: 第四学习小组-教学管理系统</p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class ClassInfo extends JFrame {
public static String userType="";
String cols[]={" 班级编号"," 班级类别"," 所属年级"," 班主任"," 开班日期"," 毕业日期"," 备 注"};
DefaultTableModel bg=new DefaultTableModel(cols,0);
public ClassInfo() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setResizable(false);
this.addWindowListener(new ClassInfo_this_windowAdapter(this));
getContentPane().setLayout(null);
btnDel.setBounds(new Rectangle(481, 12, 80, 29));
btnDel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnDel.setText("删 除");
btnDel.addActionListener(new ClassInfo_btnDel_actionAdapter(this));
btnEdit.setBounds(new Rectangle(382, 12, 80, 29));
btnEdit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnEdit.setText("修 改");
btnEdit.addActionListener(new ClassInfo_btnEdit_actionAdapter(this));
btnAdd.setBounds(new Rectangle(279, 12, 80, 29));
btnAdd.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnAdd.setText("添 加");
btnAdd.addActionListener(new ClassInfo_btnAdd_actionAdapter(this));
btnExit.setBounds(new Rectangle(581, 12, 80, 29));
btnExit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnExit.setText("退 出");
btnExit.addActionListener(new ClassInfo_btnExit_actionAdapter(this));
jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
jScrollPane1.setBounds(new Rectangle(6, 50, 673, 141));
jScrollPane1.addMouseMotionListener(new
ClassInfo_jScrollPane1_mouseMotionAdapter(this));
jLabel2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel2.setText("班级编号：");
jLabel2.setBounds(new Rectangle(36, 211, 85, 26));
txtClassNo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtClassNo.setBounds(new Rectangle(135, 208, 130, 28));
jLabel3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel3.setText("班级类别：");
jLabel3.setBounds(new Rectangle(422, 214, 80, 20));
jLabel4.setFont(new java.awt.Font("仿宋_GB2312", Font.BOLD, 15));
jLabel4.setText("班 主 任：");
jLabel4.setBounds(new Rectangle(422, 265, 84, 26));
jLabel5.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel5.setText("开学日期：");
jLabel5.setBounds(new Rectangle(36, 316, 85, 21));
txtMaster.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtMaster.setBounds(new Rectangle(519, 263, 130, 28));
jLabel6.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel6.setText("所属年级：");
jLabel6.setBounds(new Rectangle(36, 266, 92, 21));
txtBeginDate.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtBeginDate.setBounds(new Rectangle(135, 314, 130, 28));
jLabel7.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel7.setText("毕业日期：");
jLabel7.setBounds(new Rectangle(422, 317, 85, 20));
txtEndDate.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtEndDate.setBounds(new Rectangle(519, 314, 130, 28));
jLabel8.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel8.setText("备 注：");
jLabel8.setBounds(new Rectangle(35, 365, 96, 15));
txaRemark.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
txaRemark.setBorder(border1);
txaRemark.setBounds(new Rectangle(135, 359, 514, 70));
bntjiansuo.setBounds(new Rectangle(74, 12, 81, 29));
bntjiansuo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
bntjiansuo.setText("检 索");
bntjiansuo.addActionListener(new ClassInfo_bntjiansuo_actionAdapter(this));
btnshuaxin.setBounds(new Rectangle(177, 12, 81, 29));
btnshuaxin.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnshuaxin.setText("刷 新");
btnshuaxin.addActionListener(new ClassInfo_btnshuaxin_actionAdapter(this));
jTable1.addMouseMotionListener(new ClassInfo_jTable1_mouseMotionAdapter(this));
jTable1.addMouseListener(new ClassInfo_jTable1_mouseAdapter(this));
cmbTerm.setBounds(new Rectangle(135, 262, 130, 29));
cmbType.setBounds(new Rectangle(519, 208, 130, 29));
this.getContentPane().add(jScrollPane1);
this.getContentPane().add(txaRemark);
this.getContentPane().add(txtEndDate);
this.getContentPane().add(txtMaster);
this.getContentPane().add(cmbType);
this.getContentPane().add(txtBeginDate);
this.getContentPane().add(cmbTerm);
this.getContentPane().add(txtClassNo);
this.getContentPane().add(jLabel2);
this.getContentPane().add(jLabel5);
this.getContentPane().add(jLabel6);
this.getContentPane().add(jLabel8);
this.getContentPane().add(btnExit);
this.getContentPane().add(btnDel);
this.getContentPane().add(btnEdit);
this.getContentPane().add(btnAdd);
this.getContentPane().add(btnshuaxin);
this.getContentPane().add(bntjiansuo);
this.getContentPane().add(jLabel7);
this.getContentPane().add(jLabel4);
this.getContentPane().add(jLabel3);
jScrollPane1.getViewport().add(jTable1);
jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
VERTICAL_SCROLLBAR_ALWAYS);
setTitle("教学管理系统—班级信息");
}
JButton btnAdd = new JButton();
JButton btnEdit = new JButton();
JButton btnDel = new JButton();
JButton btnExit = new JButton();
Border border1 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
Color.white, new Color(170, 170, 170));
Border border2 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
Color.white, new Color(170, 170, 170));
JScrollPane jScrollPane1 = new JScrollPane();
JTable jTable1 = new JTable(bg);
String term[]={"S1","S2","Y2"};
JLabel jLabel2 = new JLabel();
JTextField txtClassNo = new JTextField();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JTextField txtMaster = new JTextField();
JLabel jLabel6 = new JLabel();
JTextField txtBeginDate = new JTextField();
JLabel jLabel7 = new JLabel();
JTextField txtEndDate = new JTextField();
JLabel jLabel8 = new JLabel();
JTextArea txaRemark = new JTextArea();
JButton bntjiansuo = new JButton();
JButton btnshuaxin = new JButton();
String Semester[] = {"", "S1", "S2", "Y2"};
JComboBox cmbTerm = new JComboBox(Semester);
String category[] = {"", "脱产班", "周末班"};
JComboBox cmbType = new JComboBox(category);
public void btnExit_actionPerformed(ActionEvent e) {
if (JOptionPane.showConfirmDialog(this, "是否确定退出班级信息", "温馨提示",
JOptionPane.OK_CANCEL_OPTION) ==
JOptionPane.OK_OPTION) {
Dimension screenSize = Toolkit.getDefaultToolkit().
getScreenSize();
this.dispose();
}
}
public void btnAdd_actionPerformed(ActionEvent e) {
try {
if(this.txtClassNo.getText().length()==0){
JOptionPane.showMessageDialog(this,"请输入班级编号！");
return;
}
if(this.cmbType.getSelectedItem().toString().length()==0){
JOptionPane.showMessageDialog(this,"请输入班级类别！");
return;
}
if(this.cmbTerm.getSelectedItem().toString().length()==0){
JOptionPane.showMessageDialog(this,"请输入所属年级！");
return;
}
if(this.txtMaster.getText().length()==0){
JOptionPane.showMessageDialog(this,"请输入班主任姓名！");
return;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动程序
Connection conn=DriverManager.getConnection("jdbc:odbc:xiangmu");//注册驱动并连接数据库
PreparedStatement ps=conn.prepareStatement("insert into ClassInfo (ClassNo,ClassType,Term,Master,BeginDate,EndDate,Remark) values(?,?,?,?,?,?,?)");//创建执行语句的对象
ps.setString(1,this.txtClassNo.getText());
ps.setString(2,this.cmbType.getSelectedItem().toString());
ps.setString(3,this.cmbTerm.getSelectedItem().toString());
ps.setString(4,this.txtMaster.getText());
ps.setString(5,this.txtBeginDate.getText());
ps.setString(6,this.txtEndDate.getText());
ps.setString(7,this.txaRemark.getText());
//ps.setFloat(4,Float.parseFloat(this.txtjiege.getText()));
int rows= ps.executeUpdate();//执行语句,返回受影响行数
if(rows>0){//判断是否执行成功
Object val[]={this.txtClassNo.getText(), this.cmbType.getSelectedItem().toString(),
this.cmbTerm.getSelectedItem().toString(),this.txtMaster.getText(),this.txtBeginDate.getText(),this.txtEndDate.getText(),this.txaRemark.getText(),};
bg.addRow(val);//在tbData分别添加值
JOptionPane.showMessageDialog(this,"添加成功！");
}else{
JOptionPane.showMessageDialog(this,"添加失败！");
}
ps.close();//关闭已打开的资源
conn.close();//关闭已打开的资源
} catch (Exception ex) {
JOptionPane.showMessageDialog(this,"添加失败！");
}
}
public void btnDel_actionPerformed(ActionEvent e) {
try {
int row = this.jTable1.getSelectedRow();
if (JOptionPane.showConfirmDialog(this, "你确定删除吗?", "删除提示",
JOptionPane.OK_CANCEL_OPTION) ==
JOptionPane.OK_OPTION) {
if (row < 0) {
JOptionPane.showMessageDialog(this, "请选择数据");
return;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection nod = DriverManager.getConnection(
"jdbc:odbc:xiangmu");
PreparedStatement sql = nod.prepareStatement(
"delete from ClassInfo where ClassNo = ?");
sql.setString(1, this.jTable1.getValueAt(row, 0).toString());
int i = sql.executeUpdate();
if (i > 0) {
bg.removeRow(row);
JOptionPane.showMessageDialog(this, "删除成功");
} else {
JOptionPane.showMessageDialog(this, "删除失败");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -