Reply to thread

Message: <blockquote data-quote="v7soft" data-source="post: 11882917" data-attributes="member: 121104">google karapna ban karapan ona tharam ex tiyanwa  .[CODE][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][/CODE]mulin DSN akak hadala hitpan me balapan <a href="http://support.microsoft.com/kb/305599" target="_blank">http://support.microsoft.com/kb/305599</a></blockquote>

Verification: Awruddata maasa keeyada?

Top Bottom