1小时学会通过Java Swing Design设计java图形化（3）-阿里云开发者社区

5、JDBC

需要数据库jar包

mysql-connector-java-5.1.7bin.jar

下载链接：https://download.csdn.net/download/feng8403000/85610502

MySQL

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `createDate` datetime(0) NOT NULL,
  `userName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sex` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `introduce` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, '2022-06-11 12:55:02', '王语嫣', '女', '琅嬛福地，神仙姐姐。');
INSERT INTO `users` VALUES (2, '2022-06-11 12:56:05', '小龙女', '女', '冰山美人');
SET FOREIGN_KEY_CHECKS = 1;

JDCB_Demo

package com.item.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * 数据库工厂
 * @author Administrator
 *
 */
public class FactoryDB {
  /**
   * 驱动位置
   */
  private static final String driver ="com.mysql.jdbc.Driver";
  /**
   * 数据库链接路径·必背
   */
  private static final String url ="jdbc:mysql://127.0.0.1:3306/mytest?characterEncoding=utf-8";
  /**
   * 数据库账号
   */
  private static final String user ="root";
  /**
   * 数据库密码
   */
  private static final String pwd ="12345678";
  /**
   * 静态块引入数据库驱动·解决包位置问题
   */
  static {
    try {
      Class.forName(driver);
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
  /**
   * 数据库链接
   * @return
   */
  public static Connection getConn() {
    Connection conn = null;
    try {
      conn = DriverManager.getConnection(url,user,pwd);
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    return conn;
  }
  /**
   * 关闭数据库连接
   * @param conn
   * @param pr
   * @param re
   */
  public static void close(Connection conn,PreparedStatement pr, ResultSet re) {
    try {
      if (re!=null) {
        re.close();
      } 
      if(pr!=null){
        pr.close();
      }
      if(conn!=null){
        conn.close();
      }
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

封装模型：

package com.item.model;
import java.util.Date;
public class Users {
  @Override
  public String toString() {
    return "Users [id=" + id + ", creaetDate=" + creaetDate + ", userName=" + userName + ", sex=" + sex
        + ", introduce=" + introduce + "]";
  }
  private int id;
  private Date creaetDate;
  private String userName;
  private String sex;
  private String introduce;
  public int getId() {
    return id;
  }
  public void setId(int id) {
    this.id = id;
  }
  public Date getCreaetDate() {
    return creaetDate;
  }
  public void setCreaetDate(Date creaetDate) {
    this.creaetDate = creaetDate;
  }
  public String getUserName() {
    return userName;
  }
  public void setUserName(String userName) {
    this.userName = userName;
  }
  public String getSex() {
    return sex;
  }
  public void setSex(String sex) {
    this.sex = sex;
  }
  public String getIntroduce() {
    return introduce;
  }
  public void setIntroduce(String introduce) {
    this.introduce = introduce;
  }
}

UI层添加数据：

JTable需要绑定一下俩数据：

//添加标题
Vector vTitle  = new Vector();
//添加数据
Vector vdate = new Vector();
//绑定到控件
table.setModel(new DefaultTableModel(vdate,vTitle));

package com.item.ui;
import java.awt.BorderLayout;
import java.awt.EventQueue;
import java.util.ArrayList;
import java.util.Vector;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JScrollPane;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import com.item.dao.UsersDAO;
import com.item.model.Users;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
public class utest extends JFrame {
  /**
   * 序列
   */
  private static final long serialVersionUID = 1L;
  private JPanel contentPane;
  private JTextField userName;
  private JTable table;
  /**
   * Launch the application.
   */
  public static void main(String[] args) {
    EventQueue.invokeLater(new Runnable() {
      public void run() {
        try {
          utest frame = new utest();
          frame.setVisible(true);
        } catch (Exception e) {
          e.printStackTrace();
        }
      }
    });
  }
  /**
   * Create the frame.
   */
  public utest() {
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    setBounds(100, 100, 667, 598);
    contentPane = new JPanel();
    contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
    contentPane.setLayout(new BorderLayout(0, 0));
    setContentPane(contentPane);
    JPanel panel = new JPanel();
    contentPane.add(panel, BorderLayout.NORTH);
    //添加按钮
    JButton btnNewButton = new JButton("\u6DFB\u52A0");
    btnNewButton.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        AddUsers users = new AddUsers();
        users.setVisible(true);
      }
    });
    panel.add(btnNewButton);
    userName = new JTextField();
    panel.add(userName);
    userName.setColumns(20);
    //查询按钮
    JButton btnNewButton_2 = new JButton("\u67E5\u8BE2");
    btnNewButton_2.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        bind(userName.getText());
      }
    });
    panel.add(btnNewButton_2);
    JPanel panel_1 = new JPanel();
    contentPane.add(panel_1, BorderLayout.SOUTH);
    //删除
    JButton btnNewButton_1 = new JButton("\u9009\u4E2D\u884C\u70B9\u8FD9\u91CC\u5220\u9664");
    btnNewButton_1.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        int i = table.getSelectedRow();
        if (i==-1) {
          JOptionPane.showMessageDialog(null,"请选择删除的行");
          return ;
        }
        String id  = table.getValueAt(i, 0).toString();
        boolean isf = UsersDAO.DeleteById(Integer.parseInt(id));
        if (isf) {
          JOptionPane.showMessageDialog(null, "删除成功！！！");
        } else {
          JOptionPane.showMessageDialog(null, "删除失败！！！");
        }
        bind(null);
      }
    });
    panel_1.add(btnNewButton_1);
    //刷新按钮
    JButton btnNewButton_3 = new JButton("\u6570\u636E\u5237\u65B0");
    btnNewButton_3.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        bind(null);
      }
    });
    panel_1.add(btnNewButton_3);
    JScrollPane scrollPane = new JScrollPane();
    contentPane.add(scrollPane, BorderLayout.CENTER);
    table = new JTable();
    scrollPane.setViewportView(table);
    bind(null);
  }
  //加载数据
  public void bind(String userName) {
    //添加标题
    Vector<String> vTitle  = new Vector<String>();
    vTitle.add("编号");
    vTitle.add("创建时间");
    vTitle.add("用户名");
    vTitle.add("性别");
    vTitle.add("简介");
    //添加数据
    Vector vdate = new Vector<Users>();
    ArrayList<Users> list = UsersDAO.GetInfo(userName);
    for (Users u : list) {
      Vector v = new Vector();
      v.add(u.getId());
      v.add(u.getCreaetDate());
      v.add(u.getUserName());
      v.add(u.getSex());
      v.add(u.getIntroduce());
      vdate.add(v);
    }
    table.setModel(new DefaultTableModel(vdate,vTitle));
  }
}

效果

添加：如果有单选按钮得分组

为了方便操作，别忘改一个控件的名称：

双击添加按钮：

添加编码：

1.

package com.item.ui;
import java.awt.BorderLayout;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import com.item.dao.UsersDAO;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JRadioButton;
import javax.swing.SwingConstants;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import javax.swing.JButton;
import javax.swing.ButtonGroup;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
public class AddUsers extends JFrame {
  private JPanel contentPane;
  private JTextField userName;
  private final ButtonGroup buttonGroup = new ButtonGroup();
  public utest utest;
  /**
   * Launch the application.
   */
  public static void main(String[] args) {
    EventQueue.invokeLater(new Runnable() {
      public void run() {
        try {
          AddUsers frame = new AddUsers();
          frame.setVisible(true);
        } catch (Exception e) {
          e.printStackTrace();
        }
      }
    });
  }
  /**
   * Create the frame.
   */
  public AddUsers() {
    setBounds(100, 100, 589, 457);
    contentPane = new JPanel();
    contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
    setContentPane(contentPane);
    contentPane.setLayout(null);
    JLabel lblNewLabel = new JLabel("\u7528\u6237\u540D");
    lblNewLabel.setBounds(100, 88, 76, 29);
    contentPane.add(lblNewLabel);
    JLabel lblNewLabel_1 = new JLabel("\u7B80\u4ECB");
    lblNewLabel_1.setBounds(100, 209, 54, 15);
    contentPane.add(lblNewLabel_1);
    JRadioButton sex1 = new JRadioButton("\u7537");
    buttonGroup.add(sex1);
    sex1.setSelected(true);
    sex1.setBounds(200, 141, 121, 23);
    contentPane.add(sex1);
    JLabel lblNewLabel_2 = new JLabel("\u6027\u522B");
    lblNewLabel_2.setBounds(100, 145, 54, 15);
    contentPane.add(lblNewLabel_2);
    JRadioButton sex2 = new JRadioButton("\u5973");
    buttonGroup.add(sex2);
    sex2.setBounds(357, 141, 121, 23);
    contentPane.add(sex2);
    userName = new JTextField();
    userName.setBounds(160, 92, 278, 21);
    contentPane.add(userName);
    userName.setColumns(10);
    JTextArea introduce = new JTextArea();
    introduce.setBounds(164, 204, 291, 117);
    contentPane.add(introduce);
    JButton btnNewButton = new JButton("\u6DFB\u52A0");
    btnNewButton.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        String name = userName.getText();
        boolean isf = sex1.isSelected();
        String sex=isf?"男":"女";
        String intro = introduce.getText();
        boolean addInfo = UsersDAO.AddInfo(name, sex, intro);
        JOptionPane.showMessageDialog(null, addInfo?"添加成功！！！":"添加失败！！！");
      }
    });
    btnNewButton.setBounds(231, 357, 93, 23);
    contentPane.add(btnNewButton);
  }
}

1小时学会通过Java Swing Design设计java图形化（3）

5、JDBC

MySQL

JDCB_Demo

封装模型：

UI层添加数据：

热门文章

最新文章

相关课程

相关电子书

相关实验场景