java help needed

geethq

Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    mama INT kale nee mokada
    api method eken pass karanne okkoma ekata hadapu STRING ekak nisa
    ao int okkoma string wena nisa

    sure da balamuko ehenam karala :)
    na ban uba sql database eke student id eke data type eka number kiyala damma nam ekata aniwa yawanna oni int ekak :D string yawwoth runtime error
     

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    na ban uba sql database eke student id eke data type eka number kiyala damma nam ekata aniwa yawanna oni int ekak :D string yawwoth runtime error

    SQL ekedi int da nedda kiyala identify wenne ' ' dala nettam neda

    mama ara uba kiyapu widiyata kala eeth enawa ban error ekak
    mee mata catch ekedi apu error eka mama alert box ekakin display kale :eek:
    6svviq.jpg
     

    geethq

    Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    try {
    String str="SELECT * FROM DVD WHERE SearchTag='"+DVDtag+"' OR DVDNo='"+DVDtag+"' ";

    me code eka yasa apuruwata wada :D
    oya DVDtag kiyana eka ekama text field eken ganne
    OR dammath AND dammath wada :D
     

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    try {
    String str="SELECT * FROM DVD WHERE SearchTag='"+DVDtag+"' OR DVDNo='"+DVDtag+"' ";

    me code eka yasa apuruwata wada :D
    oya DVDtag kiyana eka ekama text field eken ganne
    OR dammath AND dammath wada :D

    ekane ban mama uba kiyapu widiyata int walata cnvert karalat mata enawaneee ara AND eka SQL version ekata support nee kiyala
    bt AND thama ee SQL wala weda karanne
    2aha985.jpg
     

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    ehenam yako aniwa SELECT karanakota intiger ekak epay denna mama kiyannam data base eka wenas karala ekatath String /text dipan , code eka kalin thibba widiyatama thiyapan ara " , " nathuwa , hari yanna oni :)

    ow ow , eka mama pissuwak natala demme
    nee ban eeth weda nee :baffled:

    nmama uba kiyapu widiyata ethana dena eka convert kala int walata bt eeka nemei case eka kiyanne
    ara AND eka
     

    geethq

    Well-known member
  • Sep 17, 2006
    49,949
    3,213
    113
    ~ඤාව්~
    .


    String str="SELECT * FROM DVD WHERE SearchTag=
    ' " +L22.getText()+ " ' AND SearchNo= ' " +No21.getText()+ " ' " ;

    onna ona widiyatama eka " ekak ' ekak , ekak wath halanne nathuwa dapan :P nathnam syntax error






    :nerd:
     
    Last edited:

    Jack_Sparrow

    Well-known member
  • Jun 16, 2008
    42,522
    1
    16,927
    113
    Black Pearl
    String str="SELECT * FROM DVD WHERE SearchTag= ' " +L22.getText()+ " ' AND SearchNo= ' " +No21.getText()+ " ' " ;

    onna ona widiyatama eka " ekak ' ekak , ekak wath halanne nathuwa dapan :P nathnam syntax error :nerd:

    adee owneee den hariii
    mama eka ' ekak maga erala gon buruwa wage :P