db error

hello,
you have to change the datatype of the field in which you are inserting your text area
content. if you are using mysql then put the datatype as "longtext".

repply your feedback.

Hi Friend,

Try the following code:

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;

class Form extends JFrame {
Form() {
JLabel label = new JLabel();
label.setText("Enter Description:");
JButton ADD=new JButton("Insert");
final JTextArea area =new JTextArea(10,25);

final JPanel panel=new JPanel(new GridLayout(2,2));
panel.add(label);
panel.add(area);
panel.add(ADD);

add(panel,BorderLayout.CENTER);
ADD.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae){
String value=area.getText();
Connection con = null;
String url = "jdbc:mysql://192.168.10.126/";;
String db = "roseindia";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "root";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db, user, pass);
Statement st = con.createStatement();
int i= st.executeUpdate("Insert into Description(description) values('"+value+"')");
JOptionPane.showMessageDialog(null,"Data is successfully inserted into the database." );
st.close();
con.close();
}
catch(Exception e){
System.out.println(e);
}
}
});
}
}
class InsertTextArea{
public static void main(String arg[]) {
try {
Form frame=new Form();
frame.setSize(300,100);
frame.setVisible(true);
}
catch(Exception e) {}
}
}
You have to put the 'text' or 'longtext' datatype for the textarea field in the database table.

Thanks