Java Simple Jdbc
// T.java
import java.sql.*;
public class T
{
public static void main(String args[])
{
try
{
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql:Learn";
String user = "postgres";
String pass = "abc123";
Connection conn = DriverManager.getConnection(url, user, pass);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("Select * from contact_info");
System.out.println(rs.toString());
ResultSetMetaData rsmd = rs.getMetaData();
int numColumns = rsmd.getColumnCount();
for (int i=1; i<=numColumns; i++)
{
System.out.println(
rsmd.getColumnLabel(i) + " : " +
rsmd.getColumnName(i) + " : " +
rsmd.getColumnTypeName(i) + " : " +
rsmd.getColumnDisplaySize(i) + " : " +
rsmd.getPrecision(i) + " : " +
rsmd.getScale(i)
);
}
}
catch (Exception e)
{
e.printStackTrace();
System.err.println("Exception : "+e);
}
}
}
Back to start page