Follow this
String newquery = "SELECT * FROM test";
DatabaseConnection db = new DatabaseConnection();
Connection conn = db.getConnection();
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while (rs.next()){
txtfldName= rs.getString("name");
}
st.close();
rs.close();
conn.close();