How to add information to MySQL database using java code

Question

Below, there's code that should insert information to the MySQL database. It works without exceptions, but does not insert information to the database.

    try {
        Class.forName("Com.mysql.jdbc.Driver");
        Connection connection= DriverManager.getConnection("jdbc:mysql:///mymail","root","toor");
        out.print("Connected");
        PreparedStatement ps= connection.prepareStatement("insert into mytable(fname,lname,uname,pass,cpass,month,day,year,Gender,mobile,email,country) values (?,?,?,?,?,?,?,?,?,?,?,?)");
    ps.setString(1, fname);
    ps.setString(2, lname);
    ps.setString(3, uname);
    ps.setString(4, pass);
    ps.setString(5, cpass);
    ps.setString(6, month);
    ps.setString(7, day);
    ps.setString(8, year);
    ps.setString(9, Gender);
    ps.setString(10, mobile);
    ps.setString(11,email);
    ps.setString(12, country);
    ps.executeUpdate();

    } catch (Exception e) 
                        {}

You don't display your whole code, but I suspect that getting no error is the result of silently swallowing it in that catch statement. — cherouvim
– cherouvim, Commented Jul 12, 2014 at 11:22
if you are not viewing any exception.. add this in your catch block e.printStackTrace();for viewing full trace or System.out.println(e); for viewing the exception alone.. P.S: Always remember to post your exceptions or errors when you ask a question. That will help us in answering your question better. We cant assume all possible errors.. So, to get the right answer post your errors/exception — practice2perfect
– practice2perfect, Commented Jul 12, 2014 at 13:02
There was neither any error nor any exception.it compiles succesfully but then also there is not any insertion in database. and i have already added e.printStackTrace(); but result is same. — Anurag Giri
– Anurag Giri, Commented Jul 12, 2014 at 17:51

flob · Accepted Answer · 2014-07-12 11:31:16Z

1

It might be that your connection is not in autocommit mode, so you have to call a connection.commit().

And you must call connection.close() (in a finally block) before you leave that method, otherwise you will leak open connections

I would suggest you try a framework that saves you a lot of those troubles like spring with JdbcTemplates.

edited Jul 12, 2014 at 11:31

answered Jul 12, 2014 at 11:22

flob

3,9182 gold badges38 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3145373 ツ Over a year ago

In java 7, is it necessary to close jdbc connection ? I think not.

flob Over a year ago

But then you would have to use a try block with try-with-ressource

Darshan Lila · Accepted Answer · 2014-07-12 11:35:14Z

0

Well without the complete code and table structure it's hard to tell what is causing the problem. Though I would suggest you check the type of your columns with the values you are inserting. That's potentially could be causing the problem.

Secondly the url you are specifying for database looks suspicious.

And lastly make sure you have a mysql connector in your classpath.

If you've checked the above points, I think you should be good.

answered Jul 12, 2014 at 11:35

Darshan Lila

5,8762 gold badges26 silver badges36 bronze badges

1 Comment

Anurag Giri Over a year ago

Ohh thanks, actually i didn't had used mysql connector. Now i got it.

Collectives™ on Stack Overflow

How to add information to MySQL database using java code

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related