From: | v j <jvs_a(at)yahoo(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | JDBC APPLET Problem |
Date: | 2001-02-01 13:16:10 |
Message-ID: | 20010201131610.9271.qmail@web9506.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-jdbc |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Kovacs Baldvin | 2001-02-01 20:39:51 | Q on JDBC's resultset |
Previous Message | Peter T Mount | 2001-01-31 08:30:27 | Re: JDBC Connection Problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-02-01 16:46:44 | Re: [BUGS] JDBC PreparedStatement.setMaxRows() affects other objects instantiated from this class and it's parent class |
Previous Message | Peter T Mount | 2001-02-01 09:13:27 | Re: PreparedStatement suggestion |