dcsimg
Web enabled Applet-Database connectivity issues
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   deepakthomas
Posted On:   Wednesday, October 3, 2012 09:06 AM

For a test project that I am doing, I have a Japplet embedded in a piece of HTML code. The applet has a form which takes some user input through a text box. The data captured needs to be updated into a MySQL table. - The applet is displayed properly when the html page is opened in a browser. - The codes throws no error on submitting the user entered info. - But the table is not getting updated with the data. Code used to embed the applet in the html page is as shown below. ********************** [code] <html>     <head>         <title></title>         <meta http-equi   More>>

For a test project that I am doing, I have a Japplet embedded in a piece of HTML code. The applet has a form which takes some user input through a text box. The data captured needs to be updated into a MySQL table.

- The applet is displayed properly when the html page is opened in a browser.
- The codes throws no error on submitting the user entered info.
- But the table is not getting updated with the data.

Code used to embed the applet in the html page is as shown below.
**********************
[code]
<html>
    <head>
        <title></title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
        <applet code="OBSPackage.UserHome" archive="OBSLibrary.jar" width="1500" height="600"></applet>
    </body>
</html>
[/code]
**********************

The code inside the applet that updates the data into the table is as shown below.
**********************
[code]
int rs1=d.putData("insert into reg(uname,address,phno,email)values('"+name+"','"+address+"','"+ph+"','"+email+"')");
                                    int rs2=d.putData("insert into login(username,password)values('"+username+"','"+pass+"')");
                                    JOptionPane.showMessageDialog(this,"Registered Successfully");
[/code]
**********************
[b]NOTE:[/b] The data insertion is working properly when the applet is run independently in the applet viewer. The issue is only when it is accessed through a browser.

- Here is my jdbc code

Java Code:
[code]
public DBcon() {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "deepak");
            st = con.createStatement();
        } catch (Exception e) {
            System.out.println("Error" + e);
        }
    }
[/code]
- I am using Netbeans to create the applets. The MySQL DB is in the same machine, in the default location (programfiles/mysql/data). The netbeans project is saved in 'My Documents'. I am able to access the DB when I run the applet through appletviewer, but not when called through a browser.


What can i do to resolve the situation? I am using Netbeans.
   <<Less
About | Sitemap | Contact