Re: sample JSP code connecting to PostgreSQL

On Monday 24 February 2003 08:50, you wrote:
> Hi folks,
>
> I'm wondering if anybody would be pleasant enough to give me a complete
> script containing JSP code that makes a simple connection to a
> PostgreSQL database, retrieves data and dumps to screen.
>
> I must be dumb not to be able to find this information anywhere on the
> net. :(
>
> Regards,
> Roj

Hope this help ...to you or anybody else..

Best regards,

Andrewle

import java.sql.*;

class gettablerows{

public static void main(String args[])
{

String url = "jdbc:postgresql://localhost/database";
Connection con;
ResultSet rs;
String s;
String sqlstr = "SELECT f1, f2, f3 FROM table";

try
{
Class.forName("org.postgresql.Driver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}

try
{
con = DriverManager.getConnection(url,"postgres", "");

st = con.createStatement();
rs = st.executeQuery(sqlstr);

System.out.println("Rows are :");
while(rs.next())
{
s = rs.getString(1);
System.out.println(s);
}
System.out.println(mn.gname());
rs.close();
st.close();
con.close();

}
catch(SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
}

}

}