JDBC APPLET Problem - Mailing list pgsql-interfaces
| From | v j |
|---|---|
| Subject | JDBC APPLET Problem |
| Date | |
| Msg-id | 20010201131610.9271.qmail@web9506.mail.yahoo.com Whole thread Raw |
| Responses |
Re: JDBC APPLET Problem
Re: JDBC APPLET Problem Re: JDBC APPLET Problem |
| List | pgsql-interfaces |
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;privateTextField 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/
pgsql-interfaces by date: