How to access the sql database in applet?

import java.applet.*;

import java.awl.*;

import java.sql.*;

//other packages

public class jdb extends Applet

{

Connection con;

Statement stmt;

String name="drvijay";

String phoneno="9842088860";

public void init(){}

pubilc void stop(){}

public void destroy(){}

public void start()

{

call();

}

public void call()

{

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

conn=DriverManager.getConnection("Jdbc:Odbc:emp","sa","");

stmt=conn.createStatement();

stmt.executeUpdate("insert into empdetails(name,phoneno) values ('"+name + "',''"+ phoneno +"' )" );

}catch(SQLException e)

{

System.out.println("error"+e);

System.exit(0);

}

}

};

//<applet code="jdb" height="200" width="200"> </applet>

/*

u this jdbc statement in any of the method..

*/

drvijayy2k2a at 2007-7-12 15:16:14 >

> con=DriverManager.getConnection("Jdbc:Odbc:emp","system

> ","manager");

This line should be

con=DriverManager.getConnection("jdbc:odbc:emp","system","manager");

notice the caps.(java is Case sensitive)

The Class.forName() throws ClassNotFoundException

Also note that you have mentioned the SQLException only. You need to mention one more catch statement

catch(Exception e)

{

e.printStackTrace();

}

As I said before using a jdbc-odbc is not recommented if you plan to deploy this on the web.

Regards

Message was edited by:

ArcherKing

ArcherKinga at 2007-7-12 15:16:14 >

Oh I've forgot to mention that you have to set permissions.

I'm not at my home computer right now, so I cant give you exact procedure.

I can guide you a bit though.

run the policytool from the command prompt and set the permissions.

Can someone else help him out?

follow this link, hope it helps

http://forum.java.sun.com/thread.jspa?threadID=172396&tstart=0

Message was edited by:

ArcherKing

ArcherKinga at 2007-7-12 15:16:14 >