doubt

View Answers

September 19, 2008 at 6:06 PM

Hi friend,

import java.awt.Font;
import java.awt.Color;
import java.awt.BorderLayout;
import java.awt.event.*;
import java.applet.Applet;
import javax.swing.*;
import java.applet.*;
import java.sql.*;
import java.net.*;
import java.io.*;

public class DataInsertApplet extends Applet implements ActionListener {

JLabel text, clicked;
JButton button, clickButton;
JTextField textField;
private boolean clickMeMode = true;
private Connection c;
private String driver = "com.mysql.jdbc.Driver";
private String user = "amar";
private String pass = "amar123";
private String url = "jdbc:mysql://192.168.10.211:3306/";;
private String db = "amar";

public void init(){
text = new JLabel("Text to save to file:");
clicked = new JLabel("Text retrieved from file:");
button = new JButton("Click Me");
button.addActionListener(this);
clickButton = new JButton("Click Again");
clickButton.addActionListener(this);
textField = new JTextField(20);
setLayout(new BorderLayout());
setBackground(Color.white);
add(BorderLayout.NORTH, text);
add(BorderLayout.CENTER, textField);
add(BorderLayout.SOUTH, button);
}

public void start(){
}

public void stop(){
System.out.println("Applet stopping.");
}

public void destroy(){
System.out.println("Destroy method called.");
}

public void actionPerformed(ActionEvent event){
try{
Class.forName (driver);
c = DriverManager.getConnection(url+db,user,pass);
}catch (Exception e){
e.printStackTrace();
System.exit(1);
}

Object source = event.getSource();
if(source == button){
if(clickMeMode){
JTextArea displayText = new JTextArea();
try{

//Write to database
String theText = textField.getText();
Statement stmt = c.createStatement();
String updateString = "INSERT INTO employeedetail VALUES ('"+theText+"')";
int count = stmt.executeUpdate(updateString);

//Read from database

ResultSet results = stmt.executeQuery("SELECT empname FROM employeedetail ");
while(results.next()){
String s = results.getString("empname");
displayText.append(s + "\n");
}
stmt.close();
}catch(java.sql.SQLException e){
System.out.println("Cannot create SQL statement");
System.exit(1);
}

//Display text read from database
text.setText("Text retrieved from file:");
button.setText("Click Again");
clickMeMode = false;

//Display text read from database

} else {
text.setText("Text to save to file:");
textField.setText("");
button.setText("Click Me");
clickMeMode = true;
}
}
}
}

September 19, 2008 at 6:09 PM

<HTML>
<BODY>

<APPLET CODE=DataInsertApplet.class WIDTH="300" HEIGHT="200">
</APPLET>

</BODY>
</HTML>

-------------------------

Visit for more information.

http://www.roseindia.net/java/example/java/applet

Thanks.