servlet problem
| От | senthil kumar |
|---|---|
| Тема | servlet problem |
| Дата | |
| Msg-id | 20020509060012.312DB4758EC@postgresql.org обсуждение исходный текст |
| Список | pgsql-jdbc |
Dear Sir/Madam,
Below i have written my environment
installed FreeBSD 4.5
installed JDK1.3.1
installed Tomcat 3.2
installed Postgresql 7.2.1
installed JDBC-Postgre driver and placed the pgjdbc.jar file in
/jdk1.3.1/jre/lib/ext
servlet.jar file was located in /usr/local/tomcat/lib/servlet.jar
i am the beginer for the java world and postgresql.i don`t know how to
compile and run the below servlet program
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class Mypsql extends HttpServlet {
Connection conn;
Statement stmt;
//set the connection url,database username and password
String url = "jdbc:postgresql://localhost:5432/postgres";
String dbusername = "postgres";
String dbpass = "postgres";
public void init(ServletConfig config)throws ServletException{
super.init(config);
}
public void doGet(HttpServletRequest req, HttpServletResponse res)throws
ServletException, IOException{
res.setContentType("text/html");
PrintWriter out = res.getWriter();
try
{
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection(url,dbusername, dbpass);
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT*FROM test1");
while(rs.next())
{
out.println(rs.getString(1)+ "<BR>");
}
}
catch(Exception e)
{
out.println(e);
}
}
}
i couldn`t find postgresql.jar file.
please any one help me !
Thanks in advance!
kumar
В списке pgsql-jdbc по дате отправления: