java connectivity problems from netbeans to mysql

Question

sir/mam this is my code run successfully but not insert any values inside the server

output :-

successfully inserted 11111111
drver loaded successfully
created the connection from the database
successfully inserted

code is:-

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package examples;

import java.sql.*;
/**
 *
 * @author Rahul_R_
 */
public class newfile {

   Connection conn=null;

    public newfile() {

        //inside no paramerter constructor create inside it to define username,password,url
        String username="root";
        String password="root";
        String url="jdbc:mysql://localhost:3306/login_page";

        try{

            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("drver loaded successfully");


            //create the connection form the database
            conn=DriverManager.getConnection(url,username,password);

            System.out.println("created the connection from the database");


        }catch(ClassNotFoundException ce){

            ce.printStackTrace();
            System.out.println("class not found driver error");


            //any sql error in database connection from sql sides than this exceptions
        }catch(SQLException q){

            q.printStackTrace();
            System.out.println("sql exception in the program or jdbc connectivity");


        }


    }

public void create(Beans_login b){

    //creat the statement to insert something in to the database system

    try{

        //create query written here
        String query="insert into login_info(id,username,password)"+"values(?,?,?)";

        //create the preparestatment and run the query on the tables

        PreparedStatement psmt=conn.prepareStatement(query);

        //according to ur database table insert to written statement

        psmt.setInt(1, b.getId());
        psmt.setString(2, b.getUsername());
        psmt.setString(3, b.getPassword());

    }catch(SQLException e){

        //any sql error to show inside it

        e.printStackTrace();
        System.out.println("inside it any username or table name different than error");
    }

}

//to check the connection working or not working

public static void main(String[] args) {

    //to insert the values
    Beans_login b=new Beans_login(4, "ggg", "ggg");
    System.out.println("successfully inserted 11111111");
    //create daos objects
    newfile f=new newfile();
    f.create(b);
    System.out.println("successfully inserted");
    }


}

please give me a solution

npinti · Accepted Answer · 2015-07-06 09:32:10Z

2

You are creating the statement but you are never executing it. Please check this tutorial for more information on how to work with prepared statements and Java DB connectivity in general.

psmt.setInt(1, b.getId());
psmt.setString(2, b.getUsername());
psmt.setString(3, b.getPassword());
psmt.executeUpdate(); // This will pass your prepared statement to the DB engine.

answered Jul 6, 2015 at 9:32

npinti

52.2k5 gold badges74 silver badges98 bronze badges

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

Collectives™ on Stack Overflow

java connectivity problems from netbeans to mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related