ace cho e hỏi với ạ,giúp e với ạ ,e ngồi cả ngày rồi , e muốn hiển thị giá trị đếm được trog sql lên JTEXTFIEL ,mà k biết chạy code sql bị lôi đau k ,giúp e với ạ
package Quanlybaiguixe;
import java.awt.BorderLayout;
import java.awt.EventQueue;
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 java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.border.EmptyBorder;
import javax.swing.table.DefaultTableModel;
import com.mysql.jdbc.CallableStatement;
public class thoigian extends JFrame {
private JPanel contentPane;
private JTable table;
private DefaultTableModel model;
private JButton b1, b2, b3, b4, b5,b6;
private JPanel panel, p;
private JLabel l1,l2,l3,l4;
private JScrollPane scrollPane;
private JTextField tx;
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
@Override
public void run() {
// TODO Auto-generated method stub
try {
thoigian l = new thoigian();
l.setVisible(true);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
});
}
public thoigian() throws ClassNotFoundException, SQLException {
this.setTitle("Số chỗ");
this.setBounds(300, 200, 400, 300);
contentPane = new JPanel();
contentPane.setLayout(null);
this.setContentPane(contentPane);
String [] a = {"1", "2", "3", "4"};
JComboBox list = new JComboBox(a);
list.setSelectedIndex(3);
list.setBounds(110, 75, 90, 20);
contentPane.add(list);
tx=new JTextField();
tx.setBounds(110, 110, 90,20);
contentPane.add(tx);
list.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
if (list.getSelectedItem() == "1") {
updateModel1();
} else if (list.getSelectedItem() == "2") {
updateModel2();
} else if (list.getSelectedItem() == "3") {
updateModel3();
} else {
updateModel4();
}
}
});
}
public void updateModel1() {
model = new DefaultTableModel();
model.addColumn("TONGSOCHO");
try {
int count=0;
Class.forName("com.mysql.jdbc.Driver");
String db_url = "jdbc:mysql://127.0.0.1/quanlybaiguixe";
String db_user = "ntminh2";
String db_pass = "123456";
Connection conn = null;
conn = DriverManager.getConnection(db_url, db_user, db_pass);
String number1=tx.getText();
String sql = "SELECT COUNT(*) FROM luotguixe WHERE MABAI=1";
PreparedStatement stmt=conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while(rs.next()) {
tx.setText(String.valueOf(rs.getInt(1)));
}
conn.close();
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
table.setModel(model);
}
public void updateModel2() {
}
public void updateModel3() {
}
public void updateModel4() {
}
}