Data base related question

sir my table has only one element(that is pno),i am using ms-access as backend. i put only one element i want to retrieve that element .how can i retrieve that element,using jdbc technology.

please csee my code

import java.sql.*;

class raja {

int regd1; public int k() {

try {

Connection con2=null; Statement stmt2=null; ResultSet rs2=null; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con2=DriverManager.getConnection("jdbc:odbc:oldp");

stmt2=con2.createStatement(); String st2="select * from pname order by pno"; System.out.println(""+st2.toString());

rs2=stmt2.executeQuery(st2); System.out.println("hi"); while(rs2.next()) regd1=rs2.getInt(1); else System.out.println("hi");

stmt2.close(); con2.close(); } catch(Exception e) { e.printStackTrace(); }

return regd1; } public static void main(String args[]) { raja p=new raja(); p.k(); } } //could you please tell me the way.