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
What do you mean by constant time complexity?
Why main method is static in java?
What is thread safe singleton?
What is the integer of 16?
How do you identify if jvm is 32-bit or 64-bit from java program?
What is javac_g?
Differentiate between nested and inner class in java.
Explain about complier design(phases)
What are the differences between Java 1.0 and Java 2.0?
What is the difference between declaration and definition in java?
Hi Anyone know the model / questions of the Federal bank sample questions for the post of Specialist Officers - Programmers. Please post if anyone have..
How to compare strings in java?
Can a constructor be private and how are this() and super() method used with constructor?
What is super constructor?
Why Java doesn’t support multiple inheritance?