java help needed
java karana kawuru hari gawa tiyanawada MYSQL Db ekata connect karala tiyana
java interface ekka tiyana sample ekak
meka mama wizard eka hadapu ekak meka wedak ne
mata oni mee wage connect strings dala hadapuekak
mehcchara dewal onet nee text boxes tikai ADD , UPDATE , DELETE buttons tibbama ethi
tiyanwanam upload karanna
thanks
//////////////////////////
EDITED--------------
ethi yantham me tika karagatta
udaw karanna try karapu aya and udaw karapy miyaru, geethq ta thanks wewa
java karana kawuru hari gawa tiyanawada MYSQL Db ekata connect karala tiyana
java interface ekka tiyana sample ekak

meka mama wizard eka hadapu ekak meka wedak ne
mata 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]
mehcchara dewal onet nee text boxes tikai ADD , UPDATE , DELETE buttons tibbama ethi
tiyanwanam upload karanna
thanks
//////////////////////////
EDITED--------------
ethi yantham me tika karagatta
udaw karanna try karapu aya and udaw karapy miyaru, geethq ta thanks wewa
Last edited:

