📄 userguanli.java
字号:
package xiangmu;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.border.TitledBorder;
import javax.swing.border.Border;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.Dimension;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Vector;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;
import java.util.Date;
import java.text.SimpleDateFormat;
/**
* <p>Title: 第四学习小组-教学管理系统</p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class Userguanli extends JFrame {
public static String userType="";
String cols[] = {" 用户名", " 密 码"," 用户类型", " 注册日期", " 注销日期", " 状 态",
" 备 注"};
DefaultTableModel bg = new DefaultTableModel(cols, 0);
public Userguanli() {
try {
jbInit();
try {
String sql = "select UserName,Password,UserType,registerDate,logoutDate,Status,remark from SysUser where 1=1 ";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(
"jdbc:odbc:xiangmu");
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
bg.setRowCount(0);
while (rs.next()) {
Object val[] = {rs.getString(1), rs.getString(2),
rs.getString(3), rs.getString(4),
rs.getString(5), rs.getString(6),
rs.getString(7)};
bg.addRow(val);
}
jTable1.updateUI();
rs.close();
ps.close();
conn.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, "查询失败！");
}
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setResizable(false);
getContentPane().setLayout(null);
setSize(new Dimension(684, 440));
this.addWindowListener(new Userguanli_this_windowAdapter(this));
jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
jScrollPane1.setBounds(new Rectangle(9, 0, 668, 133));
btnNew.setBounds(new Rectangle(22, 143, 90, 30));
btnNew.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnNew.setText("新 增");
btnNew.addActionListener(new Userguanli_btnNew_actionAdapter(this));
btnEdit.setBounds(new Rectangle(298, 143, 90, 30));
btnEdit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnEdit.setText("修 改");
btnEdit.addActionListener(new Userguanli_btnEdit_actionAdapter(this));
btnDel.setBounds(new Rectangle(440, 143, 90, 30));
btnDel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnDel.setText("删 除");
btnDel.addActionListener(new Userguanli_btnDel_actionAdapter(this));
btnExit.setBounds(new Rectangle(570, 143, 90, 30));
btnExit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnExit.setText("关 闭");
btnExit.addActionListener(new Userguanli_btnExit_actionAdapter(this));
jLabel1.setFont(new java.awt.Font("楷体_GB2312", Font.PLAIN, 15));
jLabel1.setForeground(Color.gray);
jLabel1.setBorder(BorderFactory.createEtchedBorder());
jLabel1.setBounds(new Rectangle(13, 170, 4, 4));
jLabel2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel2.setText("用 户 名：");
jLabel2.setBounds(new Rectangle(21, 194, 84, 25));
jLabel3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel3.setText("密 码：");
jLabel3.setBounds(new Rectangle(429, 193, 92, 29));
jLabel4.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel4.setText("用户类型：");
jLabel4.setBounds(new Rectangle(22, 242, 91, 29));
jLabel5.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel5.setText("注册日期：");
jLabel5.setBounds(new Rectangle(429, 246, 93, 21));
jLabel6.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel6.setText("注销日期：");
jLabel6.setBounds(new Rectangle(22, 291, 86, 24));
jLabel7.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel7.setText("状 态：");
jLabel7.setBounds(new Rectangle(429, 290, 87, 23));
jLabel8.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel8.setText("备 注：");
jLabel8.setBounds(new Rectangle(22, 337, 88, 28));
txtUserName.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtUserName.setBounds(new Rectangle(122, 190, 130, 30));
txtUserName.addActionListener(new Userguanli_jTextField1_actionAdapter(this));
txtzhuxiaoDate.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtzhuxiaoDate.setBounds(new Rectangle(122, 285, 130, 30));
txtzhuceDate.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtzhuceDate.setBorder(BorderFactory.createEtchedBorder());
txtzhuceDate.setBounds(new Rectangle(535, 239, 130, 30));
cmbUserType.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
cmbUserType.setBorder(null);
cmbUserType.setBounds(new Rectangle(122, 239, 130, 30));
cmbstatus.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
cmbstatus.setBorder(null);
cmbstatus.setBounds(new Rectangle(535, 286, 130, 30));
cmbstatus.addActionListener(new Userguanli_cmbstatus_actionAdapter(this));
txtPassword.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
txtPassword.setBounds(new Rectangle(535, 190, 130, 30));
txaRemark.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
txaRemark.setBorder(BorderFactory.createEtchedBorder());
txaRemark.setBounds(new Rectangle(123, 341, 537, 86));
jTable1.addMouseListener(new Userguanli_jTable1_mouseAdapter(this));
btnshuaxin.setBounds(new Rectangle(160, 143, 90, 30));
btnshuaxin.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnshuaxin.setText("刷 新");
btnshuaxin.addActionListener(new Userguanli_btnshuaxin_actionAdapter(this));
jPanel1.setBackground(UIManager.getColor("CheckBox.light"));
jPanel1.setBorder(BorderFactory.createEtchedBorder());
jPanel1.setBounds(new Rectangle(9, 182, 668, 254));
this.getContentPane().add(jScrollPane1);
this.getContentPane().add(jLabel1);
this.getContentPane().add(jLabel8);
this.getContentPane().add(txaRemark);
this.getContentPane().add(jLabel6);
this.getContentPane().add(jLabel4);
this.getContentPane().add(jLabel2);
this.getContentPane().add(txtzhuxiaoDate);
this.getContentPane().add(cmbUserType);
this.getContentPane().add(txtUserName);
this.getContentPane().add(txtPassword);
this.getContentPane().add(jLabel3);
this.getContentPane().add(txtzhuceDate);
this.getContentPane().add(jLabel5);
this.getContentPane().add(cmbstatus);
this.getContentPane().add(jLabel7);
this.getContentPane().add(jPanel1);
this.getContentPane().add(btnNew);
this.getContentPane().add(btnshuaxin);
this.getContentPane().add(btnEdit);
this.getContentPane().add(btnDel);
this.getContentPane().add(btnExit);
jScrollPane1.getViewport().add(jTable1);
jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
VERTICAL_SCROLLBAR_ALWAYS);
setTitle("教学管理系统-系统管理");
}
JScrollPane jScrollPane1 = new JScrollPane();
JTable jTable1 = new JTable(bg);
JButton btnNew = new JButton();
JButton btnEdit = new JButton();
JButton btnDel = new JButton();
JButton btnExit = new JButton();
JLabel jLabel1 = new JLabel();
TitledBorder titledBorder1 = new TitledBorder("");
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
Border border1 = BorderFactory.createEmptyBorder();
JLabel jLabel8 = new JLabel();
JTextField txtUserName = new JTextField();
JTextField txtzhuxiaoDate = new JTextField();
JTextField txtzhuceDate = new JTextField();
String usertype[] = {"", "系统管理员", "普通用户"};
JComboBox cmbUserType = new JComboBox(usertype);
String status[] = {"", "在线", "离线"};
JComboBox cmbstatus = new JComboBox(status);
TitledBorder titledBorder2 = new TitledBorder("");
JPasswordField txtPassword = new JPasswordField();
JTextArea txaRemark = new JTextArea();
JButton btnshuaxin = new JButton();
JPanel jPanel1 = new JPanel();
public void wangba() {
try {
} catch (Exception ex) {
}
}
public void jTextField1_actionPerformed(ActionEvent e) {
}
public void cmbstatus_actionPerformed(ActionEvent e) {
}
public void btnEdit_actionPerformed(ActionEvent e) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //加载驱动程序
Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu"); //注册驱动并连接数据库
PreparedStatement ps = conn.prepareStatement(
"update SysUser set UserName=?,Password=?,UserType=?,registerDate=?,logoutDate=?,Status=?,remark=? where UserName=?"); //创建执行语句的对象
int selRow = jTable1.getSelectedRow();
ps.setString(2, String.valueOf(this.txtPassword.getPassword()));
ps.setString(1, this.txtUserName.getText());
ps.setString(3, this.cmbUserType.getSelectedItem().toString());
ps.setString(4, this.txtzhuceDate.getText());
ps.setString(5, this.txtzhuxiaoDate.getText());
ps.setString(6, this.cmbstatus.getSelectedItem().toString());
ps.setString(7, this.txaRemark.getText());
ps.setString(8, jTable1.getValueAt(selRow, 0).toString());
int rows = ps.executeUpdate(); //执行语句,返回受影响行数
if (rows > 0) {
jTable1.setValueAt(String.valueOf(this.txtPassword.getPassword()),
selRow, 1);
jTable1.setValueAt(this.txtUserName.getText(), selRow, 0);
jTable1.setValueAt(this.cmbUserType.getSelectedItem().toString(),
selRow, 2);
jTable1.setValueAt(this.txtzhuceDate.getText(), selRow, 3);
jTable1.setValueAt(this.txtzhuxiaoDate.getText(), selRow, 4);
jTable1.setValueAt(this.cmbstatus.getSelectedItem().toString(),
selRow, 5);
jTable1.setValueAt(this.txaRemark.getText(), selRow, 6);
JOptionPane.showMessageDialog(this, "修改成功！");
} else {
JOptionPane.showMessageDialog(this, "修改失败！");
}
ps.close();
conn.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, "修改失败！");
}
}
public void btnExit_actionPerformed(ActionEvent e) {
if (JOptionPane.showConfirmDialog(this, "是否确定退出用户信息管理", "温馨提示",
JOptionPane.OK_CANCEL_OPTION) ==
JOptionPane.OK_OPTION) {
Dimension screenSize = Toolkit.getDefaultToolkit().
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -