how can you retrive information from database by using
hashmap/arraylist ,plz explain with example briefly?
Answer Posted / none
import java.util.*;
import java.sql.*;
public class Jdbc
{
public static void main(String[] a)
{
Connection conn=null;
try
{
String s1="Driver name for registration";
Class.forname(s1);
String url="Driver Port No name";
String username="Database Username";
String password="Database password";
conn=Drivermanager.getConnection(url,username,password);
String sql="SELECT name,address FROM tb"
Statement stmt=conn.createStatement(sql);
Resultset rs=stmt.executeQuery();
ArrayList al=new List();
while(rs.hasnext())
{
al.add(index,rs.getString());
}
rs.close();
stmt.close();
conn.close();
}
//handle Exceptions
}
}
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Explain what is Marker interface?
How many inner classes can a class have?
Is there any case when finally will not be executed?
How do you declare an array in java?
Which data type is a class in java?
When is update method called?
What modifiers may be used with a top-level class?
what is the difference between future and callable interface in java?
what is a thread pool in java and why is it used?
What are streams in java 8?
extending thread class or implementing runnable interface. Which is better? : Java thread
How do you create a bulleted list?
What is hash table in java?
What are the drawbacks of reflection?
Where are global variables stored?