machnzla mata podi udavvak one..podi java project ekak karaganna beriwa inne..mn java programme eka hadala thiyenne..ekata enter karana data access database ekaka save vena vidiyata hadanna one..danna kauru hari eka karala dennako please.
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.sql.Connection;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.sql.DriverManager;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.sql.ResultSet;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.sql.ResultSetMetaData;[/COLOR]
[COLOR=#7f0055][B]import [/B][/COLOR][COLOR=#000000]java.sql.Statement;[/COLOR]
[COLOR=#ffffff][/COLOR]
[COLOR=#7f0055][B]public class [/B][/COLOR][COLOR=#000000]Main [/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[/COLOR][COLOR=#000000][] [/COLOR][COLOR=#000000]args[/COLOR][COLOR=#000000]) [/COLOR][COLOR=#7f0055][B]throws [/B][/COLOR][COLOR=#000000]Exception [/COLOR][COLOR=#000000]{[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]Connection conn = getConnection[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]Statement st = conn.createStatement[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#3f7f5f]// st.executeUpdate("drop table survey;");[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]st.executeUpdate[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"create table survey (id int,name varchar(30));"[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]st.executeUpdate[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"insert into survey (id,name ) values (1,'nameValue')"[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]st = conn.createStatement[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]ResultSet rs = st.executeQuery[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"SELECT * FROM survey"[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]ResultSetMetaData rsMetaData = rs.getMetaData[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#7f0055][B]int [/B][/COLOR][COLOR=#000000]numberOfColumns = rsMetaData.getColumnCount[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]System.out.println[/COLOR][COLOR=#000000]([/COLOR][COLOR=#2a00ff]"resultSet MetaData column Count=" [/COLOR][COLOR=#000000]+ numberOfColumns[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]st.close[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]conn.close[/COLOR][COLOR=#000000]()[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]}[/COLOR]
[COLOR=#ffffff][/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#7f0055][B]private static [/B][/COLOR][COLOR=#000000]Connection getConnection[/COLOR][COLOR=#000000]() [/COLOR][COLOR=#7f0055][B]throws [/B][/COLOR][COLOR=#000000]Exception [/COLOR][COLOR=#000000]{[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]String driver = [/COLOR][COLOR=#2a00ff]"sun.jdbc.odbc.JdbcOdbcDriver"[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]String url = [/COLOR][COLOR=#2a00ff]"jdbc:odbc:northwind"[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]String username = [/COLOR][COLOR=#2a00ff]""[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]String password = [/COLOR][COLOR=#2a00ff]""[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#7f0055][B]Class[/B][/COLOR][COLOR=#000000].forName[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]driver[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#7f0055][B]return [/B][/COLOR][COLOR=#000000]DriverManager.getConnection[/COLOR][COLOR=#000000]([/COLOR][COLOR=#000000]url, username, password[/COLOR][COLOR=#000000])[/COLOR][COLOR=#000000];[/COLOR]
[COLOR=#ffffff][/COLOR][COLOR=#000000]}[/COLOR]
[COLOR=#000000]}[/COLOR]







