Latest ads

Electronics
Vehicles
Property
Search

java help needed

Jack_Sparrow

Jack_Sparrow

Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    Kasun k said:
    Ane machan jack, Matath ona ACCESS DB akak edan JTable akakata daganna. mamath methana podi help akak ella gannada?????
    Click to expand...

    mama access DB nam danne nee kollo :baffled:
    bt jtable nam mehema puluwan

    Code: 
    [COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.awt.BorderLayout;[/COLOR]

[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]javax.swing.JFrame;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]javax.swing.JScrollPane;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]javax.swing.JTable;[/COLOR]

[COLOR=#7f0055][B]public class [/B][/COLOR][COLOR=#000000]JTableCreatingDemo [/COLOR][COLOR=#000000]{[/COLOR]
[COLOR=#ffffff]  [/COLOR][COLOR=#7f0055][B]public static [/B][/COLOR][COLOR=#7f0055][B]void [/B][/COLOR][COLOR=#000000]main[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]String args[/COLOR][COLOR=#000000][]) {[/COLOR]
[COLOR=#ffffff]    [/COLOR][COLOR=#000000]JFrame frame = [/COLOR][COLOR=#7f0055][B]new [/B][/COLOR][COLOR=#000000]JFrame[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff]    [/COLOR][COLOR=#000000]frame.setDefaultCloseOperation[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]JFrame.EXIT_ON_CLOSE[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]

[COLOR=#ffffff]    [/COLOR][COLOR=#000000]Object rowData[/COLOR][COLOR=#000000][][] [/COLOR][COLOR=#000000]= [/COLOR][COLOR=#000000]{ { [/COLOR][COLOR=#2a00ff]"Row1-Column1"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row1-Column2"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row1-Column3" [/COLOR][COLOR=#000000]}[/COLOR][COLOR=#000000],[/COLOR]
[COLOR=#ffffff]        [/COLOR][COLOR=#000000]{ [/COLOR][COLOR=#2a00ff]"Row2-Column1"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row2-Column2"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row2-Column3" [/COLOR][COLOR=#000000]} }[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff]    [/COLOR][COLOR=#000000]Object columnNames[/COLOR][COLOR=#000000][] [/COLOR][COLOR=#000000]= [/COLOR][COLOR=#000000]{ [/COLOR][COLOR=#2a00ff]"Column One"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Column Two"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Column Three" [/COLOR][COLOR=#000000]}[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff]    [/COLOR][COLOR=#000000]JTable table = [/COLOR][COLOR=#7f0055][B]new [/B][/COLOR][COLOR=#000000]JTable[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]rowData, columnNames[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]

[COLOR=#ffffff]    [/COLOR][COLOR=#000000]JScrollPane scrollPane = [/COLOR][COLOR=#7f0055][B]new [/B][/COLOR][COLOR=#000000]JScrollPane[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]table[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff]    [/COLOR][COLOR=#000000]frame.add[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]scrollPane, BorderLayout.CENTER[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff]    [/COLOR][COLOR=#000000]frame.setSize[/COLOR][COLOR=#000000]([/COLOR][COLOR=#990000]300[/COLOR][COLOR=#000000], [/COLOR][COLOR=#990000]150[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff]    [/COLOR][COLOR=#000000]frame.setVisible[/COLOR][COLOR=#000000]([/COLOR][COLOR=#7f0055][B]true[/B][/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]

[COLOR=#ffffff]  [/COLOR][COLOR=#000000]}[/COLOR]


    metana athin demma values wenuwata select query eken lebena values demmama hari
     
    Kasun k

    Kasun k

    Well-known member
  • Mar 11, 2009
    10,357
    492
    83
    United States
    Jack_Sparrow said:
    mama access DB nam danne nee kollo :baffled:
    bt jtable nam mehema puluwan

    Code: 
    [COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.awt.BorderLayout;[/COLOR]

[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]javax.swing.JFrame;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]javax.swing.JScrollPane;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]javax.swing.JTable;[/COLOR]

[COLOR=#7f0055][B]public class [/B][/COLOR][COLOR=#000000]JTableCreatingDemo [/COLOR][COLOR=#000000]{[/COLOR]
[COLOR=#7f0055][B]public static [/B][/COLOR][COLOR=#7f0055][B]void [/B][/COLOR][COLOR=#000000]main[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]String args[/COLOR][COLOR=#000000][]) {[/COLOR]
[COLOR=#000000]JFrame frame = [/COLOR][COLOR=#7f0055][B]new [/B][/COLOR][COLOR=#000000]JFrame[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#000000]frame.setDefaultCloseOperation[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]JFrame.EXIT_ON_CLOSE[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]

[COLOR=#000000]Object rowData[/COLOR][COLOR=#000000][][] [/COLOR][COLOR=#000000]= [/COLOR][COLOR=#000000]{ { [/COLOR][COLOR=#2a00ff]"Row1-Column1"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row1-Column2"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row1-Column3" [/COLOR][COLOR=#000000]}[/COLOR][COLOR=#000000],[/COLOR]
[COLOR=#000000]{ [/COLOR][COLOR=#2a00ff]"Row2-Column1"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row2-Column2"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Row2-Column3" [/COLOR][COLOR=#000000]} }[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#000000]Object columnNames[/COLOR][COLOR=#000000][] [/COLOR][COLOR=#000000]= [/COLOR][COLOR=#000000]{ [/COLOR][COLOR=#2a00ff]"Column One"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Column Two"[/COLOR][COLOR=#000000], [/COLOR][COLOR=#2a00ff]"Column Three" [/COLOR][COLOR=#000000]}[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#000000]JTable table = [/COLOR][COLOR=#7f0055][B]new [/B][/COLOR][COLOR=#000000]JTable[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]rowData, columnNames[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]

[COLOR=#000000]JScrollPane scrollPane = [/COLOR][COLOR=#7f0055][B]new [/B][/COLOR][COLOR=#000000]JScrollPane[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]table[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#000000]frame.add[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]scrollPane, BorderLayout.CENTER[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#000000]frame.setSize[/COLOR][COLOR=#000000]([/COLOR][COLOR=#990000]300[/COLOR][COLOR=#000000], [/COLOR][COLOR=#990000]150[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#000000]frame.setVisible[/COLOR][COLOR=#000000]([/COLOR][COLOR=#7f0055][B]true[/B][/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]

[COLOR=#000000]}[/COLOR]
    metana athin demma values wenuwata select query eken lebena values demmama hari
    Click to expand...

    elaz. but machan mata tikak detail ona. mama JTable karalama na. thaniyen thama JTable egena ganne. so kiyala denna puluwan nam liku deyak. Kagawa hari PDF akakwath nadda???? :nerd:
     
    Jack_Sparrow

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    amilabanuka said:
    Jack where do you have the problem in the front end or the back end?
    Click to expand...

    front end back end kiwe :baffled:

    mekai ban mata DB ekak set karapu ekak oni, mama den taniyama tikak karagatta DB eka connect kara anan manan
    bt karapu ekaka interface balaganna thama oni
    values text boxes or tables walata daganna heti
    ee wage ewa :D
     
    Jack_Sparrow

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    Kasun k said:
    raws columns add wena hati therenne naththe. Two D array akak gannath ona neda???
    Click to expand...

    mehemai meka nikan 2D array dekak tamai
    bt type eka OBJECT

    eka 2D array ekak gannawa ROWs wala values walata-rowDatap[p[
    anith 2D array eka gannawa coloumns wala names walata - columnName[][]

    Code: 
    Object rowData[][] = { { "Row1-Column1", "Row1-Column2", "Row1-Column3" },
{ "Row2-Column1", "Row2-Column2", "Row2-Column3" } };

Object columnNames[] = { "Column One", "Column Two", "Column Three" };

    pase ee object array deka pass karanawa table eka hadaddi

    Code: 
    [COLOR=#000000]JTable table = [/COLOR][COLOR=#7f0055][B]new [/B][/COLOR][COLOR=#000000]JTable[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]rowData, columnNames[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
     
    Jack_Sparrow

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    MYSQL walata select queriak WHERE ekak ekka AND use karalaCOLUMN dekak compare karala results ganna bene AND or and & thunama weradiy kiyanawa , thunen ekak wath hari nelu

    21crya0.jpg


    bt ewa MYSQL wala gehuwama weda karanawa
    1zvwfgn.jpg



     
    geethq

    geethq

    Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    Jack_Sparrow said:
    MYSQL walata select queriak WHERE ekak ekka AND use karalaCOLUMN dekak compare karala results ganna bene AND or and & thunama weradiy kiyanawa , thunen ekak wath hari nelu

    21crya0.jpg


    bt ewa MYSQL wala gehuwama weda karanawa
    1zvwfgn.jpg



    Click to expand...
    එහෙන ගන්න බෑ බන්
    උඹට හරියටම මොකද්ද වෙන්න ඕනි කියපන්
     
    Jack_Sparrow

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    Santa said:
    jJackasPost.setVisible(false);

    apita owa penne nalu.. :P

    ado wade kara gattada?? mokadda awula?
    Click to expand...
    eeka abstract class ekaka tiyenne :P
    uba child bota beee over ride koranna heka heka :P

    kara gatte nee ban tawa karanawa :(
    mekai ban
    SELECT query wala
    WHERE waladi
    api column dekak use karaddi AND or and or & use karanawane
    bt mee netbeans walin ara query wala eeka daana belu :eek:
     
    geethq

    geethq

    Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    Jack_Sparrow said:
    seselect *
    from student
    where st_id=1 and sub_id=2

    mee wage ekak kohomada ethakota karanne netbeans walin :eek:
    Click to expand...

    AND ta kalin thiyena , eka remove karanna :D
    nathnam ithin
    IF {}ekak danna
    ekakin select unoth hari nathnam else{} kiyala aye sub_id 2 eka dala aye connect karanna :D
     
    Last edited:
    Jack_Sparrow

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    geethq said:
    AND ta kalin thiyena , eka remove karanna :D
    nathnam ithin
    for {}ekak danna
    ekakin select unoth hari nathnam else{} kiyala aye sub_id 2 eka dala aye connect karanna :D
    Click to expand...

    , eka den dekke :shocked:
    mama AND dala berima thena , dalath beluwa
    passe screeenshot ekak daanna AND aye type kala , makanna beri una
     

    Similar threads

    sachi911
    Android, JAVA ListView Help
    Replies
    1
    Views
    623
    hodakolla
    hodakolla
    A
    Java Help!
    Replies
    16
    Views
    2K
    niyomax
    niyomax
    Love kolla
    මොකක්ද බං මේකෙ අවුල?? (JAVA HELP)
    Replies
    10
    Views
    1K
    hodakolla
    hodakolla
    dhanush_c
    Java සමග Mysql Database එකක් භාවිතා කිරීම – 1
    Replies
    9
    Views
    1K
    Mandalorian
    Mandalorian
    rock pora
    Servlet JDBC help
    Replies
    14
    Views
    1K
    hodakolla
    hodakolla
    Top Bottom