jdbc problem

follow the following steps:




1: load the database driver

2: Stablish a connection between your program and your database

3: Create an SQL statement

4: Execute it



5: if the execution returns a result set then access your date returned by the database through the resuleset.



6: close the connection.







try this out



import java.sql.*;



public class ConnectinTest {



public void getValue() throws SQLException,ClassNotFoundException{

String str = "select name from username";

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "username", "password");

Statement st = con.createStatement();

ResultSet rs = st.executeQuery(str);



while(rs.next()) {

System.out.println("name: "+rs.getString(1));

}

}



public static void main(String args[]) throws SQLException,ClassNotFoundException {

new ConnectinTest().getValue();

}