Haris Tasawar

actually, your right Eric... this array is basically in a JSON object and the code is:

Sale = new JSONObject();
Sale.put("payment", new JSONArray());

and then after i have updated a JSON object which contains the values, i fill the JSON array like this:


int currentIndex = 0;
currentIndex = Sale.getJSONArray("payment").size();
Sale.getJSONArray("payment").add(currentIndex,pay);


Where, pay is a JSON object of all the values.

Hello all,
I have a JSON array named "payments" which contain these fields:

1. product name
2. amount
3. change

Now, i have to add another key named "batchid" with value "1" to this JSONArray. How can i push another key with its respected value to this array? Please any help would be appreciated.

Thanks,
Harry.

well it does not give an error when i am compiling it, it actually give me an error as soon as i declare the above LOC:


The type of the expression must be an array type but it resolved to Object

Hey all,
I have a JSON object named "Sale" which contains a JSONarray named "Lineitems". Now this array contains three fields (id,name,quantity) but i only want to access the field named quantity and save it as an object in the object variable named "Params". How can i accomplish this:

i recently tried this Line of code:

Params = Sale.getJSONArray.("lineitems").get(2);

but this gives me an error saying Params should be a JSONArray variable not with type "object".

Please help... i want this data to be retrieved and saved as an object.

Thanks......


Harry.

and as for the border layout, is is possible to implement two Jtables in the center, maybe it isnt, also i put the Revalidate() method and still i see no table?

i am sorry for the bad programming, its just that i didnt had it in mind when i was creating the project, i would surely re implement the code using different classes for sure, from next time i would make sure that i used proper formatting of the post.... Sorry about that, anyways i would do the revalidate and let you guys know

hey guys,
I am running into a problem and i need help, i basically have a jframe with two JPanels which would hold the JScrollpanes of jtables, there are also two JTextFields who would act as a search bar for populating the the Jtable, the programming of data is done correctly but i am running into a problem, the second Jtable does not show until and unless i resize the jframe window, i cant get it to work. I have tried validate(), update(), setvisible() but it wont work,

Please guys i need your help.

I have add screenshots for reference and the code i given below:


Thanks.



public class Search { private static JFrame frame; private static JTextField textField; private static JTextField textField_1; public static void SetupJframe(){ Toolkit tl = Toolkit.getDefaultToolkit(); final int he=tl.getScreenSize().height; final int wi=tl.getScreenSize().width; try{ for (LookAndFeelInfo info : UIManager.getInstalledLookAndFeels()) { System.out.println(info.getName()); if ("Nimbus".equals(info.getName())) { UIManager.setLookAndFeel(info.getClassName()); break; } } } catch(Exception e){ } frame = new JFrame(); frame.setBounds(0, 0, wi, he); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.getContentPane().setLayout(null); } public static void main( String[] args ) { SetupJframe(); textField = new JTextField(); textField.setFont(new Font("Tahoma", Font.BOLD, 16)); textField.setBounds(51, 11, 160, 32); frame.getContentPane().add(textField); textField.setColumns(10); final JPanel panel = new JPanel(); panel.setBounds(23, 65, 473, 480); panel.setLayout(null); JButton btnNewButton = new JButton("SearchID"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent arg0) { String s = textField.getText(); Vector columnNames = new Vector(); Vector data = new Vector(); Connection connection = null; try{ Class.forName("org.firebirdsql.jdbc.FBDriver"); connection = DriverManager .getConnection( "jdbc:firebirdsql://localhost:3050/C:/FIREBIRDDB/north.FDB", "sysdba", "weibrkjock374"); // Read data from a table String sql = "SELECT a.LOGINID,a.CUSTOMERID,a.TOTALAMOUNT,a.ORIGNALAMOUNT,a.AMOUNT,a.DATETIME,a.KIOSKID FROM UNPOSTEDTRANSACTIONSSSGC a WHERE a.CUSTOMERID= "+s; Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery( sql ); ResultSetMetaData md = rs.getMetaData(); int columns = md.getColumnCount(); // Get column names for (int i = 1; i <= columns; i++) { columnNames.addElement( md.getColumnName(i) ); } // Get row data while (rs.next()) { Vector row = new Vector(columns); for (int i = 1; i <= columns; i++) { row.addElement( rs.getObject(i) ); } data.addElement( row ); } rs.close(); stmt.close(); connection.close(); } catch(Exception e) { System.out.println( e ); } // Create table with database data JTable table = new JTable(data, columnNames) { public Class getColumnClass(int column) { for (int row = 0; row < getRowCount(); row++) { Object o = getValueAt(row, column); if (o != null) { return o.getClass(); } } return Object.class; } }; table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); table.getColumnModel().getColumn(0).setPreferredWidth(200); table.getColumnModel().getColumn(1).setPreferredWidth(120); table.getColumnModel().getColumn(2).setPreferredWidth(120); table.getColumnModel().getColumn(3).setPreferredWidth(120); table.getColumnModel().getColumn(4).setPreferredWidth(150); table.getColumnModel().getColumn(5).setPreferredWidth(120); table.getColumnModel().getColumn(6).setPreferredWidth(150); JScrollPane scrollPane = new JScrollPane( table ); scrollPane.setBounds(23, 65, 408, 160); scrollPane.setSize(408, 160); panel.add(scrollPane); try { connection.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }); btnNewButton.setBounds(253, 18, 91, 23); frame.getContentPane().add(btnNewButton); frame.getContentPane().add(panel); textField_1 = new JTextField(); textField_1.setFont(new Font("Tahoma", Font.BOLD, 16)); textField_1.setColumns(25); textField_1.setBounds(689, 11, 160, 32); frame.getContentPane().add(textField_1); JButton button = new JButton("Search"); button.setBounds(889, 18, 91, 23); frame.getContentPane().add(button); final JPanel panel_1 = new JPanel(); panel_1.setBounds(533, 65, 473, 480); button.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent arg0) { Vector columnNames = new Vector(); Vector data = new Vector(); Connection connection = null; try{ Class.forName("org.firebirdsql.jdbc.FBDriver"); connection = DriverManager .getConnection( "jdbc:firebirdsql://localhost:3050/C:/FIREBIRDDB/north.FDB", "sysdba", "weibrkjock374"); // Read data from a table //String s1 = textField_1.getText(); String sql = "SELECT * FROM TBLCASHTRANSACTION WHERE LOGINID = '"+ textField_1.getText() + "'"; //String sql = "SELECT * FROM TBLCASHTRANSACTION WHERE LOGINID = "+s1; Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery( sql ); ResultSetMetaData md = rs.getMetaData(); int columns = md.getColumnCount(); // Get column names for (int i = 1; i <= columns; i++) { columnNames.addElement( md.getColumnName(i) ); } // Get row data while (rs.next()) { Vector row = new Vector(columns); for (int i = 1; i <= columns; i++) { row.addElement( rs.getObject(i) ); } data.addElement( row ); } rs.close(); stmt.close(); connection.close(); } catch(Exception e) { System.out.println( e ); } // Create table with database data JTable table1 = new JTable(data, columnNames) { public Class getColumnClass(int column) { for (int row = 0; row < getRowCount(); row++) { Object o = getValueAt(row, column); if (o != null) { return o.getClass(); } } return Object.class; } }; table1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); table1.getColumnModel().getColumn(0).setPreferredWidth(200); table1.getColumnModel().getColumn(1).setPreferredWidth(120); table1.getColumnModel().getColumn(2).setPreferredWidth(120); table1.getColumnModel().getColumn(3).setPreferredWidth(120); table1.getColumnModel().getColumn(4).setPreferredWidth(150); table1.getColumnModel().getColumn(5).setPreferredWidth(120); table1.getColumnModel().getColumn(6).setPreferredWidth(150); table1.getColumnModel().getColumn(7).setPreferredWidth(126); table1.getColumnModel().getColumn(8).setPreferredWidth(120); table1.getColumnModel().getColumn(9).setPreferredWidth(120); table1.getColumnModel().getColumn(10).setPreferredWidth(120); JScrollPane scrollPane1 = new JScrollPane(table1); scrollPane1.setBounds(571, 65, 408, 160); //scrollPane1.setSize(408, 160); panel_1.add(scrollPane1); panel_1.repaint(); frame.getContentPane().add(panel_1); } }); frame.validate(); frame.setVisible( true ); } }

ok an easy way to put this is (encrypting aside) is that i just want to encrypt the database Username and Password in hibernate.cfg.xml. So i started searching and found out this, but if there is any other way to do this then i`ll be cool. Just wanted to know if i had more options.

Hey all,
Could someone tell me a good tutorial of how to integrate jasypt with hibernate... i am having difficulty understanding it from the its official site... please help

Use criteria for retrieving Join table data...

Never had that kind of problem before, check your database and then again try to build the hibernate hbm and class files using hibernate tools

Not sure what kind of annotations...are you talking about join annotations??? as in primary and foreign key annotations

But i recently created an app using null layout.... i agree it was pain and took time but got it done when i got the hang of it..

Just kidding... i mean you guys are right that layouts are suitable but everyone have their choices... maybe that`s why they included it.

LOL.... well if it isnt suited then why is it there???