Breaking News: Grepper is joining You.com. Read the official announcement!

java crud

xcv answered on January 6, 2021 Popularity 9/10 Helpfulness 1/10

answer java crud

related CRUD JAVA

java crud

Comment

package com.javaguides.jdbc.statement.examples;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Create Statement JDBC Example
 * @author Ramesh Fadatare
 *
 */
public class CreateStatementExample {

    private static final String createTableSQL = "create table users (\r\n" + "  id  int(3) primary key,\r\n" +
        "  name varchar(20),\r\n" + "  email varchar(20),\r\n" + "  country varchar(20),\r\n" +
        "  password varchar(20)\r\n" + "  );";

    public static void main(String[] argv) throws SQLException {
        CreateStatementExample createTableExample = new CreateStatementExample();
        createTableExample.createTable();
    }

    public void createTable() throws SQLException {

        System.out.println(createTableSQL);
        // Step 1: Establishing a Connection
        try (Connection connection = DriverManager
            .getConnection("jdbc:mysql://localhost:3306/mysql_database?useSSL=false", "root", "root");

            // Step 2:Create a statement using connection object
            Statement statement = connection.createStatement();) {

            // Step 3: Execute the query or update query
            statement.execute(createTableSQL);
        } catch (SQLException e) {

            // print SQL exception information
            printSQLException(e);
        }

        // Step 4: try-with-resource statement will auto close the connection.
    }

    public static void printSQLException(SQLException ex) {
        for (Throwable e: ex) {
            if (e instanceof SQLException) {
                e.printStackTrace(System.err);
                System.err.println("SQLState: " + ((SQLException) e).getSQLState());
                System.err.println("Error Code: " + ((SQLException) e).getErrorCode());
                System.err.println("Message: " + e.getMessage());
                Throwable t = ex.getCause();
                while (t != null) {
                    System.out.println("Cause: " + t);
                    t = t.getCause();
                }
            }
        }
    }
}

Popularity 9/10 Helpfulness 1/10 Language java

Source: www.javaguides.net

Tags: crud java

Link to this answer
Share Copy Link

Contributed on Jul 26 2022

xcv

0 Answers Avg Quality 2/10

Closely Related Answers

CRUD JAVA

Comment

String sql = "SELECT * FROM Users";
 
Statement statement = conn.createStatement();
ResultSet result = statement.executeQuery(sql);
 
int count = 0;
 
while (result.next()){
    String name = result.getString(2);
    String pass = result.getString(3);
    String fullname = result.getString("fullname");
    String email = result.getString("email");
 
    String output = "User #%d: %s - %s - %s - %s";
    System.out.println(String.format(output, ++count, name, pass, fullname, email));
}

Popularity 10/10 Helpfulness 2/10 Language java

Source: www.codejava.net

Tags: crud

Link to this answer
Share Copy Link

Contributed on Jan 06 2021

Modern Mosquito

0 Answers Avg Quality 2/10

CRUD JAVA

Comment

String sql = "INSERT INTO Users (username, password, fullname, email) VALUES (?, ?, ?, ?)";
 
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, "bill");
statement.setString(2, "secretpass");
statement.setString(3, "Bill Gates");
statement.setString(4, "bill.gates@microsoft.com");
 
int rowsInserted = statement.executeUpdate();
if (rowsInserted > 0) {
    System.out.println("A new user was inserted successfully!");
}

Popularity 9/10 Helpfulness 1/10 Language java

Source: www.codejava.net

Tags: crud

Link to this answer
Share Copy Link

Contributed on Jan 06 2021

Modern Mosquito

0 Answers Avg Quality 2/10

CRUD JAVA

Comment

String sql = "DELETE FROM Users WHERE username=?";
 
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, "bill");
 
int rowsDeleted = statement.executeUpdate();
if (rowsDeleted > 0) {
    System.out.println("A user was deleted successfully!");
}

Popularity 9/10 Helpfulness 1/10 Language java

Source: www.codejava.net

Tags: crud

Link to this answer
Share Copy Link

Contributed on Jan 06 2021

Modern Mosquito

0 Answers Avg Quality 2/10

CRUD JAVA

Comment

String sql = "UPDATE Users SET password=?, fullname=?, email=? WHERE username=?";
 
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, "123456789");
statement.setString(2, "William Henry Bill Gates");
statement.setString(3, "bill.gates@microsoft.com");
statement.setString(4, "bill");
 
int rowsUpdated = statement.executeUpdate();
if (rowsUpdated > 0) {
    System.out.println("An existing user was updated successfully!");
}

Popularity 9/10 Helpfulness 1/10 Language java

Source: www.codejava.net

Tags: crud

Link to this answer
Share Copy Link

Contributed on Jan 06 2021

Modern Mosquito

0 Answers Avg Quality 2/10

java crud

Contents

More Related Answers

java crud

Closely Related Answers

CRUD JAVA

CRUD JAVA

CRUD JAVA

CRUD JAVA

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.