jtable连接mysql数据库_关于JTable 连接数据库读取数据及删除

简单测试

1.首先把jtable放到JFrame里面的

2.从数据库读取数据设置到table里面的

3.根据分数在数据里面order by asc/desc

4.删除选择的( int index = this.getSelectedRow();

((DefaultTableModel) this.getModel()).removeRow(index))

然后在调用数据库里面的方法delete

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

import java.util.Vector;

import javax.swing.*;

import javax.swing.table.DefaultTableModel;

public class DisplayEmpData extends JFrame implements ActionListener {

JFrame frame1;

JLabel l0, l1, l2;

JComboBox c1;

JButton b1;

Connection con;

ResultSet rs, rs1;

Statement st, st1;

PreparedStatement pst;

String ids;

static JTable table;

String[] columnNames = {"User name", "Email", "Password", "Country"};

String from;

Displa