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
(Bruno Dickhoff <bruno@dickhoff.de>)
Re: JDBC APPLET Problem ("S.A.Pamungkas" <moenk_2000@yahoo.com>) Re: JDBC APPLET Problem (PostgreSQL Server <postgres@gonzo.lnxsoftware.com.mx>) |
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: