Re: JDBC APPLET Problem - Mailing list pgsql-interfaces
| From | PostgreSQL Server |
|---|---|
| Subject | Re: JDBC APPLET Problem |
| Date | |
| Msg-id | Pine.LNX.4.21.0102012209190.24227-100000@gonzo.lnxsoftware.com.mx Whole thread Raw |
| In response to | JDBC APPLET Problem (v j <jvs_a@yahoo.com>) |
| Responses |
different methods
(Manika Dey <bithi@plasma.ernet.in>)
|
| List | pgsql-interfaces |
On Thu, 1 Feb 2001, v j wrote:
> Dear Sir,
> Now I try to run the Java Program by using JDBC
> PostgreSql through Web Browser.
> I set the file pg_hba.conf as
>
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
> host all 0.0.0.0 0.0.0.0 trust
>
> and the java code as shown below .....
>
> import java.sql.*;
> import java.applet.*;
> import java.awt.*;
> import java.awt.event.*;
> import java.net.*;
> import java.io.*;
>
>
> public class SampleApplet extends Applet implements
> ActionListener
> {
> Connection conn;
> Statement stmt;
> String state_code;
>
> private TextField Tinput;
> private TextField Toutput;
> private TextField Terror;
>
> private Button sqlprocess;
>
>
>
> public void init(){
>
>
> try{ Class.forName ("org.postgresql.Driver");}
> catch(Exception ex){
> ex.printStackTrace();}
>
> setFont(new Font("TimesRoman",Font.PLAIN,15));
> setLayout(null);
>
> Label Linput = new Label("Enter a state code: ");
> Tinput = new TextField(10);
> Label Loutput = new Label("Sql Output");
> Toutput = new TextField(30);
> Terror = new TextField(100);
> sqlprocess = new Button("SqlQuery");
>
> Linput.setBounds(10,30,150,30);
> Tinput.setBounds(170,20,100,30);
> Loutput.setBounds(10,80,100,30);
> Toutput.setBounds(110,80,100,30);
> Terror.setBounds(10,150,200,30);
> sqlprocess.setBounds(50,210,80,30);
>
> add(Linput);
> add(Tinput);
> add(Loutput);
> add(Toutput);
> add(Terror);
> add(sqlprocess);
>
> sqlprocess.addActionListener(this);
>
> }
>
> public void start() {
> try{ conn =
> DriverManager.getConnection("jdbc:postgresql://fmlhost.fml.t.u-tokyo.ac.jp/test","postgres","");
> stmt = conn.createStatement();
> }
> catch(Exception ex){
>
> ex.printStackTrace();
> Terror.setText(ex.getMessage());
> }
> }
>
> public void actionPerformed(ActionEvent ae) {
>
> if(ae.getActionCommand()=="SqlQuery"){
>
>
> state_code = Tinput.getText();
>
> try{ ResultSet res = stmt.executeQuery( "Select
> name "+"From statename "+"Where code =
> '"+state_code+"'");
> if(res!=null)
> while(res.next())
> {String state_name = res.getString(1);
> Toutput.setText(state_name);}
>
> res.close();
> stmt.close();
> conn.close();
> }
>
> catch(Exception ex){
> ex.printStackTrace(); }
>
>
> }
>
> }
>
>
> }
>
> and I get the error message as
>
> "No suitable driver"
>
> Please advice me for this problem.
>
> Thank you
>
>
>
> __________________________________________________
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://personal.mail.yahoo.com/
>
Hello there :
You need to include your .jar archive with your applet
Just copy the jdbc jar to your applet directory
<html>
<body
<applet code=SampleApplet archive=jdbc7.0-1.2.jar width=800 height=600>
</applet>
</body>
</html>
Saludos
Leonel
pgsql-interfaces by date: