Unknown column 'mkl' in 'field list

[Tapan Prajapati]

   
import java.sql.*;
//import java.lang.NullPointerException;

/**
 *
 * @author inspiron
 */
public class form extends javax.swing.JFrame {
    Statement statement = null;
String url = "jdbc:mysql://localhost:3306/";
String db =  "entry";
String driver = "com.mysql.jdbc.Driver";
String user = "root";
String pass = "aaaa";
Connection con = null;
    /** Creates new form form */
    public form() {
        initComponents();
        try {
            Class.forName(driver).newInstance();
            con = DriverManager.getConnection(url + db , user, pass);
            statement = con.createStatement();
           // con.commit();
        }catch(Exception e){
            System.out.println("*** "+e.getMessage());
        }
    }

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">
    private void initComponents() {

        okbutton = new javax.swing.JButton();
        nameTextField = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        okbutton.setText("ok");
        okbutton.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                okbuttonActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(121, 121, 121)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(nameTextField, javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(okbutton, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap(236, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addGap(106, 106, 106)
                .addComponent(nameTextField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 65, Short.MAX_VALUE)
                .addComponent(okbutton)
                .addGap(86, 86, 86))
        );

        pack();
    }// </editor-fold>

    private void okbuttonActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        if(nameTextField!=null)
        {
        try{
         // Statement stmt = null;
            statement = con.createStatement();
            statement.executeUpdate("INSERT into entrytable (name) VALUES("+ nameTextField.getText() +")");
            con = DriverManager.getConnection(url + db,user,pass);

        }catch(Exception e){
            System.out.println("*@***" + e.getMessage());
        }
    }
        else{
            System.out.println("enter valid lengthstring");
        }
    }
    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new form().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify
    private javax.swing.JTextField nameTextField;
    private javax.swing.JButton okbutton;
    // End of variables declaration

}
 

i get an error : unknown column in 'xx' in field list when i run it and entered the text in text field the value displayed in ' ' and i used net bean . javascript:emoticon('');

[Ernest Friedman-Hill]

Your SQL syntax is wrong; the string has to be in single quotes. But you should never, never do this, as you're opening the door to a SQL injection attack (Google that to learn about it if you don't know what it is.) Instead, you should just do this:

PreparedStatement statement = con.prepareStatement("INSERT into entrytable (name) VALUES(?)");
statement.setString(1, nameTextField.getText());
statement.executeUpdate();  

[Tapan Prajapati]

Ernest Friedman-Hill wrote:Your SQL syntax is wrong; the string has to be in single quotes. But you should never, never do this, as you're opening the door to a SQL injection attack (Google that to learn about it if you don't know what it is.) Instead, you should just do this:

PreparedStatement statement = con.prepareStatement("INSERT into entrytable (name) VALUES(?)");
statement.setString(1, nameTextField.getText());
statement.executeUpdate();  

Thanks a lot.! its work.!


javascript:emoticon('');