This a question please

schools     grades
-------    --------
havard       90%

with this table, i want to select the information in each column concatenate them and ouput the results in a textfeild.
sample output = havard/90%

so can you declare a column in mysql as a variable in java?
if yes then please attach some examples thank you.

3 Years
Discussion Span
Last Post by Benjamin_4

You have to execute a SELECT statement via Java's JDBC SQL support, then you get a ResultSet that contains the data in Java variables.
Just Google for JDBC tutorials

Edited by JamesCherrill


This code displays this string FC/SW/OE/SW/100
based on the selection of the 'Desc Code'(combobox) and 'item Code'(combobox)

 String procedure;
    String efault = "FC";
    String db_trial;
    String iCode; 

 ComboBox_itemCode.addItemListener(new ItemListener(){
        public void itemStateChanged(ItemEvent arg0) {
            // Combine your different comboboxes here
            iCode =(String)ComboBox_itemCode.getSelectedItem();              
            procedure = (String) ComboBox_decCode.getSelectedItem();


this is a method i wrote to select the items in the columns of my database which you told me to but it gives me all the data under that column instead of one.

public void veiwTable(){
        String sql = "select Description_Code from items";
        rs = pst.executeQuery(sql);

         while (rs.next()) {
         String descCode = rs.getString("Description_Code");



    }catch(Exception e){

the idea is if i select 'desc code' and 'item code' from my app it should add descCode from my database to the results by way of concatenation.

i hope my problem is clear


It seems you have not yet covered how to use SQL to select or update data. The Java support and tutorials all assume you alreadfy know the required SQL. Maybe a web tutorial on simple SQL for beginners would help at his stage?

ps: You can add images to a database, retrieve them, and display them, all from Java. But maybe you should master doing it with Strings first.

Edited by JamesCherrill


i was saying i wanted to add an image to my post so that u can understand my problem very well


Oh, OK. There's a "Files" button at the top of the text entry box (between List and Undo). Just click on that and browse to your image file.

Edited by JamesCherrill


so when i select 'desc Code' it should appear in item code in this form

Attachments ###.jpg 59.84 KB

so in this case LB/
i wrote this to do that but it is giving me redundancy
instead of showing only 'LB/',it shows more than one 'LB/'
so now how can i make it show only the one selected item
and when i select another item in 'desc code' it should change in the 'item code' too

i hope this makes my question clearer

Attachments ###.jpg 59.15 KB
  • this question is about business rules, logics not about Java & JDBC,

  • by default most of profesional apps for trading has very similair structure and concept

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.