Insert data into mysql using java [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed last month.

Improve this question

This code hasn't error or exception, but after running the table features in the data base remain empty

try {
    Class.forName("com.mysql.jdbc.Driver");
    con= (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/sounds","root","");
    statment = (Statement) con.createStatement();
    String query = "INSERT INTO featuers (avg_Bandwidth) values (?)";   
    PreparedStatement preparedStmt = (PreparedStatement)con.prepareStatement(query);
    preparedStmt.setDouble(1, avarage_Bandwidth);

    preparedStmt.executeUpdate();

    con.close();
} catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
} catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}

I think you also have a typo in your "INSERT" statement. Shouldn't there be a "features" instead of "featuers "? — Branislav Lazic
– Branislav Lazic, Commented Apr 16, 2015 at 7:24
@NeerajJain Newly created connections (at least through DriverManager) are required (by the JDBC spec) to be autoCommit=true. — Mark Rotteveel
– Mark Rotteveel, Commented Apr 16, 2015 at 7:28
One small tip too: Close connection and statements in finally block. — Branislav Lazic
– Branislav Lazic, Commented Apr 16, 2015 at 7:31

haedes · Accepted Answer · 2015-04-16 07:35:28Z

1

Two things of note :

statment = (Statement) con.createStatement();
This variable is not used if I see it correctly. But this should not be the problem in itself
preparedStmt.executeUpdate();
This executeUpdate method should return a int based on the query itself. So it should return 1 in your case for the no of rows affected. So try to check what is returned.

This may not be the exact solutions but do try these and you may get some idea on what is happening

answered Apr 16, 2015 at 7:35

haedes

6422 gold badges10 silver badges25 bronze badges

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

1 Comment

user3800610 Over a year ago

it doesn't enter to the try scope in any case :(

Prasad Khode · Accepted Answer · 2015-04-16 07:56:23Z

1

Hi try to use this one.

int status = 0; // to get the status to know if statement is executed properly or not

try {
    Connection con = DBConnection.getConnect();//Your database Connection
    Statement st = con.createStatement();
    status = st.executeUpdate(query); //After executing this it will return an int value
} catch (Exception ex) {
    ex.printStackTrace();
}

I hope this will help you.

edited Apr 16, 2015 at 7:56

Prasad Khode

6,77712 gold badges48 silver badges62 bronze badges

answered Apr 16, 2015 at 7:51

Luffy

1,3351 gold badge20 silver badges42 bronze badges

5 Comments

user3800610 Over a year ago

it doesn't enter to the try scope in any case :(

Luffy Over a year ago

two questions 1. is it printing any exception 2. or please post more code because it have to reach to try block to execute command, if it is not coming here it means there is something wrong with your code.

user3800610 Over a year ago

I use threading principle public void run(){ double avarage_Bandwidth=0.1; //the previous code }

Luffy Over a year ago

@user3800610 sorry but i'm not able to understand your issue properly using your last comment

user3800610 Over a year ago

I mean: the previous code was written in the post, existing into function called "run()" this function works as thread and it reject "throw exception" in its header are you understanding? :$ I think the problem from the threading principle :(

Collectives™ on Stack Overflow

Insert data into mysql using java [closed]

2 Answers 2

1 Comment

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Related