Kensoft PH
  • Download
  • Contact
  • About
Java Quiz
No Result
View All Result
Kensoft PH
  • Download
  • Contact
  • About
Java Quiz
No Result
View All Result
Kensoft PH
No Result
View All Result
Home Java

How to use CRUD in Java programming | 100% best for beginners

November 2, 2020 - Updated on September 21, 2022
in Java
Reading Time: 2 mins read
0
crud in java
964
VIEWS
Share on FacebookShare on TwitterShare via Email

Contents

  • How to use CRUD in Java
  • INSERT Statement example
  • SELECT Statement example
  • UPDATE Statement example
  • DELETE Statement example
  • YouTube Video

How to use CRUD in Java

Create, Read, Update, and Delete (CRUD). Most applications have some kind of CRUD functionality. Maybe, most of the beginners are confused about CRUD in java. Well, Insert, Select, Update, and Delete are the SQL statements. These are examples of CRUD in Java.

INSERT Statement example

import java.sql.*;

public class CRUD {

public Connection connection;
public Statement statement;
public String sql = "";

public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("Database url","root","root");
statement = connection.createStatement();
sql = "INSERT INTO tableName(name,age,nickname) values('"+name.getText()+"','"+age.getText()+"','"+nickname.getText()+"')";
statement.executeUpdate(sql);
System.out.println("Success");
} catch (Exception e) {
System.out.println(e);
}
}
}

SELECT Statement example

import java.sql.*;

public class CRUD {

public Connection connection;
public Statement statement;
public ResultSet resultset;
public String sql = "";

public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("Database url","root","root");
statement = connection.createStatement();
sql = "Select * from tablename";
resultset = statement.executeQuery(sql);
if(resultset.next()){
String name = resultset.getString("name");
String age = resultset.getString("age");
String nickname = resultset.getString("nickname");
System.out.println(name+" "+age+" "+nickname);
}
} catch (Exception e) {
System.out.println(e);
}
}
}

UPDATE Statement example

import java.sql.*;

public class CRUD {

public Connection connection;
public Statement statement;
public ResultSet resultset;
public String sql = "";

public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("Database url","root","root");
statement = connection.createStatement();
sql = "UPDATE tablename set age = '21' where name = 'Kensoft'";
statement.executeUpdate(sql);
System.out.println("Success");
} catch (Exception e) {
System.out.println(e);
}
}
}

DELETE Statement example

import java.sql.*;

public class CRUD {

public Connection connection;
public Statement statement;
public ResultSet resultset;
public String sql = "";

public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("Database url","root","root");
statement = connection.createStatement();
sql = "DELETE tablename where name = 'Kensoft'";
statement.executeUpdate(sql);
System.out.println("Success");
} catch (Exception e) {
System.out.println(e);
}
}
}

That’s how you do it.

 

CRUD in java

YouTube Video

Java Tutorial: How to insert data in mysql using java netbeans
Watch this video on YouTube.
Previous Post

How to connect Java to MySQL database using Xampp server | 100% best for beginners

Next Post

100% best Java swing mailing Graphical User Interface (GUI)

KENSOFT

KENSOFT

What’s up! Kent is my name. The name KENSOFT is derived from the words Kent and Software. My programming language of choice is Java

Related tutorials

How to use the JavaFX ToolBar
Java

How to use the JavaFX ToolBar | 100% Perfect Tutorial

January 24, 2023
13
JavaFX Context Menu
Java

How to use the JavaFX ContextMenu | 100% Perfect Tutorial

January 22, 2023
10
JavaFX MenuBar
Java

How to use the Menu Bar in JavaFX | 100% Perfect Tutorial

December 3, 2022 - Updated on January 23, 2023
76
Next Post
Graphical User Interface

100% best Java swing mailing Graphical User Interface (GUI)

send email using java

Java Send Email Tutorial | 100% Best for beginners

Play sound in Java

How to play sound in Java | 100% best for beginners

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Maximum upload file size: 20 MB. You can upload: image, audio, video, document, text. Drop files here

  • Trending
  • Comments
  • Latest
Failed to automatically set up a JavaFX Platform

Failed to automatically set up a JavaFX Platform SOLVED Apache NetBeans 12.3 | Best way

April 11, 2021 - Updated on July 3, 2022
MySQL database using XAMPP

How to connect Java to MySQL database using Xampp server | 100% best for beginners

October 27, 2020 - Updated on January 23, 2023
JavaFX 17

How To install JDK 17 and JavaFX 17 on NetBeans IDE | Best

November 15, 2021 - Updated on December 13, 2021
change the stage icon in JavaFX

How to change the stage icon in JavaFX | 100% best for beginners

May 23, 2021 - Updated on September 24, 2022
Failed to automatically set up a JavaFX Platform

Failed to automatically set up a JavaFX Platform SOLVED Apache NetBeans 12.3 | Best way

send SMS in java

How to send SMS in Java | 100% best example

3DES in Java and AES in Java

How to use AES and 3DES in Java | 100% best for beginners

JavaFX Splash Screen

How to create JavaFX Splash Screen | 100% best for beginners

How to use the JavaFX ToolBar

How to use the JavaFX ToolBar | 100% Perfect Tutorial

January 24, 2023
JavaFX Context Menu

How to use the JavaFX ContextMenu | 100% Perfect Tutorial

January 22, 2023
JavaFX MenuBar

How to use the Menu Bar in JavaFX | 100% Perfect Tutorial

December 3, 2022 - Updated on January 23, 2023
How to use the Slider in JavaFX | 100% Perfect Tutorial

How to use the Slider in JavaFX | 100% Perfect Tutorial

November 27, 2022

Latest Tutorials

How to use the JavaFX ToolBar

How to use the JavaFX ToolBar | 100% Perfect Tutorial

January 24, 2023
JavaFX Context Menu

How to use the JavaFX ContextMenu | 100% Perfect Tutorial

January 22, 2023
JavaFX MenuBar

How to use the Menu Bar in JavaFX | 100% Perfect Tutorial

December 3, 2022 - Updated on January 23, 2023

Popular Tutorials

  • Failed to automatically set up a JavaFX Platform

    Failed to automatically set up a JavaFX Platform SOLVED Apache NetBeans 12.3 | Best way

    0 shares
    Share 0 Tweet 0
  • How to connect Java to MySQL database using Xampp server | 100% best for beginners

    0 shares
    Share 0 Tweet 0
  • How To install JDK 17 and JavaFX 17 on NetBeans IDE | Best

    0 shares
    Share 0 Tweet 0
Facebook Instagram Youtube Github LinkedIn Discord
Kensoft PH

What’s up! Kent is my name. The name KENSOFT is derived from the words Kent and Software. My programming language of choice is Java, which I use to create computer applications. In a company, I created applications and a website.

Website

Privacy Policy

Terms and Condition

Sitemap

Services

Guest Post

Fiverr

Freelancer

Upwork

Categories

Website Status

Check the status

Latest Tutorials

How to use the JavaFX ToolBar

How to use the JavaFX ToolBar | 100% Perfect Tutorial

January 24, 2023
JavaFX Context Menu

How to use the JavaFX ContextMenu | 100% Perfect Tutorial

January 22, 2023
JavaFX MenuBar

How to use the Menu Bar in JavaFX | 100% Perfect Tutorial

December 3, 2022 - Updated on January 23, 2023

© 2023 Made With Love By KENSOFT PH

No Result
View All Result
  • Download
  • Java Quiz
  • Contact
  • About

© 2023 Made With Love By KENSOFT PH

This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.