package text6; import java.sql.*; import java.awt.*; import java.awt.event.*; import javax.swing.*; public class domo extends JFrame implements ActionListener{ JPanel jp1=new JPanel(); JPanel jp2=new JPanel(); JLabel lbl_no=new JLabel("学号"); JLabel lbl_name=new JLabel("姓名"); JLabel lbl_birth=new JLabel("生日"); JLabel lbl_sex=new JLabel("性别"); JLabel lbl_study=new JLabel("学情"); JLabel lbl_live=new JLabel("宿舍"); JTextField txt_no=new JTextField(20); JTextField txt_name=new JTextField(20); JTextField txt_birth=new JTextField(20); JTextField txt_sex=new JTextField(20); JTextField txt_study=new JTextField(20); JTextField txt_live=new JTextField(20); JButton btn_add=new JButton("新增"); JButton btn_delete=new JButton("删除"); JButton btn_update=new JButton("更新"); public domo(){ jp1.add(lbl_no); jp1.add(txt_no); jp1.add(lbl_name); jp1.add(txt_name); jp1.add(lbl_birth); jp1.add(txt_birth); jp1.add(lbl_sex); jp1.add(txt_sex); jp1.add(lbl_study); jp1.add(txt_birth); jp1.add(lbl_live); jp1.add(txt_live); add(jp1,BorderLayout.CENTER); jp2.add(btn_add); jp2.add(btn_delete); jp2.add(btn_update); add(jp2,BorderLayout.SOUTH); setBounds(250,250,250,250); setVisible(true); } @Override public void actionPerformed(ActionEvent e) { // TODO 自动生成的方法存根 } public static void main(String args[]) { JFrame.setDefaultLookAndFeelDecorated(true); new domo(); } }改错

package DMS.SYSTEM; import DMS.GetConnection; import DMS.Users; import javax.swing.; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableRowSorter; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; /**学生缺寝 * @author LQ * @create */ public class CooBuilding extends JPanel implements ActionListener { Connection connection = new GetConnection().GetConnection(); int type; Users user; JTable table = new JTable(); //JButton button = new JButton(""); String[] col = {"楼名", "层数", "管理人","容纳人数"}; DefaultTableModel mm = new DefaultTableModel(col, 0); // 定义一个表的模板 JLabel Bname,Bfloor,Bmager,Bcap,SP; JTextField BnameText,BfloorText,BmagerText,BcapText; JButton seek, add, delete, edit; JPanel student; public CooBuilding(int type, Users user) { this.user = user; this.type = type; setLayout(new FlowLayout());//整个采用流动式布局很好的适应了表格带来的影响 table.setModel(mm); table.setRowSorter(new TableRowSorter<>(mm)); JScrollPane js = new JScrollPane(table); add(js); search(); }

这段代码是一个 Java 类，名为 CooBuilding，继承自 JPanel 类，并且实现了 ActionListener 接口。这个类主要是用来显示一个包含建筑物信息的表格，并且可以对这个表格进行增删改查的操作。其中，变量 type 表示用户...

package package06; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.; import javax.swing.*; public class Java6 extends JFrame { JLabel wenzi; JTextField shuru; JButton chaxun; JTextArea fanhui; public Java6(){ super("中英查询软件"); // 窗口添加pNorth 在北面区域 add(getNorthPanel(),BorderLayout.NORTH); } private JPanel getNorthPanel() { JPanel panel = new JPanel(); wenzi = new JLabel("请输入要查询的单词："); shuru=new JTextField(8); chaxun=new JButton("查询"); fanhui =new JTextArea(6,25); panel.add(wenzi,new FlowLayout()); panel.add(shuru,new FlowLayout()); panel.add(chaxun,new FlowLayout()); panel.add(fanhui,new FlowLayout()); return panel; } public static void main(String[] args) throws Exception{ Java6 zy=new Java6(); zy.setBounds(100, 100, 340, 170); zy.setVisible(true); zy.setDefaultCloseOperation(zy.EXIT_ON_CLOSE); Class.forName("com.mysql.cj.jdbc.Driver"); //加载MySQL的驱动类 String ur1="jdbc:mysql://localhost:3306/java实训"; String user="root"; String password="root"; try { Connection Con =DriverManager.getConnection(ur1,user,password); System.out.println("eeeeee"); } catch (Exception e) { // TODO: handle exception System.out.println("ww"); } } }这些代码连接不了数据库，是哪里错误了吗？

import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; import javax.swing.*; public class Java6 extends JFrame { JLabel wenzi; JTextField shuru; JButton ...

package hotelcheckout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.swing.JButton; import javax.swing.JOptionPane; import javax.swing.JPasswordField; import javax.swing.JTextField; import javax.swing.UIManager; public class MyJFramecheckout extends JFramecheckout { private JButton btnNewButton; private JButton btnNewButton_1; private JTextField textField; private JPasswordField passwordField; //构造方法 public MyJFramecheckout(){ super(); /********************************************************** * 控件的各种事件响应函数部分 *********************************************************/ //下面可添加各种按钮被点击事件、菜单点击、下拉列表选项改变等的响应函数[控件响应函数不要修改此行] //按钮"登录"被点击的事件响应函数 btnNewButton = new JButton(); btnNewButton.addActionListener(new ActionListener() { private String pwd; @Override public void actionPerformed(ActionEvent arg0) { //在此处编写控件被点击之后要做的事情 //在获取 textField 的文本时，未对 textField 是否为空进行判断，存在空指针风险。先进行非空判断 if(textField!=null) { @SuppressWarnings("unused") String name=textField.getText(); } if(passwordField!=null) { @SuppressWarnings("unused") char[] pwd=passwordField.getPassword(); } try (Connection conn = DriverManager.getConnection(Daomain.connStr); PreparedStatement pstmt = conn.prepareStatement("SELECT FROM checkout " + "WHERE name = '" + getName() + "' AND pwd = '" + new String(pwd)+ "'" )) { pstmt.setString(1, getName()); pstmt.setString(2, new String(pwd)); ResultSet rs = pstmt.executeQuery(); if (rs.next()) { // 登录成功逻辑 JOptionPane.showMessageDialog(MyJFramecheckout.this,"登录成功", "通知", JOptionPane.INFORMATION_MESSAGE); } else { // 登录失败逻辑 JOptionPane.showMessageDialog(MyJFramecheckout.this,"登录失败", "通知", JOptionPane.INFORMATION_MESSAGE); } } catch (SQLException e) { e.printStackTrace(); } } }); //按钮"注册"被点击的事件响应函数 btnNewButton_1 = new JButton(); btnNewButton_1.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent arg0) { //*在此处编写控件被点击之后要做的事情 } }); / //构造函数最后要做的事 / init();//初始化界面 / 以下是刷新界面的代码 / //下面这个try语句使界面变成windows风格的界面 try{ UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName()); }catch (Exception e) { } repaint();//刷新整个窗体（必须放在所有控件之后） }//构造方法结束于此 /****** * 自定义函数部分 ***********************************************************/ //初始化界面 public void init(){ } //更新界面 public void update(){ } }运行后按登录按钮没反应，怎么解决

#### 6. 完整示例代码结构 java public class LoginFrame extends JFrame { public LoginFrame() { JPanel panel = new JPanel(); JButton btn = new JButton("登录"); btn.addActionListener(e -> ...

优化这段代码package com.daiinfo.catering.pane; import com.daiinfo.catering.util.JDBConnection; import javax.swing.; import javax.swing.border.Border; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.EventListener; public class DishManagePane2 extends JFrame { private JTable table; private JButton addButton,updateButton,deleteButton; public DishManagePane2(){ setTitle("菜品管理"); setSize(800,600); String [] columnNames = {"菜品名","价格","菜品类别"}; Object[][] data = {{"糖醋排骨",29.0,"西餐"},{"宫保鸡丁",28.0,"中餐"}}; JTable table = new JTable(data,columnNames); addButton = new JButton("增加"); updateButton = new JButton("修改"); deleteButton = new JButton("删除"); addButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { } }); JPanel panel = new JPanel(new BorderLayout()); panel.add(new JScrollPane(table),BorderLayout.CENTER); JPanel buttonPanel = new JPanel(new FlowLayout()); buttonPanel.add(addButton); buttonPanel.add(updateButton); buttonPanel.add(deleteButton); panel.add(buttonPanel,BorderLayout.SOUTH); add(panel); setVisible(true); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } public static void main(String[] args) { new JDBConnection(); new DishManagePane2(); } }

import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Vector; public class ...

package 软件本科9班小罗; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.beans.Statement; import java.sql.; import javax.swing.*; public class Java06 extends JFrame implements ActionListener{ JButton Button; JLabel s1; JTextField text; JTextArea ta; Connection conn; java.sql.Statement stat1; java.sql.Statement stat2; ResultSet rs1,rs2; public Java06() { super("中英文查询"); Button=new JButton("查询"); Button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { chazhao(); } }); s1=new JLabel("输入要查询的单词:"); text =new JTextField("word",20); ta = new JTextArea("工作",7,36); JPanel panel=new JPanel(); panel.add(s1); panel.add(text); panel.add(Button); JPanel panel2=new JPanel(); panel2.add(ta); Container con=getContentPane(); con.add(panel,BorderLayout.NORTH); con.add(panel2); setSize(400,200); } public void chazhao() { String i; try { Class.forName("com.mysql.jdbc.Driver");//加载连接驱动; conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sys?serverTimezone=UTC", "root", "123456"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block System.out.println("加载驱动失败"); } catch (SQLException e) { System.out.println("获取连接失败"); } String sql1="select 中文 from book where 英文="+"\""+text+"\""; String sql2="select 英文 from book where 中文="+"\""+text+"\""; try { stat1=conn.createStatement(); rs1=stat1.executeQuery(sql1); stat2=conn.createStatement(); rs2=stat2.executeQuery(sql2); while(rs1.next()) { System.out.println(rs1.getString("中文")); } while (rs2.next()) { System.out.println(rs2.getString("英文")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { new Java06().setVisible(true); } @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if(e.getSource()==Button) { String text=ta.getText(); ta.setText(text);; } } }这个代码中哪里有错呀，运行不了，还连接不成数据库

3. SQL查询语句错误。你的查询语句可能有问题。你需要检查语句是否正确，并且确定你的数据库中是否有名为“book”的表。 4. 代码中的其他潜在错误。在代码中有其他的潜在错误，例如未处理异常或变量命名错误。你...

此代码应如何修改避免空指针异常package frame; import dao.ProductDAO; import dao.ProductDAOImpl; import model.Product; import javax.swing.; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.SQLException; public class UpdateProductDialog extends JDialog { private boolean isOK = false; private Product product; private JTextField nameField; private JTextField priceField; private JTextArea descriptionArea; public UpdateProductDialog(Frame owner, int productId) { super(owner, "更新商品", true); setPreferredSize(new Dimension(400, 300)); setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE); ProductDAO productDAO = new ProductDAOImpl() { @Override public Product getProductById(int id) { return null; } }; product = productDAO.getProductById(productId); JLabel nameLabel = new JLabel("名称"); JLabel priceLabel = new JLabel("价格"); JLabel descriptionLabel = new JLabel("描述"); nameField = new JTextField(product.getName()); priceField = new JTextField(Double.toString(product.getPrice())); descriptionArea = new JTextArea(product.getDescription(), 5, 20); JButton okButton = new JButton("确定"); okButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { String name = nameField.getText(); double price = Double.parseDouble(priceField.getText()); String description = descriptionArea.getText(); product.setName(name); product.setPrice(price); product.setDescription(description); isOK = true; dispose(); } }); JButton cancelButton = new JButton("取消"); cancelButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { dispose(); } }); JPanel panel = new JPanel(new GridLayout(4, 2)); panel.add(nameLabel); panel.add(nameField); panel.add(priceLabel); panel.add(priceField); panel.add(descriptionLabel); panel.add(new JScrollPane(descriptionArea)); panel.add(okButton); panel.add(cancelButton); setContentPane(panel); pack(); setLocationRelativeTo(owner); } public boolean isOK() { return isOK; } public Product getProduct() { return product; } }

在这段代码中，空指针异常可能会出现在以下行： product = productDAO.getProductById(productId); 如果productDAO返回的是null，那么product也将是null，在接下来的代码执行中，如果你尝试使用...

修改这段代码实现选择表格一行信息删除package frame; import javax.swing.; import java.awt.; import java.awt.event.ActionEvent; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; //添加页面 public class EditDialog extends BaseDialog{ DataChangelisenter dataChangelisenter; public void setDataChangelisenter(DataChangelisenter dataChangelisenter) { this.dataChangelisenter = dataChangelisenter; } @Override public void init() { setLayout(new FlowLayout()); //布局 setTitle("修改图书信息"); JPanel jp0=new JPanel(); JLabel l0 = new JLabel("id"); JTextField t0 = new JTextField(); t0.setPreferredSize(new Dimension(300,30)); jp0.add(l0); jp0.add(t0); JPanel jp1=new JPanel(); JLabel l1 = new JLabel("书名"); JTextField t1 = new JTextField(); t1.setPreferredSize(new Dimension(300,30)); jp1.add(l1); jp1.add(t1); JPanel jp2=new JPanel(); JLabel l2 = new JLabel("作者"); JTextField t2 = new JTextField(); t2.setPreferredSize(new Dimension(300,30)); jp2.add(l2); jp2.add(t2); JPanel jp3=new JPanel(); JLabel l3 = new JLabel("分类"); JTextField t3 = new JTextField(); t3.setPreferredSize(new Dimension(300,30)); jp3.add(l3); jp3.add(t3); JPanel jp4=new JPanel(); JLabel l4 = new JLabel("出版社"); JTextField t4 = new JTextField(); t4.setPreferredSize(new Dimension(300,30)); jp4.add(l4); jp4.add(t4); JPanel jp5=new JPanel(); JLabel l5 = new JLabel("数量"); JTextField t5 = new JTextField(); t5.setPreferredSize(new Dimension(300,30)); jp5.add(l5); jp5.add(t5); add(jp0); add(jp1); add(jp2); add(jp3); add(jp4); add(jp5); JButton b1 = new JButton("保存"); b1.setPreferredSize(new Dimension(150,30)); b1.addActionListener(new AbstractAction() { @Override public void actionPerformed(ActionEvent e) { String id = t0.getText(); String sname = t1.getText(); String author = t2.getText(); String classify = t3.getText(); String press = t4.getText(); String quantity = t5.getText(); Connection con = DBUtil.getConnect(); String sql = "UPDATE tushu SET sname=?,author=?,classify=?,press=?,quantity=? WHERE id=?"; try { PreparedStatement ps = con.prepareStatement(sql); ps.setString(1,sname); ps.setString(2,author); ps.setString(3,classify); ps.setString(4,press); ps.setString(5,quantity); ps.setString(6,id); int result = ps.executeUpdate(); if (result>0){ JOptionPane.showMessageDialog(EditDialog.this,"修改成功"); // new StudentFrame(); dataChangelisenter.dataChange(); dispose(); }else { JOptionPane.showMessageDialog(EditDialog.this,"修改失败"); } } catch (SQLException throwables) { throwables.printStackTrace(); } } }); add(b1); } }

import java.awt.event.ActionEvent; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.SQLException; public class EditDialog extends BaseDialog{ DataChangelisenter ...

create database student; use student; create table users( uname varchar(10) primary key, upwd varchar(10) ); insert into users values('admin','1234'); insert into users values('zhou','zhou');package homework7_二_2_20221548; import javax.swing.; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.; public class Demo { public static void main(String args[]){ MyWindow win=new MyWindow(); } } class MyWindow extends JFrame{ JLabel lbl_name=new JLabel("username"); JLabel lbl_password=new JLabel("password"); JTextField txt_name=new JTextField(15); JTextField txt_password=new JTextField(15); JButton btn1=new JButton("confirm"); JButton btn2=new JButton("cancel"); MyWindow(){ JPanel jp1=new JPanel(); jp1.setLayout(new FlowLayout()); jp1.add(lbl_name); jp1.add(txt_name); jp1.add(lbl_password); jp1.add(txt_password); add(jp1,BorderLayout.CENTER); JPanel jp2=new JPanel(); jp2.setLayout(new FlowLayout()); jp2.add(btn1); jp2.add(btn2); btn1.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String txt1=txt_name.getText(); String txt2=txt_password.getText(); String[] username=new String[2]; String[] password=new String[2]; new DemoQuery(username,password); if(txt1.equals(username[0])&&txt2.equals(password[0])) { JOptionPane.showMessageDialog(null,"欢迎您，"+username[0]+"登录"); } else if(txt1.equals(username[1])&&txt2.equals(password[1])){ JOptionPane.showMessageDialog(null,"欢迎您，"+username[1]+"登录"); } else { JOptionPane.showMessageDialog(null,"用户名和密码错误"); txt_name.setText(""); txt_password.setText(""); } } }); add(jp2,BorderLayout.SOUTH); setSize(300,150); setVisible(true); setTitle("the login window"); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } } class DemoQuery { public DemoQuery(String[] username,String[] password){ String url = "jdbc:mysql://127.0.0.1:3306/student"; String user = "root", pwd = ""; Connection con; Statement sql; ResultSet rs; try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { System.out.println("test" + e); } try { con = DriverManager.getConnection(url, user, pwd); sql = con.createStatement(); String sqlStatement; sqlStatement = "SELECT From users"; rs = sql.executeQuery(sqlStatement); while (rs.next()) { int i = 0; username[i] = rs.getString("uname"); password[i] = rs.getString("upwd"); System.out.println(username[i]+" "+password[i]); i++; } con.close(); } catch (SQLException e) { System.out.println("数据库操作失败" + e); } } }为什么用户名输入admin，密码输入1234显示登录失败？

rs = sql.executeQuery(sqlStatement); int i = 0; while (rs.next()) { username[i] = rs.getString("uname"); password[i] = rs.getString("upwd"); System.out.println(username[i]+" "+password[i]); i++...

Java连接SQL数据库实现登陆

import java.awt.event.*; import java.sql.*; import javax.swing.*; //登陆面板 public class Login extends JFrame { Connection conn = null; Statement stmt = null; ResultSet rst = null; public ...

java词汇解释

在Java中，javax.swing.Icon接口定义了图标的基本行为。 #### Tree 树，用于表示具有层次结构的数据的GUI组件。在Java中，JTree类是Swing中的树组件。 #### Node 节点，是树状结构中的基本组成单位。在Java中...

java课程设计报告

import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import com.ccut.a.JDBCTools.ConnectionUtil; class Add extends JFrame { // 类成员变量声明... public Add() { /...

java 学生管理系统

import java.awt.event.*; import java.sql.*; public class Hhb3 extends JFrame implements ActionListener { static Hhb3 ss; JPanel panel = new JPanel(); JLabel label1 = new JLabel("用户名："); ...

package model; public class Book { private int bookId=0; private String bookName=" "; private String bookAuthor=" "; private int bookNum=0; private String bookPress=" "; public Book(){ } public Book(int id, String name, String author, int num, String press) { } public int getBookId() { return bookId; } public void setBookId(int bookId) { this.bookId = bookId; } public String getBookName() { return bookName; } public void setBookName(String bookName) { this.bookName = bookName; } public String getBookAuthor() { return bookAuthor; } public void setBookAuthor(String bookAuthor) { this.bookAuthor = bookAuthor; } public int getBookNum() { return bookNum; } public void setBookNum(int bookNum) { this.bookNum = bookNum; } public String getBookPress() { return bookPress; } public void setBookPress(String bookPress) { this.bookPress = bookPress; } public String toString(){ return "Book{"+ "bookId="+bookId+ "，bookName="+bookName+ "，bookAuthor"+bookAuthor+ "，bookNum="+bookNum+ "，bookPress="+bookPress+'\''+ '}'; } } package model; import com.sun.corba.se.pept.transport.ConnectionCache; import util.DBUtil; import java.sql.; import java.util.ArrayList; import java.util.List; public class BookDAO { public static void addBook(Book book){ String query = "INSERT INTO t_book (book_id,book_name,author,num,press) VALUES(?,?,?,?,?)"; try (Connection connection= DBUtil.getConnection(); PreparedStatement preparedStatement=connection.prepareStatement(query)){ preparedStatement.setInt(1,book.getBookId()); preparedStatement.setString(2,book.getBookName()); preparedStatement.setString(3,book.getBookAuthor()); preparedStatement.setInt(4,book.getBookNum()); preparedStatement.setString(5,book.getBookPress()); preparedStatement.executeUpdate(); }catch (SQLException e){ e.printStackTrace(); } } public static void updateBook(Book book) { String query = "UPDATE t_book SET book_id = ?, book_name = ?, author = ?, num = ?, press = ? WHERE book_id = ?"; try (Connection connection = DBUtil.getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(query)) { preparedStatement.setInt(1, book.getBookId()); preparedStatement.setString(2, book.getBookName()); preparedStatement.setString(3, book.getBookAuthor()); preparedStatement.setInt(4, book.getBookNum()); preparedStatement.setString(5, book.getBookPress()); preparedStatement.setInt(6, book.getBookId()); preparedStatement.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } public void deleteBook(int book_id) { String query = "DELETE FROM t_book WHERE book_id = ?"; try (Connection connection = DBUtil.getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(query)) { preparedStatement.setInt(1, book_id); preparedStatement.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } public static Book getBookById(int book_id) { Book book = null; String query = "SELECT FROM t_book WHERE book_id = ?"; try (Connection connection = DBUtil.getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(query)) { preparedStatement.setInt(1, book_id); ResultSet resultSet = preparedStatement.executeQuery(); if (resultSet.next()) { book = new Book(); book.setBookId(resultSet.getInt("book_id")); book.setBookName(resultSet.getString("book_name")); book.setBookAuthor(resultSet.getString("author")); book.setBookNum(resultSet.getInt("num")); book.setBookPress(resultSet.getString("press")); } } catch (SQLException e) { e.printStackTrace(); } return book; } public static List<Book> getAllBook() { List<Book> books = new ArrayList<>(); String query = "SELECT * FROM t_book"; try (Connection connection = DBUtil.getConnection(); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(query)) { while (resultSet.next()) { Book book = new Book(); book.setBookId(resultSet.getInt("book_id")); book.setBookName(resultSet.getString("book_name")); book.setBookAuthor(resultSet.getString("author")); book.setBookNum(resultSet.getInt("num")); book.setBookPress(resultSet.getString("press")); books.add(book); } } catch (SQLException e) { e.printStackTrace(); } return books; } public static void main(String[] args) { BookDAO bookDAO= new BookDAO(); // 1. 添加新部门 Book newBook = new Book(); bookDAO.addBook(newBook); System.out.println("添加新书籍: " + newBook); // 2. 查询所有部门 List<Book> books = bookDAO.getAllBook(); System.out.println("所有书籍列表:"); for (Book book : books) { System.out.println(book); } // 3. 更新部门信息 if (!books.isEmpty()) { Book bookToUpdate = books.get(0); bookToUpdate.setBookId(12345); bookToUpdate.setBookName("呃呃呃呃呃"); bookToUpdate.setBookAuthor("呃呃呃呃呃"); bookToUpdate.setBookNum(23456); bookToUpdate.setBookPress("略略略"); BookDAO.updateBook(bookToUpdate); System.out.println("更新部门信息: " + bookToUpdate); } // 4. 根据ID查询部门 if (!books.isEmpty()) { int bookId = books.get(0).getBookId(); Book bookById = BookDAO.getBookById(bookId); System.out.println("根据ID查询部门: " + bookById); } // 5. 删除部门 if (!books.isEmpty()) { int bookIdToDelete =books.get(0).getBookId(); bookDAO.deleteBook(bookIdToDelete); System.out.println("删除部门ID: " + bookIdToDelete); } // 再次查询所有部门，验证删除操作 books = BookDAO.getAllBook(); System.out.println("删除操作后，所有部门列表:"); for (Book book : books) { System.out.println(book); } } } package view; import model.Book; import model.BookDAO; import javax.swing.; import javax.swing.table.DefaultTableModel; import java.awt.; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.List; import static model.BookDAO.updateBook; public class BookView extends JFrame { private BookDAO bookDAO; private JTable bookTable; private DefaultTableModel tableModel; public BookView() { bookDAO = new BookDAO(); initializeUI(); } private void initializeUI() { setTitle("图书管理系统"); setSize(800, 600); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setLocationRelativeTo(null); // 创建按钮面板 JPanel buttonPanel = new JPanel(); JButton addButton = new JButton("添加书籍"); JButton viewButton = new JButton("查看所有书籍"); JButton updateButton = new JButton("更新书籍"); JButton deleteButton = new JButton("删除书籍"); addButton.setBackground(new Color(17, 248, 160)); viewButton.setBackground(new Color(17, 248, 160)); updateButton.setBackground(new Color(17, 248, 160)); deleteButton.setBackground(new Color(17, 248, 160)); buttonPanel.add(addButton); buttonPanel.add(viewButton); buttonPanel.add(updateButton); buttonPanel.add(deleteButton); buttonPanel.setLayout(new GridLayout(2, 2, 1, 10)); // 创建表格 bookTable = new JTable(); tableModel = new DefaultTableModel(new Object[]{"ID", "书名", "作者", "余量", "出版社"}, 0); bookTable.setModel(tableModel); bookTable.setRowHeight(40); bookTable.setBackground(Color.cyan); JScrollPane scrollPane = new JScrollPane(bookTable); // 添加组件到主面板 setLayout(new BorderLayout()); add(buttonPanel, BorderLayout.SOUTH); add(scrollPane, BorderLayout.CENTER); // 添加按钮事件监听器 addButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { addBook(); } }); viewButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { viewAllBook(); } }); updateButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { updateBook(); } }); deleteButton.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { deleteBook(); } }); setVisible(true); } private void addBook() { JTextField idField = new JTextField(); JTextField nameField = new JTextField(); JTextField authorField = new JTextField(); JTextField numField = new JTextField(); JTextField pressField = new JTextField(); Object[] message = { "ID:", idField, "书名:", nameField, "作者:", authorField, "余量:", numField, "出版社:", pressField }; int option = JOptionPane.showConfirmDialog(this, message, "添加书籍", JOptionPane.OK_CANCEL_OPTION); if (option == JOptionPane.OK_OPTION) { int id = Integer.parseInt(idField.getText()); String name = nameField.getText(); String author = authorField.getText(); int num = Integer.parseInt(numField.getText()); String press = pressField.getText(); Book book = new Book(id, name, author, num, press); System.out.println(name); bookDAO.addBook(book); JOptionPane.showMessageDialog(this, "书籍已添加: " + book); viewAllBook(); // 更新表格数据 } } private void viewAllBook() { List<Book> books = bookDAO.getAllBook(); tableModel.setRowCount(0); // 清空表格 for (Book book : books) { tableModel.addRow(new Object[]{book.getBookId(), book.getBookName(), book.getBookAuthor(), book.getBookNum(), book.getBookPress()}); } } private void updateBook() { int selectedRow = bookTable.getSelectedRow(); if (selectedRow == -1) { JOptionPane.showMessageDialog(this, "请选择要更新的书籍。"); return; } int currentId = (int) tableModel.getValueAt(selectedRow, 0); JTextField idField = new JTextField(String.valueOf(currentId)); JTextField nameField = new JTextField((String) tableModel.getValueAt(selectedRow, 1)); JTextField authorField = new JTextField(String.valueOf(tableModel.getValueAt(selectedRow, 2))); JTextField numField = new JTextField(String.valueOf(tableModel.getValueAt(selectedRow, 3))); JTextField pressField = new JTextField(String.valueOf(tableModel.getValueAt(selectedRow, 4))); Object[] message = { "ID:", idField, "书名:", nameField, "作者:", authorField, "余量", numField, "出版社", pressField }; int option = JOptionPane.showConfirmDialog(this, message, "更新书籍", JOptionPane.OK_CANCEL_OPTION); if (option == JOptionPane.OK_OPTION) { int id = Integer.parseInt(idField.getText()); String name = nameField.getText(); String author = authorField.getText(); int num = Integer.parseInt(numField.getText()); String press = pressField.getText(); Book book = bookDAO.getBookById(currentId); if (book != null) { book.setBookId(id); book.setBookName(name); book.setBookAuthor(author); book.setBookNum(num); book.setBookPress(press); book.setBookId(id); bookDAO.updateBook(book); JOptionPane.showMessageDialog(this, "书籍信息已更新: " + book); viewAllBook(); // 更新表格数据 } else { JOptionPane.showMessageDialog(this, "书籍ID不存在。"); } } } private void deleteBook() { int selectedRow = bookTable.getSelectedRow(); if (selectedRow == -1) { JOptionPane.showMessageDialog(this, "请选择要删除的书籍。"); return; } int id = (int) tableModel.getValueAt(selectedRow, 0); bookDAO.deleteBook(id); JOptionPane.showMessageDialog(this, "书籍已删除，ID: " + id); viewAllBook(); // 更新表格数据 } public static void main(String[] args) { SwingUtilities.invokeLater(new Runnable() { @Override public void run() { new BookView(); } }); } } 在正确添加完书籍时无法正确在可视化界面中显示

如果问题仍然存在，建议在BookDAO.addBook(Book book)方法中添加日志，打印出实际执行的SQL参数，并在添加后立即查询数据库确认数据是否插入成功。例如，在addBook方法中，执行preparedStatement.executeUpdate...

SchedulePanel.java完整代码

import java.awt.event.ActionListener; import java.sql.Date; import java.util.Calendar; import java.util.List; public class SchedulePanel extends JPanel { private final int userId; private final ...

MATLAB常用函数说明(1).doc

电子商务下的物流仓储管理教材(1).pptx

鉴于云计算下计算机基础课程教学的研究思索(1).docx

相关推荐

Java面向对象（基础）-package和import关键字的使用

java课程设计图书馆管理系统.doc

Java课程设计超市库存管理系统附源代码可以直接运行.doc

Java连接SQL数据库实现登陆

java词汇解释

java课程设计报告

java 学生管理系统

SchedulePanel.java完整代码

MATLAB常用函数说明(1).doc

电子商务下的物流仓储管理教材(1).pptx

鉴于云计算下计算机基础课程教学的研究思索(1).docx

大家在看

ADS1292rShield_Breakout-master_ADS1292_ADS1292程序_ads1292r_breako

kb4474419和kb4490628系统补丁.rar

XposedDetector

SmartSVN license

广州市行政区各街镇地图shp文件

最新推荐

MATLAB常用函数说明(1).doc

电子商务下的物流仓储管理教材(1).pptx

精选Java案例开发技巧集锦

【VASP报错深度解析】：5大技巧识别并永久解决离子距离太近警告

npm error A complete log of this run can be found in: D:\Program Files\nodejs\node_cache\_logs\2025-04-20T15_11_51_454Z-debug-0.log

深入理解内存技术文档详解

【机械特性分析进阶秘籍】：频域与时域对比的全面研究

dslicsrv安装报错Too many errors

深入解析Pro Ajax与Java技术的综合应用框架

【频域分析深度解读】：揭秘机械系统分析中的实用应用