@FXML public void Selecteditem() throws SQLException { TuserPermission InsertData = (TuserPermission) tableUser.getSelectionModel().getSelectedItem(); selected = InsertData.getId(); String Sql = " SELECT * FROM users WHERE id = '" + InsertData.getId() + "'"; DB.rs = DB.statemen.executeQuery(Sql); if (DB.rs.next()) { User_name.setText(DB.rs.getString("user_name")); pass.setText(DB.rs.getString("pass")); note.setText(DB.rs.getString("note")); CB1.setSelected(DB.rs.getBoolean("permission1")); CB2.setSelected(DB.rs.getBoolean("permission2")); } }
public void FillTable() throws SQLException { System.out.println("FillTable"); data.clear(); count = 0; DB.rs = DB.statemen.executeQuery("SELECT * FROM users"); while (DB.rs.next()) { count++; data.add( new TuserPermission( DB.rs.getInt("id"), DB.rs.getString("user_name"), DB.rs.getString("pass"), DB.rs.getString("note"), DB.rs.getBoolean("permission1"), DB.rs.getBoolean("permission2"))); } CustomerN.setText("" + count); Erromassage.setText(""); }
@FXML public void InsertUser() throws SQLException { int selectedOption = JOptionPane.showConfirmDialog( null, "هل انت متاكد من هذة العملية ؟", "Choose", JOptionPane.YES_NO_OPTION); if (selectedOption == JOptionPane.YES_OPTION) { boolean value1 = CB1.isSelected(); boolean value2 = CB2.isSelected(); DB.rs = DB.statemen.executeQuery( "SELECT * FROM users WHERE user_name ='" + User_name.getText() + "'"); if (User_name.getText().equals("")) { Erromassage.setText("من فضلك ادخل البياناتالمطلوبة"); User_name.requestFocus(); } else if (DB.rs.next()) { Erromassage.setText("هذا الاسم موجود مسبقا"); User_name.requestFocus(); } else { DB.statemen.executeUpdate( "INSERT INTO users( user_name, pass, note, permission1, permission2) VALUES ('" + User_name.getText() + "','" + pass.getText() + "','" + note.getText() + "','" + value1 + "','" + value2 + "')"); FillTable(); clear(); } } }