mysql connection issue in first try

Question

I have been learning java for about 3 weeks. I wanted to connect mysql with java and I'm trying now. But there is a problem. I have already installed php,apache,mysql three in for my ubuntu. And I can reach phpmyadmin from port 80. I think there is a problem when connecting database this is why I said port.

Here is the my table:

+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(2)      | NO   | PRI | NULL    | auto_increment |
| name  | varchar(32) | NO   |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+

And here is the java code:

import java.sql.DriverManager;
import java.sql.Statement;

public class Main {

    public static void main(String args[]) {
        try {

            java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:80/test", "root", "1");

            Statement state = (Statement) conn.createStatement();
            String name = "try";
            state.executeUpdate("INSERT INTO deneme (name) VALUES (" + name + ")");

        } catch (Exception e) {
        }
    }
}

This code runs about 20 seconds and returns BUILD SUCCESSFUL (total time: 21 seconds) What is your idea about this problem?

Costis Aivalis · Accepted Answer · 2013-08-01 07:23:26Z

1

The single quotes will fix your problem...

state.executeUpdate("INSERT INTO deneme (name) VALUES ('" + name + "')");

By using a PreparedStament you will not need to mess with single and double quote combinations.

Note that the reason why a try statement is required, is in order to report the exception, since many things may go wrong when accessing a database report the exception message and it will help you find the problem.

Also, it is always useful to check if the JDBC driver exists before trying to connect. Insert another try statement, like this one:

    try {
        Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e) {
        String msg = "The com.mysql.jdbc.Driver is missing\n"
                + "install and rerun the application";
        JOptionPane.showMessageDialog(this, msg, this.getTitle(), JOptionPane.ERROR_MESSAGE);
        System.exit(1);
    }

edited Aug 1, 2013 at 7:23

answered Jul 31, 2013 at 23:45

Costis Aivalis

13.8k3 gold badges49 silver badges48 bronze badges

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

Comments

meilechh · Accepted Answer · 2013-07-31 23:37:54Z

1

I assume the issue is, port 80 is reserved for the web (HTTP) server, not for MySQL. The default port for MySQL is 3306.

answered Jul 31, 2013 at 23:37

meilechh

8452 gold badges8 silver badges17 bronze badges

2 Comments

meilechh Over a year ago

Try to add in the catch block "e.printStackTrace()", so you will see which exception you are getting.

meilechh Over a year ago

You forgot to surround the string "try" with single quotes. if you would use PreparedStatement instead of a regular statement, you would not need to do this, the setString() method will do the job for you.

Collectives™ on Stack Overflow

mysql connection issue in first try

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related