package com.xkj.bookmanager.JFrame; import java.awt.Color; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.sql.ResultSet; import java.util.Vector; import javax.swing.JFrame; import org.jb2011.lnf.beautyeye.BeautyEyeLNFHelper; import com.mysql.jdbc.Connection; import com.xkj.bookmanager.dao.BookTypeDao; import com.xkj.bookmanager.model.BookType; import com.xkj.bookmanager.utils.DbUtil; import com.xkj.bookmanager.utils.toolUtil; import javax.swing.JMenuBar; import javax.swing.JMenu; import javax.swing.JMenuItem; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.UIManager; import javax.swing.border.TitledBorder; import javax.swing.table.DefaultTableModel; import javax.swing.JLabel; import java.awt.Font; import javax.swing.JTextField; import javax.swing.JButton; import java.awt.event.ActionListener; import java.awt.event.ActionEvent; import javax.swing.ImageIcon; public class AdminBTypeEdit extends JFrame { private JFrame jf; private JTable table; private DefaultTableModel model; DbUtil dbUtil=new DbUtil(); BookTypeDao bookTypeDao=new BookTypeDao(); private JTextField textField; private JTextField textField_1; private JTextField textField_2; public AdminBTypeEdit(){ jf=new JFrame("管理员界面"); jf.setBounds(400, 100, 611, 472); jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); jf.getContentPane().setLayout(null); JMenuBar menuBar = new JMenuBar(); jf.setJMenuBar(menuBar); JMenu mnNewMenu = new JMenu("类别管理"); menuBar.add(mnNewMenu); JMenuItem mntmNewMenuItem = new JMenuItem("类别添加"); mntmNewMenuItem.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { jf.dispose(); new AdminMenuFrm(); } }); mnNewMenu.add(mntmNewMenuItem); JMenuItem mntmNewMenuItem_1 = new JMenuItem("类别修改"); mnNewMenu.add(mntmNewMenuItem_1); JMenu mnNewMenu_2 = new JMenu("书籍管理"); menuBar.add(mnNewMenu_2); JMenuItem mntmNewMenuItem_2 = new JMenuItem("书籍添加"); mntmNewMenuItem_2.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { jf.dispose(); new AdminBookAdd(); } }); mnNewMenu_2.add(mntmNewMenuItem_2); JMenuItem mntmNewMenuItem_3 = new JMenuItem("书籍修改"); mntmNewMenuItem_3.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { jf.dispose(); new AdminBookEdit(); } }); mnNewMenu_2.add(mntmNewMenuItem_3); JMenu menu1 = new JMenu("用户管理"); menuBar.add(menu1); JMenuItem mntmNewMenuItem_4 = new JMenuItem("用户信息"); mntmNewMenuItem_4.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { jf.dispose(); new AdminUserInfo(); } }); menu1.add(mntmNewMenuItem_4); JMenuItem mntmNewMenuItem_5 = new JMenuItem("借阅信息"); mntmNewMenuItem_5.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { jf.dispose(); new AdminBorrowInfo(); } }); menu1.add(mntmNewMenuItem_5); JMenu mnNewMenu_1 = new JMenu("退出系统"); mnNewMenu_1.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { JOptionPane.showMessageDialog(null, "欢迎再次使用"); jf.dispose(); } }); menuBar.add(mnNewMenu_1); JPanel panel_1 = new JPanel(); panel_1.setBorder(new TitledBorder(UIManager.getBorder("TitledBorder.border"), "\u7C7B\u522B\u4FE1\u606F", TitledBorder.LEADING, TitledBorder.TOP, null, new Color(255, 0, 0))); panel_1.setBounds(20, 10, 554, 208); /*做一个表头栏数据 一位数组 * */ String[] title={"编号","类别名称","类别描述"}; /*具体的各栏行记录 先用空的二位数组占位*/ String[][] dates={}; /*然后实例化 上面2个控件对象*/ model=new DefaultTableModel(dates,title); table=new JTable(model); putDates();//获取数据库数据放置table中 panel_1.setLayout(null); JScrollPane jscrollpane = new JScrollPane(); jscrollpane.setBounds(20, 22, 517, 163); jscrollpane.setViewportView(table); panel_1.add(jscrollpane); jf.getContentPane().add(panel_1); JPanel panel = new JPanel(); panel.setBorder(new TitledBorder(null, "\u7C7B\u522B\u7F16\u8F91", TitledBorder.LEADING, TitledBorder.TOP, null, Color.RED)); panel.setBounds(20, 228, 554, 168); jf.getContentPane().add(panel); panel.setLayout(null); table.addMouseListener(new MouseAdapter() { public void mousePressed(MouseEvent evt) { typeTableMousePressed(evt); } }); JLabel lblNewLabel = new JLabel("编号:"); lblNewLabel.setFont(new Font("幼圆", Font.BOLD, 14)); lblNewLabel.setBounds(73, 26, 45, 28); panel.add(lblNewLabel); textField = new JTextField(); textField.setBounds(116, 30, 92, 24); panel.add(textField); textField.setColumns(10); JLabel label = new JLabel("类别名称:"); label.setFont(new Font("幼圆", Font.BOLD, 14)); label.setBounds(238, 26, 75, 28); panel.add(label); textField_1 = new JTextField(); textField_1.setColumns(10); textField_1.setBounds(314, 30, 122, 24); panel.add(textField_1); JLabel label_1 = new JLabel("描述:"); label_1.setFont(new Font("幼圆", Font.BOLD, 14)); label_1.setBounds(73, 65, 45, 28); panel.add(label_1); textField_2 = new JTextField(); textField_2.setColumns(10); textField_2.setBounds(116, 69, 320, 24); panel.add(textField_2); JButton btnNewButton = new JButton("修改"); //类别修改 btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String typeId = textField.getText(); String typeName = textField_1.getText(); String typeRemark = textField_2.getText(); if (toolUtil.isEmpty(typeName) || toolUtil.isEmpty(typeRemark)) { JOptionPane.showMessageDialog(null, "请输入相关信息"); return; } BookType bookType = new BookType(); bookType.setTypeId(Integer.parseInt(typeId)); bookType.setTypeName(typeName); bookType.setRemark(typeRemark); Connection con = null; try { con = dbUtil.getConnection(); int i = bookTypeDao.update(con, bookType); if (i == 1) { JOptionPane.showMessageDialog(null, "修改成功"); putDates(); } else { JOptionPane.showMessageDialog(null, "修改失败"); } } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); JOptionPane.showMessageDialog(null, "修改异常"); } finally { try { dbUtil.closeCon(con); } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } } }); btnNewButton.setFont(new Font("幼圆", Font.BOLD, 14)); btnNewButton.setBounds(128, 117, 93, 28); panel.add(btnNewButton); JButton button = new JButton("删除"); button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String typeId = textField.getText(); if (toolUtil.isEmpty(typeId)) { JOptionPane.showMessageDialog(null, "请选择相关信息"); return; } Connection con = null; try { con = dbUtil.getConnection(); int i = bookTypeDao.delete(con, typeId); if (i == 1) { JOptionPane.showMessageDialog(null, "删除成功"); putDates(); } else if (i == 2) { JOptionPane.showMessageDialog(null, "删除失败-类别最少保留一个"); } else if (i == 3) { JOptionPane.showMessageDialog(null, "删除失败-该类别下有书籍"); } else { JOptionPane.showMessageDialog(null, "删除失败"); } } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); JOptionPane.showMessageDialog(null, "删除异常"); } finally { try { dbUtil.closeCon(con); } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } } }); button.setFont(new Font("幼圆", Font.BOLD, 14)); button.setBounds(314, 117, 93, 28); panel.add(button); JLabel lblNewLabel_1 = new JLabel(""); lblNewLabel_1.setIcon(new ImageIcon(AdminBTypeEdit.class.getResource("/tupian/adBG3.png"))); lblNewLabel_1.setBounds(0, 0, 595, 413); jf.getContentPane().add(lblNewLabel_1); jf.setVisible(true); jf.setResizable(true); } //点击表格获取信息 protected void typeTableMousePressed(MouseEvent evt) { int row = table.getSelectedRow(); textField.setText(table.getValueAt(row, 0).toString()); textField_1.setText(table.getValueAt(row, 1).toString()); textField_2.setText(table.getValueAt(row, 2).toString()); } private void putDates() { DefaultTableModel model = (DefaultTableModel) table.getModel(); model.setRowCount(0); Connection con = null; try { con = dbUtil.getConnection(); ResultSet list = bookTypeDao.list(con, new BookType()); while (list.next()) { Vector rowData = new Vector(); rowData.add(list.getInt("id")); rowData.add(list.getString("type_name")); rowData.add(list.getString("remark")); model.addRow(rowData); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { dbUtil.closeCon(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } public static void main(String[] args) { try { BeautyEyeLNFHelper.frameBorderStyle = BeautyEyeLNFHelper.FrameBorderStyle.generalNoTranslucencyShadow; org.jb2011.lnf.beautyeye.BeautyEyeLNFHelper.launchBeautyEyeLNF(); } catch (Exception e) { e.printStackTrace(); } //new AdminBTypeEdit(); } }

liys1234 LV9
6月23日
aaaahao LV10
6月9日
李海洋 LV12
6月8日
我是helloworld LV19
5月3日
wyx065747 LV67
4月2日
ZhangWanhui LV11
3月24日
3159792465 LV8
2021年12月29日
华灯初上旧人安 LV8
2021年12月19日
yigu123 LV6
2021年12月14日
孙纪龙啊 LV8
2021年12月13日