📄 teacher.java
字号:
*/
private JButton getLookStudentjButton() {
if (lookStudentjButton == null) {
lookStudentjButton = new JButton();
lookStudentjButton.setBounds(new Rectangle(464, 28, 69, 19));
lookStudentjButton.setText("浏览");
lookStudentjButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
jScrollPane.setViewportView(getstudentmanagejTable(classNojTextField.getText()));
}
});
}
return lookStudentjButton;
}
/**
* This method initializes jScrollPane
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane() {
if (jScrollPane == null) {
jScrollPane = new JScrollPane();
jScrollPane.setBounds(new Rectangle(8, 30, 453, 350));
}
return jScrollPane;
}
/**
* This method initializes jTable2
*
* @return javax.swing.JTable
*/
private JTable getstudentmanagejTable(String classNo) {
studentmanagejTable =data.getStudentmassage(classNo);
studentmanagejTable.setEnabled(true);
studentmanagejTable.setRowSelectionAllowed(true);
studentmanagejTable.setShowVerticalLines(true);
studentmanagejTable.setShowHorizontalLines(true);
studentmanagejTable.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
int selectRows=studentmanagejTable.getSelectedRows().length; // 取得用户所选行的行数
DefaultTableModel tableModel = (DefaultTableModel) studentmanagejTable.getModel();
if(selectRows==1){
int selectedRowIndex = studentmanagejTable.getSelectedRow(); // 取得用户所选单行
// 用tableModel.getValueAt(row, column)取单元格数据
// int cell=studentmanagejTable.getColumnCount();
/* String studentmassage[]={"","","",""};
for(int i=0;cell>=i;i++)
{
studentmassage[i]=(String) tableModel.getValueAt(selectedRowIndex, i);
System.out.println(studentmassage[i]);
}*/
studentNojTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 0));
studentNamejTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 1));
studentClassjTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 2));
studentPasswordjTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 3));
}
}
});
return studentmanagejTable;
}
/**
* This method initializes StudentUpdatajButton
*
* @return javax.swing.JButton
*/
private JButton getStudentUpdatajButton() {
if (StudentUpdatajButton == null) {
StudentUpdatajButton = new JButton();
StudentUpdatajButton.setBounds(new Rectangle(583, 223, 73, 25));
StudentUpdatajButton.setText("更改");
StudentUpdatajButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
if(!studentNojTextField.getText().trim().equals(""))
{
String QueryString="update 学生表 set 姓名='"+studentNamejTextField.getText()+
"',"+"班级编号='"+studentClassjTextField.getText()+"',"
+"选课登陆密码='"+studentPasswordjTextField.getText()+"'"
+" where 学号='"+studentNojTextField.getText().trim()+"'";
data.updata(QueryString);
jScrollPane.setViewportView(getstudentmanagejTable(classNojTextField.getText()));//刷新
}
// TODO Auto-generated Event stub actionPerformed()
}
});
}
return StudentUpdatajButton;
}
/**
* This method initializes studentdeletejButton
*
* @return javax.swing.JButton
*/
private JButton getStudentdeletejButton() {
if (studentdeletejButton == null) {
studentdeletejButton = new JButton();
studentdeletejButton.setBounds(new Rectangle(665, 223, 78, 24));
studentdeletejButton.setText("删除");
studentdeletejButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
if(!studentNojTextField.getText().trim().equals(""))
{
String QueryString="delete 学生表 from 学生表 where 学号='"+studentNojTextField.getText().trim()+"'";
data.updata(QueryString);
jScrollPane.setViewportView(getstudentmanagejTable(classNojTextField.getText()));//刷新
studentNojTextField.setText("");
studentNamejTextField.setText("");
//studentClassjTextField.setText("");
studentPasswordjTextField.setText("");
}
}
});
}
return studentdeletejButton;
}
/**
* This method initializes addStudentjButton
*
* @return javax.swing.JButton
*/
private JButton getAddStudentjButton() {
if (addStudentjButton == null) {
addStudentjButton = new JButton();
addStudentjButton.setBounds(new Rectangle(507, 223, 66, 25));
addStudentjButton.setText("添加");
addStudentjButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
// TODO Auto-generated Event stub actionPerformed()
if(!studentNojTextField.isEnabled())
{
studentNojTextField.setEnabled(true);
studentNojTextField.setText("系统自动添加");
studentNamejTextField.setText("");
//studentClassjTextField.setText("");
studentPasswordjTextField.setText("");
}
else
{
jScrollPane.setViewportView(getstudentmanagejTable(classNojTextField.getText()));//刷新jTable列表
DefaultTableModel tableModel = (DefaultTableModel) studentmanagejTable.getModel();
int row=studentmanagejTable.getRowCount();
System.out.println(row);
String studentNo =(String) tableModel.getValueAt(row-1, 0);
int temp=Integer.parseInt(studentNo);
temp=temp+1;//新学生ID
studentNo="0"+Integer.toString(temp);
studentNojTextField.setText(studentNo);
String QueryString="insert into 学生表"+"(学号,姓名,班级编号,选课登陆密码)"+"values('"+studentNo+"','"
+studentNamejTextField.getText()+"','"+studentClassjTextField.getText()+"','"+studentPasswordjTextField.getText()+"')";
System.out.println(QueryString);
data.updata(QueryString);
jScrollPane.setViewportView(getstudentmanagejTable(classNojTextField.getText()));//刷新列表
studentNojTextField.setEnabled(false);
}
}
});
}
return addStudentjButton;
}
/**
* This method initializes studentNojTextField
*
* @return javax.swing.JTextField
*/
private JTextField getStudentNojTextField() {
if (studentNojTextField == null) {
studentNojTextField = new JTextField();
studentNojTextField.setBounds(new Rectangle(548, 82, 64, 22));
studentNojTextField.setEnabled(false);
}
return studentNojTextField;
}
/**
* This method initializes studentNamejTextField
*
* @return javax.swing.JTextField
*/
private JTextField getStudentNamejTextField() {
if (studentNamejTextField == null) {
studentNamejTextField = new JTextField();
studentNamejTextField.setBounds(new Rectangle(548, 111, 110, 22));
}
return studentNamejTextField;
}
/**
* This method initializes studentClassjTextField
*
* @return javax.swing.JTextField
*/
private JTextField getStudentClassjTextField() {
if (studentClassjTextField == null) {
studentClassjTextField = new JTextField();
studentClassjTextField.setBounds(new Rectangle(548, 141, 136, 22));
studentClassjTextField.setText("078021");
}
return studentClassjTextField;
}
/**
* This method initializes studentPasswordjTextField
*
* @return javax.swing.JTextField
*/
private JTextField getStudentPasswordjTextField() {
if (studentPasswordjTextField == null) {
studentPasswordjTextField = new JTextField();
studentPasswordjTextField.setBounds(new Rectangle(548, 170, 178, 22));
}
return studentPasswordjTextField;
}
/**
* This method initializes courseManagejPanel
*
* @return javax.swing.JPanel
*/
private Panel getCourseManagejPanel() {
if (courseManagejPanel == null) {
jLabel23 = new JLabel();
jLabel23.setBounds(new Rectangle(12, 4, 121, 35));
jLabel23.setFont(new Font("Monospaced", Font.BOLD, 24));
jLabel23.setText("开课管理");
jLabel22 = new JLabel();
jLabel22.setBounds(new Rectangle(504, 7, 93, 18));
jLabel22.setText("开课列表");
jLabel13 = new JLabel();
jLabel13.setBounds(new Rectangle(130, 183, 55, 18));
jLabel13.setText("限选人数");
jLabel12 = new JLabel();
jLabel12.setBounds(new Rectangle(16, 303, 53, 18));
jLabel12.setText("上课时间");
jLabel11 = new JLabel();
jLabel11.setBounds(new Rectangle(15, 267, 56, 18));
jLabel11.setText("系部编号");
jLabel10 = new JLabel();
jLabel10.setBounds(new Rectangle(18, 225, 38, 18));
jLabel10.setText("老师");
jLabel9 = new JLabel();
jLabel9.setBounds(new Rectangle(18, 182, 38, 18));
jLabel9.setText("学分");
jLabel8 = new JLabel();
jLabel8.setBounds(new Rectangle(16, 149, 58, 18));
jLabel8.setText("课程类型");
jLabel7 = new JLabel();
jLabel7.setBounds(new Rectangle(17, 110, 50, 18));
jLabel7.setText("课程名");
jLabel6 = new JLabel();
jLabel6.setBounds(new Rectangle(16, 74, 53, 18));
jLabel6.setText("课程编号");
courseManagejPanel = new Panel();
courseManagejPanel.setLayout(null);
courseManagejPanel.setBounds(new Rectangle(0, 37, 750, 392));
courseManagejPanel.add(getCourseManagejScrollPane1(), null);
courseManagejPanel.add(getLookcoursejButton(), null);
courseManagejPanel.add(getCourseNojTextField(), null);
courseManagejPanel.add(getCourseNamejTextField(), null);
courseManagejPanel.add(getCourseTypejTextField(), null);
courseManagejPanel.add(getCourseCreditjTextField(), null);
courseManagejPanel.add(getCourseTeacherjTextField(), null);
courseManagejPanel.add(getCourseXibujTextField(), null);
courseManagejPanel.add(getCourseTimejTextField(), null);
courseManagejPanel.add(getCourseRestrictPeoplejTextField(), null);
courseManagejPanel.add(jLabel6, null);
courseManagejPanel.add(jLabel7, null);
courseManagejPanel.add(jLabel8, null);
courseManagejPanel.add(jLabel9, null);
courseManagejPanel.add(jLabel10, null);
courseManagejPanel.add(jLabel11, null);
courseManagejPanel.add(jLabel12, null);
courseManagejPanel.add(jLabel13, null);
courseManagejPanel.add(getCourseAddjButton(), null);
courseManagejPanel.add(getCourseUpdatejButton(), null);
courseManagejPanel.add(getCourseDeletejButton(), null);
courseManagejPanel.add(jLabel22, null);
courseManagejPanel.add(jLabel23, null);
}
return courseManagejPanel;
}
/**
* This method initializes courseManagejScrollPane1
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getCourseManagejScrollPane1() {
if (courseManagejScrollPane1 == null) {
courseManagejScrollPane1 = new JScrollPane();
courseManagejScrollPane1.setBounds(new Rectangle(286, 26, 454, 349));
//courseManagejScrollPane1.setViewportView(getCourseManagejTable());
}
return courseManagejScrollPane1;
}
/**
* This method initializes courseManagejTable
*
* @return javax.swing.JTable
*/
private JTable getCourseManagejTable() {
courseManagejTable =data.getCourseMassage();
courseManagejTable.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
int selectRows=courseManagejTable.getSelectedRows().length; // 取得用户所选行的行数
DefaultTableModel tableModel = (DefaultTableModel) courseManagejTable.getModel();
if(selectRows==1){
int selectedRowIndex = courseManagejTable.getSelectedRow(); // 取得用户所选单行
courseNojTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 0));
courseNamejTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 1));
courseTypejTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 2));
courseCreditjTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 3));
courseTeacherjTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 4));
courseXibujTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 5));
courseTimejTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 6));
courseRestrictPeoplejTextField.setText((String) tableModel.getValueAt(selectedRowIndex, 7));
}
}
});
return courseManagejTable;
}
/**
* This method initializes lookcoursejButton
*
* @return javax.swing.JButton
*/
private JButton getLookcoursejButton() {
if (lookcoursejButton == null) {
lookcoursejButton = new JButton();
lookcoursejButton.setBounds(new Rectangle(217, 25, 67, 23));
lookcoursejButton.setText("浏览");
lookcoursejButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
courseManagejScrollPane1.setViewportView(getCourseManagejTable()); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return lookcoursejButton;
}
/**
* This method initializes courseNojTextField
*
* @return javax.swing.JTextField
*/
private JTextField getCourseNojTextField() {
if (courseNojTextField == null) {
courseNojTextField = new JTextField();
courseNojTextField.setBounds(new Rectangle(75, 72, 87, 22));
courseNojTextField.setEnabled(false);
}
return courseNojTextField;
}
/**
* This method initializes courseNamejTextField
*
* @return javax.swing.JTextField
*/
private JTextField getCourseNamejTextField() {
if (courseNamejTextField == null) {
courseNamejTextField = new JTextField();
courseNamejTextField.setBounds(new Rectangle(79, 108, 153, 22));
}
return courseNamejTextField;
}
/**
* This method initializes courseTypejTextField
*
* @return javax.swing.JTextField
*/
private JTextField getCourseTypejTextField() {
if (courseTypejTextField == null) {
courseTypejTextField = new JTextField();
courseTypejTextField.setBounds(new Rectangle(77, 147, 59, 22));
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -