How to retrieve a String stored in the DB?

[Swapna Mandava]

Hi,

Can some one pls. tell me how to retrieve a string stored in the DB? Which classes are required to accomplish this? Pls. answer my query asap.

Thanks alot,
Swapna

[Bear Bibeault]

Please use real words when posting to the forums. Abbreviations such as "pls" in place of "please" only serve to make your posts more difficult to read and less likely to generate useful responses.

Please read this for more information.

thanks,
bear
JavaRanch sheriff

[kkk guptha]

Hi,
I think Data coming from DB default is String only.
If you want to convert into Integer type, int i = Integer.parseInt(string);


--- KKKGuptha

[Qussay Najjar]

Originally posted by Swapna Mandava:
tell me how to retrieve a string stored in the DB? Which classes are required to accomplish this?
Swapna

do you know how to create Statement, and get your records into a ResultSet? because the value will come by default as String.
if you don't know just inform me and I'll post you a snippet code to understand it.

[Swapna Mandava]

Please post a code snippet

Thanks
Swapna

[Qussay Najjar]

Originally posted by Swapna Mandava:
Please post a code snippet

Thanks
Swapna

Ok, the process is going to be like the next:
1- Your Connection should be created and done.
2- we have then to create an object called Statement out of that Connection.

Statement stmt = null; //The object responsible for executing the queries.
ResultSet rs = null; //This object will hold the DB values
String dbString = "";
try{
   stmt = connection.createStatement(); //it throws SQLException
   rs = stmt.executeQuery("SELECT * FROM table_name");
   if(rs.next()){ //next() moves the cursor to next record which is the first now
      dbString = rs.getString("column_name");
   }
   rs.close();
   stmt.close();
}catch(SQLException e){
   //do something.
}

inform if need something else..have fun..

[Shilpa Tendulkar]

Originally posted by kkk guptha:
Hi,
I think Data coming from DB default is String only.
If you want to convert into Integer type, int i = Integer.parseInt(string);


--- KKKGuptha

If you know the datatype of fields in table, then you can directly use ResultSet's methods to get that type of data instead of parsing.
Like rs.getInt("col_name") or rs.getDouble("col_name") etc.

[Jesper de Jong]

Search with Google for "JDBC tutorial".

http://java.sun.com/docs/books/tutorial/jdbc/