Reply to thread

Message: <blockquote data-quote="Jack_Sparrow" data-source="post: 7284794" data-attributes="member: 106688">java help neededjava karana kawuru hari gawa tiyanawada MYSQL Db ekata connect karala tiyanajava interface ekka tiyana sample ekak <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /><img src="http://i43.tinypic.com/a0uvd1.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />meka mama wizard eka hadapu ekak meka wedak nemata oni mee wage  connect strings dala hadapuekak[CODE][COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.sql.*;[/COLOR][COLOR=#7f0055][B]public class [/B][/COLOR][COLOR=#000000]GetAllRows[/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[/COLOR][COLOR=#000000][] [/COLOR][COLOR=#000000]args[/COLOR][COLOR=#000000]) {[/COLOR][COLOR=#000000]System.out.println[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"Getting All Rows from a table!"[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]Connection con = [/COLOR][COLOR=#7f0055][B]null[/B][/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]String url = [/COLOR][COLOR=#2a00ff]"jdbc:mysql://localhost:3306/"[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]String db = [/COLOR][COLOR=#2a00ff]"jdbctutorial"[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]String driver = [/COLOR][COLOR=#2a00ff]"com.mysql.jdbc.Driver"[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]String user = [/COLOR][COLOR=#2a00ff]"root"[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]String pass = [/COLOR][COLOR=#2a00ff]"root"[/COLOR][COLOR=#000000];[/COLOR][COLOR=#7f0055][B]try[/B][/COLOR][COLOR=#000000]{[/COLOR][COLOR=#000000]Class.forName[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]driver[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000].newInstance[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]con = DriverManager.getConnection[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]url+db, user, pass[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#7f0055][B]try[/B][/COLOR][COLOR=#000000]{[/COLOR][COLOR=#000000]Statement st = con.createStatement[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]ResultSet res = st.executeQuery[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"SELECT * FROM  employee6"[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]System.out.println[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"Emp_code: " [/COLOR][COLOR=#000000]+ [/COLOR][COLOR=#2a00ff]"\t" [/COLOR][COLOR=#000000]+ [/COLOR][COLOR=#2a00ff]"Emp_name: "[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#7f0055][B]while [/B][/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]res.next[/COLOR][COLOR=#000000]()) {[/COLOR][COLOR=#7f0055][B]int [/B][/COLOR][COLOR=#000000]i = res.getInt[/COLOR][COLOR=#000000]([/COLOR][COLOR=#990000]"Emp_code"[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]String s = res.getString[/COLOR][COLOR=#000000]([/COLOR][COLOR=#990000]"Emp_name"[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]System.out.println[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]i + [/COLOR][COLOR=#2a00ff]"\t\t" [/COLOR][COLOR=#000000]+ s[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]}[/COLOR][COLOR=#000000]con.close[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]}[/COLOR][COLOR=#7f0055][B]catch [/B][/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]SQLException s[/COLOR][COLOR=#000000]){[/COLOR][COLOR=#000000]System.out.println[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"SQL code does not execute."[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]}    [/COLOR][COLOR=#000000]}[/COLOR][COLOR=#7f0055][B]catch [/B][/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]Exception e[/COLOR][COLOR=#000000]){[/COLOR][COLOR=#000000]e.printStackTrace[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR][COLOR=#000000]}[/COLOR][COLOR=#000000]}[/COLOR][COLOR=#000000]}[/COLOR][/CODE]mehcchara dewal onet nee text boxes tikai ADD , UPDATE , DELETE buttons tibbama ethitiyanwanam upload karanna <img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /> thanks //////////////////////////EDITED-------------- ethi yantham me tika karagatta  udaw karanna try karapu aya and udaw karapy miyaru, geethq ta thanks wewa <img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /> </blockquote>

Verification: Winadiyakata thappara keeyak tibeda?

Top Bottom