У меня проблемы с этим кодом:
String charitysql = "SELECT wardName, charityRoomID FROM tbl_charityward,tbl_charityroom2
WHERE tbl_charityward.charityWardID = tbl_charityroom2.charityWardID";
< /code> < /p>
try {
pst = conn.prepareStatement(charitysql);
rs = pst.executeQuery();
while (rs.next()) {
String wardname = rs.getString("wardName");
cb_ward2.addItem(wardname);
String roomid = rs.getString("charityRoomID");
cb_room2.addItem(roomid);
}
}
catch(Exception e) {
JOptionPane.showMessageDialog(null, e);
}
< /code>
Это моя структура таблиц:
tbl_charityward
charityWardID int NOT NULL AUTO_INCREMENT,
wardName varchar(20),
status varchar(20),
PRIMARY KEY (charityWardID)< /code> < /p>
tbl_charityRoom2
charityRoomID INT NOT NULL AUTO_INCREMENT,
status varchar(20),
charityWardID int,
PRIMARY KEY (charityRoomID, charityWardID),
FOREIGN KEY (charityWardID) REFERENCES tbl_charityward (charityWardID)< /code> < /p>
this is my tables with values:
tbl_charityward
+-------------+----------+--------+
|charityWardID| wardName | status |
+-------------+----------+--------+
|......1......| Surgical |..Open..|
|......2......| .Obygine |..Open..|
|......3......| Pediatric|..Open..|
+-------------+----------+--------+
tbl_charityroom2
+-------------+--------+-------------+
|charityRoomID| status |charityWardID|
+-------------+--------+-------------+
|......1......|..Open..|......1......|
|......2......|..Open..|......1......|
|......3......|..Open..|......2......|
+-------------+--------+-------------+
< /code> < /p>
I have 2 comboBox:
cb_ward2 = which contains wardName
< /code>
cb_room2 = which contains CharityRoomID< /code> < /p>
If I select a wardName from cb_ward2, тогда CB_Room2 покажет соответствующую благотворительную комнату. будет отображаться только на CB_Room2 ,
, но когда я выберу педиатрический , нет благотворительной комнаты. will appear on cb_room2< /code> < /p>
I am using Netbeans and MYSQL
EDIT :
import java.sql.*;
import javax.swing.*;
public class addBed extends javax.swing.JFrame {
Connection conn = null;
ResultSet rs = null;
PreparedStatement pst = null;
/**
* Creates new form addBed
*/
public addBed() {
initComponents();
}
void loadcombo() {
try {
String charitysql = "SELECT wardName, charityRoomID FROM tbl_charityward, tbl_charityroom2 WHERE tbl_charityward.charityWardID = ?";
pst = conn.prepareStatement(charitysql);
pst.setInt(1,tbl_charityroom2.charityWardID);
rs = pst.executeQuery();
while (rs.next()) {
cb_ward2.addItem(rs.getString(1));
cb_room2.addItem(rs.getString(2));
}
}
catch(Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void formWindowOpened(java.awt.event.WindowEvent evt) {
conn = myconn.ConnectDb();
loadcombo();
}
private void btn_add2ActionPerformed(java.awt.event.ActionEvent evt) {
}
Подробнее здесь: https://stackoverflow.com/questions/215 ... eans-mysql
