Skip to content

Instantly share code, notes, and snippets.

@sandeshstha
Last active September 15, 2021 07:39
Show Gist options
  • Save sandeshstha/afc26fc3b5a1e7a6bffa1ff6add380b0 to your computer and use it in GitHub Desktop.
Save sandeshstha/afc26fc3b5a1e7a6bffa1ff6add380b0 to your computer and use it in GitHub Desktop.
Java Assignment of JDBC [inserting user input into database]
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 14, 2019 at 06:11 PM
-- Server version: 10.1.30-MariaDB
-- PHP Version: 7.2.1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `book_registration`
--
-- --------------------------------------------------------
--
-- Table structure for table `books_table`
--
CREATE TABLE `books_table` (
`id` int(11) NOT NULL,
`book_name` varchar(200) NOT NULL,
`author_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `books_table`
--
INSERT INTO `books_table` (`id`, `book_name`, `author_name`) VALUES
(1, 'java', 'Nishal sir'),
(10, 'Enter the name of book', 'Enter the name of author'),
(11, 'mathematics', 'sandesh'),
(12, 'mathematics', 'sandesh');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `books_table`
--
ALTER TABLE `books_table`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `books_table`
--
ALTER TABLE `books_table`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

JDBC [INSERT USER INPUT INTO DATABASE]

14th Februrary 2019, Sandesh Shrestha

This program is about the CRUD operation via java's JDBC. This program can insert the user inputted data into our specified database.

Output

JDBC-CRUD-OPERATION

package com.gces.jdbc;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Demo extends Frame
{
// DECLARATIONS FOR DATABASE PART
public static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
public static final String DB_URL = "jdbc:mysql://localhost:3306/book_registration";
public static final String UNAME = "root";
public static final String PASSWORD = "";
String insertQuery;
// for GUI PART
Label bookNameLabel, authorNameLabel;
TextField bookTextField, authorTextField;
Button saveButton;
Demo()
{
prepareGUI();
}
// main function
public static void main(String[] args)
{
Demo obj = new Demo();
obj.dataBaseFunction();
}
public void prepareGUI()
{
this.setTitle("Book Registration System");
this.setSize(500,500);
this.setVisible(true);
this.setLayout(new FlowLayout());
// closable frame
this.addWindowListener(new WindowAdapter()
{
@Override public void windowClosing(WindowEvent we)
{
System.exit(0);
}
});
bookNameLabel = new Label("Book:");
bookTextField = new TextField("Enter the name of Book",50);
authorNameLabel = new Label("Author:");
authorTextField = new TextField("Enter the name of author",50);
saveButton = new Button("SAVE");
this.add(bookNameLabel);
this.add(bookTextField);
this.add(authorNameLabel);
this.add(authorTextField);
this.add(saveButton);
// when user focus on textFields the initial text should be gone. This is for Keyboard focus
bookTextField.addFocusListener(new FocusListener()
{
public void focusGained(FocusEvent f)
{
bookTextField.setText("");
}
public void focusLost(FocusEvent f)
{
if(bookTextField.getText().equals(""))
bookTextField.setText("Enter the name of book");
}
});
authorTextField.addFocusListener(new FocusListener()
{
public void focusGained(FocusEvent f)
{
authorTextField.setText("");
}
public void focusLost(FocusEvent f)
{
if(authorTextField.getText().equals(""))
authorTextField.setText("Enter the name of author");
}
});
}
//database roles comes when user enter the data and click save button
public void dataBaseFunction()
{
saveButton.addActionListener(new ActionListener()
{
@Override public void actionPerformed(ActionEvent e)
{
try
{
insertQuery = "INSERT INTO `books_table`(`book_name`,`author_name`)"+"VALUES(?,?)";
Class.forName(JDBC_DRIVER);
Connection con = DriverManager.getConnection(DB_URL,UNAME,PASSWORD);
PreparedStatement pst = con.prepareStatement(insertQuery);
pst.setString(1,bookTextField.getText());
pst.setString(2,authorTextField.getText());
pst.executeUpdate();
pst.close();
con.close();
}
catch (ClassNotFoundException e1) {
e1.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
});
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment