import java.awt.EventQueue;
import java.sql.*;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import java.awt.Font;
import javax.swing.JPanel;
import javax.swing.border.TitledBorder;
import net.proteanit.sql.DbUtils;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
public class BooksRecord {
private JFrame frame;
private JTextField txtbname;
private JTextField txtedition;
private JTextField txtprice;
private JTable table;
private JTextField txtbid;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
BooksRecord window = new BooksRecord();
window.frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the application.
*/
public BooksRecord() {
initialize();
Connect();
table_load();
}
//Database Connection
Connection con;
PreparedStatement pst;
ResultSet rs;
public void Connect()
{
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/booksrecord", "root","root");
}
catch (ClassNotFoundException ex)
{
ex.printStackTrace();
}
catch (SQLException ex)
{
ex.printStackTrace();
}
}
public void table_load()
{
try
{
pst = con.prepareStatement("select * from book");
rs = pst.executeQuery();
table.setModel(DbUtils.resultSetToTableModel(rs));
}
catch (SQLException e)
{
e.printStackTrace();
}
}
/**
* Initialize the contents of the frame.
*/
private void initialize() {
frame = new JFrame();
frame.setBounds(100, 100, 619, 488);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.getContentPane().setLayout(null);
JLabel lblNewLabel = new JLabel("Books Record System");
lblNewLabel.setFont(new Font("Tahoma", Font.BOLD, 14));
lblNewLabel.setBounds(228, 11, 169, 45);
frame.getContentPane().add(lblNewLabel);
JPanel panel = new JPanel();
panel.setBorder(new TitledBorder(null, "Registeration", TitledBorder.LEADING, TitledBorder.TOP, null, null));
panel.setBounds(30, 67, 276, 184);
frame.getContentPane().add(panel);
panel.setLayout(null);
JLabel lblNewLabel_1 = new JLabel("Book Name");
lblNewLabel_1.setFont(new Font("Tahoma", Font.BOLD, 14));
lblNewLabel_1.setBounds(21, 35, 90, 34);
panel.add(lblNewLabel_1);
JLabel lblNewLabel_1_1 = new JLabel("Edition");
lblNewLabel_1_1.setFont(new Font("Tahoma", Font.BOLD, 14));
lblNewLabel_1_1.setBounds(21, 78, 90, 34);
panel.add(lblNewLabel_1_1);
JLabel lblNewLabel_1_2 = new JLabel("Price");
lblNewLabel_1_2.setFont(new Font("Tahoma", Font.BOLD, 14));
lblNewLabel_1_2.setBounds(21, 126, 90, 34);
panel.add(lblNewLabel_1_2);
txtbname = new JTextField();
txtbname.setBounds(144, 44, 96, 20);
panel.add(txtbname);
txtbname.setColumns(10);
txtedition = new JTextField();
txtedition.setColumns(10);
txtedition.setBounds(144, 87, 96, 20);
panel.add(txtedition);
txtprice = new JTextField();
txtprice.setColumns(10);
txtprice.setBounds(144, 135, 96, 20);
panel.add(txtprice);
JButton btnNewButton = new JButton("Save");
btnNewButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String bname,edition,price;
bname = txtbname.getText();
edition = txtedition.getText();
price = txtprice.getText();
try {
pst = con.prepareStatement("insert into book(name,edition,price)values(?,?,?)");
pst.setString(1, bname);
pst.setString(2, edition);
pst.setString(3, price);
pst.executeUpdate();
JOptionPane.showMessageDialog(null, "Record Addedddd!!!!!");
table_load();
txtbname.setText("");
txtedition.setText("");
txtprice.setText("");
txtbname.requestFocus();
}
catch (SQLException e1)
{
e1.printStackTrace();
}
}
});
btnNewButton.setFont(new Font("Tahoma", Font.BOLD, 14));
btnNewButton.setBounds(30, 262, 89, 34);
frame.getContentPane().add(btnNewButton);
JButton btnExit = new JButton("Exit");
btnExit.setFont(new Font("Tahoma", Font.BOLD, 14));
btnExit.setBounds(129, 262, 89, 34);
frame.getContentPane().add(btnExit);
JButton btnClear = new JButton("Clear");
btnClear.setFont(new Font("Tahoma", Font.BOLD, 14));
btnClear.setBounds(228, 262, 89, 34);
frame.getContentPane().add(btnClear);
JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(342, 66, 253, 230);
frame.getContentPane().add(scrollPane);
table = new JTable();
scrollPane.setViewportView(table);
JPanel panel_1 = new JPanel();
panel_1.setBorder(new TitledBorder(null, "Search", TitledBorder.LEADING, TitledBorder.TOP, null, null));
panel_1.setBounds(10, 324, 321, 100);
frame.getContentPane().add(panel_1);
panel_1.setLayout(null);
JLabel lblNewLabel_1_1_1 = new JLabel("Book ID");
lblNewLabel_1_1_1.setBounds(10, 21, 65, 17);
lblNewLabel_1_1_1.setFont(new Font("Tahoma", Font.BOLD, 14));
panel_1.add(lblNewLabel_1_1_1);
txtbid = new JTextField();
txtbid.addKeyListener(new KeyAdapter() {
@Override
public void keyReleased(KeyEvent e) {
try {
String id = txtbid.getText();
pst = con.prepareStatement("select name,edition,price from book where id = ?");
pst.setString(1, id);
ResultSet rs = pst.executeQuery();
if(rs.next()==true)
{
String name = rs.getString(1);
String edition = rs.getString(2);
String price = rs.getString(3);
txtbname.setText(name);
txtedition.setText(edition);
txtprice.setText(price);
}
else
{
txtbname.setText("");
txtedition.setText("");
txtprice.setText("");
}
}
catch (SQLException ex) {
}
}
});
txtbid.setBounds(79, 21, 209, 20);
txtbid.setColumns(10);
panel_1.add(txtbid);
JButton btnUpdate = new JButton("Update");
btnUpdate.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String bname,edition,price,bid;
bname = txtbname.getText();
edition = txtedition.getText();
price = txtprice.getText();
bid = txtbid.getText();
try {
pst = con.prepareStatement("update book set name= ?,edition=?,price=? where id =?");
pst.setString(1, bname);
pst.setString(2, edition);
pst.setString(3, price);
pst.setString(4, bid);
pst.executeUpdate();
JOptionPane.showMessageDialog(null, "Record Update!!!!!");
table_load();
txtbname.setText("");
txtedition.setText("");
txtprice.setText("");
txtbname.requestFocus();
}
catch (SQLException e1) {
e1.printStackTrace();
}
}
});
btnUpdate.setFont(new Font("Tahoma", Font.BOLD, 14));
btnUpdate.setBounds(368, 320, 89, 34);
frame.getContentPane().add(btnUpdate);
JButton btnDelete = new JButton("Delete");
btnDelete.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
String bid;
bid = txtbid.getText();
try {
pst = con.prepareStatement("delete from book where id =?");
pst.setString(1, bid);
pst.executeUpdate();
JOptionPane.showMessageDialog(null, "Record Delete!!!!!");
table_load();
txtbname.setText("");
txtedition.setText("");
txtprice.setText("");
txtbname.requestFocus();
}
catch (SQLException e1) {
e1.printStackTrace();
}
}
});
btnDelete.setFont(new Font("Tahoma", Font.BOLD, 14));
btnDelete.setBounds(480, 320, 89, 34);
frame.getContentPane().add(btnDelete);
}
} Write, Run & Share Java code online using OneCompiler's Java online compiler for free. It's one of the robust, feature-rich online compilers for Java language, running the Java LTS version 17. Getting started with the OneCompiler's Java editor is easy and fast. The editor shows sample boilerplate code when you choose language as Java and start coding.
OneCompiler's Java online editor supports stdin and users can give inputs to the programs using the STDIN textbox under the I/O tab. Using Scanner class in Java program, you can read the inputs. Following is a sample program that shows reading STDIN ( A string in this case ).
import java.util.Scanner;
class Input {
public static void main(String[] args) {
Scanner input = new Scanner(System.in);
System.out.println("Enter your name: ");
String inp = input.next();
System.out.println("Hello, " + inp);
}
}
OneCompiler supports Gradle for dependency management. Users can add dependencies in the build.gradle file and use them in their programs. When you add the dependencies for the first time, the first run might be a little slow as we download the dependencies, but the subsequent runs will be faster. Following sample Gradle configuration shows how to add dependencies
apply plugin:'application'
mainClassName = 'HelloWorld'
run { standardInput = System.in }
sourceSets { main { java { srcDir './' } } }
repositories {
jcenter()
}
dependencies {
// add dependencies here as below
implementation group: 'org.apache.commons', name: 'commons-lang3', version: '3.9'
}
Java is a very popular general-purpose programming language, it is class-based and object-oriented. Java was developed by James Gosling at Sun Microsystems ( later acquired by Oracle) the initial release of Java was in 1995. Java 17 is the latest long-term supported version (LTS). As of today, Java is the world's number one server programming language with a 12 million developer community, 5 million students studying worldwide and it's #1 choice for the cloud development.
short x = 999; // -32768 to 32767
int x = 99999; // -2147483648 to 2147483647
long x = 99999999999L; // -9223372036854775808 to 9223372036854775807
float x = 1.2;
double x = 99.99d;
byte x = 99; // -128 to 127
char x = 'A';
boolean x = true;
When ever you want to perform a set of operations based on a condition If-Else is used.
if(conditional-expression) {
// code
} else {
// code
}
Example:
int i = 10;
if(i % 2 == 0) {
System.out.println("i is even number");
} else {
System.out.println("i is odd number");
}
Switch is an alternative to If-Else-If ladder and to select one among many blocks of code.
switch(<conditional-expression>) {
case value1:
// code
break; // optional
case value2:
// code
break; // optional
...
default:
//code to be executed when all the above cases are not matched;
}
For loop is used to iterate a set of statements based on a condition. Usually for loop is preferred when number of iterations is known in advance.
for(Initialization; Condition; Increment/decrement){
//code
}
While is also used to iterate a set of statements based on a condition. Usually while is preferred when number of iterations are not known in advance.
while(<condition>){
// code
}
Do-while is also used to iterate a set of statements based on a condition. It is mostly used when you need to execute the statements atleast once.
do {
// code
} while (<condition>);
Class is the blueprint of an object, which is also referred as user-defined data type with variables and functions. Object is a basic unit in OOP, and is an instance of the class.
class keyword is required to create a class.
class Mobile {
public: // access specifier which specifies that accessibility of class members
string name; // string variable (attribute)
int price; // int variable (attribute)
};
Mobile m1 = new Mobile();
public class Greeting {
static void hello() {
System.out.println("Hello.. Happy learning!");
}
public static void main(String[] args) {
hello();
}
}
Collection is a group of objects which can be represented as a single unit. Collections are introduced to bring a unified common interface to all the objects.
Collection Framework was introduced since JDK 1.2 which is used to represent and manage Collections and it contains:
This framework also defines map interfaces and several classes in addition to Collections.
| Collection | Description |
|---|---|
| Set | Set is a collection of elements which can not contain duplicate values. Set is implemented in HashSets, LinkedHashSets, TreeSet etc |
| List | List is a ordered collection of elements which can have duplicates. Lists are classified into ArrayList, LinkedList, Vectors |
| Queue | FIFO approach, while instantiating Queue interface you can either choose LinkedList or PriorityQueue. |
| Deque | Deque(Double Ended Queue) is used to add or remove elements from both the ends of the Queue(both head and tail) |
| Map | Map contains key-values pairs which don't have any duplicates. Map is implemented in HashMap, TreeMap etc. |