CODEWITHSUNDEEP
javamysqldatabasems-accessjcreator
Redeagle5747
Redeagle5747

Reputation: 11

Connecting Java to MS Access using JCreator

I'm still new to this. But, I'm having a problem inserting data in mt database. I think there's a lot of mistakes going on in my script

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Student extends JFrame
{
//Component's name
private JLabel lblName,lblAge,lblGrade;
private JTextField txtName, txtAge,txtGrade;
private JButton btnAdd;
String c;
String d;
String e;

public void Student()
    {

        Connection conn = null;
        String url = "jdbc:mysql://localhost:3306/";
        String dbName = "Information";
        String driver = "com.mysql.jdbc.Driver";
        String userName = "root";
        String password = "abcd";

    Container container = getContentPane();
    container.setLayout(new FlowLayout());

    lblName=new JLabel("Name: ");
    container.add(lblName);

    txtName=new JTextField(30);
    container.add(txtName);

    lblAge=new JLabel("Age: ");
    container.add(lblAge);

    txtAge=new JTextField(2);
    container.add(txtAge);

    lblGrade=new JLabel("Grade: ");
    container.add(lblGrade);

    txtGrade=new JTextField(1);
    container.add(txtGrade);

    btnAdd=new JButton("Add");
    container.add(btnAdd);

    btnAdd.addActionListener(new ActionListener()
        {
            public void actionPerformed(ActionEvent ev)
            {
                c=txtName.getText();
                d=txtAge.getText();
                e=txtGrade.getText();
            try
            {
                Class.forName(driver).newInstance();
                conn = DriverManager.getConnection(url + dbName, userName, password);

                PreparedStatement statement = conn.prepareStatement("INSERT INTO Information ('StudentName', 'StudentAge','Grade') VALUES ('"+c+"', '"+d+"', '"+e+"'')");
                statement.executeQuery();

            }
                catch (Exception ex)
            {
                ex.printStackTrace();
            }
            }

        });

    setSize(300,300);
    setVisible(true);

}
public static void main(String[]args)
{
    Student application = new Student();
    application.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}

}

So, can anyone help me fix what is wrong here? Please see the screenshot below for the output.

enter image description here

Upvotes: 1

Views: 278

Answers (1)

Youcef LAIDANI
Youcef LAIDANI

Reputation: 59950

1-You don't need t use '' to the name of your column 'StudentName', if you need that then use use `` instead to ''

2-You have a problem in your query here :

...('"+c+"', '"+d+"', '"+e+"'')

You set two '' in the end, and this make a problem.

Why you dont use ? like this :

PreparedStatement statement = 
conn.prepareStatement("INSERT INTO Information (StudentName, StudentAge, Grade) VALUES (?, ?, ?)");

statement.setString(1, c);
statement.setString(2, d);
statement.setString(3, e);

statement.executeQuery();

You can learn more here about Prepared Statement doc

Upvotes: 0

Related Questions