Java with Database(SQL) Connection
-------------------------------------------------------------------------------
-----------------------------------------------------------------------
package adv.java;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.swing.*;
public class TestDemo extends JFrame implements ActionListener
{
JTextField t1,t2;
JButton b1;
String s1,s2;
PreparedStatement st;
TestDemo()
{
t1=new JTextField();
add(t1);
t1.setBounds(20,30,70,30);
t2=new JTextField();
add(t2);
t2.setBounds(90,30,70,30);
b1=new JButton("Update");
add(b1);
b1.setBounds(20,70,90,30);
b1.addActionListener(this);
setLayout(null);
}
public void actionPerformed(ActionEvent e)
{
s1=t1.getText();
s2=t2.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","9182004488");
st = con.prepareStatement("update git1 set name=? where course=?");
st.setString(1, s1);
st.setString(2, s2);
}
catch(Exception ex)
{
ex.printStackTrace();
}
try {
if(!st.execute())
{
System.out.println("Record was successfully updated");
JOptionPane.showMessageDialog(rootPane, "sucess");
}
else
{
JOptionPane.showMessageDialog(rootPane, "not updated");
} } catch (SQLException ex) {
}
}
public static void main(String[] args)
{
TestDemo td=new TestDemo();
td.setVisible(true);
td.setSize(450,550);
}
}
Update Database Record using Java Swings
-----------------------------------------------------------------------package adv.java;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.swing.*;
public class TestDemo extends JFrame implements ActionListener
{
JTextField t1,t2;
JButton b1;
String s1,s2;
PreparedStatement st;
TestDemo()
{
t1=new JTextField();
add(t1);
t1.setBounds(20,30,70,30);
t2=new JTextField();
add(t2);
t2.setBounds(90,30,70,30);
b1=new JButton("Update");
add(b1);
b1.setBounds(20,70,90,30);
b1.addActionListener(this);
setLayout(null);
}
public void actionPerformed(ActionEvent e)
{
s1=t1.getText();
s2=t2.getText();
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","9182004488");
st = con.prepareStatement("update git1 set name=? where course=?");
st.setString(1, s1);
st.setString(2, s2);
}
catch(Exception ex)
{
ex.printStackTrace();
}
try {
if(!st.execute())
{
System.out.println("Record was successfully updated");
JOptionPane.showMessageDialog(rootPane, "sucess");
}
else
{
JOptionPane.showMessageDialog(rootPane, "not updated");
} } catch (SQLException ex) {
}
}
public static void main(String[] args)
{
TestDemo td=new TestDemo();
td.setVisible(true);
td.setSize(450,550);
}
}
------------------------------------------------------------------------------------------------------------
Registration Form with database(SQL) using Java Swings
--------------------------------------------------------------------------------------------
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Registration extends JFrame implements ActionListener
{
JLabel l1, l2, l3, l4, l5, l6, l7, l8;
JTextField tf1, tf2, tf5, tf6, tf7;
JButton btn1, btn2;
JPasswordField p1, p2;
Registration()
{
setVisible(true);
setSize(700, 700);
setLayout(null);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setTitle("Registration");
l1 = new JLabel("Registration Form in Windows Form:");
l1.setForeground(Color.GREEN);
l1.setFont(new Font("TimesNewRoman", Font.BOLD, 20));
l2 = new JLabel("Name:");
l3 = new JLabel("Email-ID:");
l4 = new JLabel("Create Passowrd:");
l5 = new JLabel("Confirm Password:");
l6 = new JLabel("Country:");
l7 = new JLabel("State:");
l8 = new JLabel("Phone No:");
tf1 = new JTextField();
tf2 = new JTextField();
p1 = new JPasswordField();
p2 = new JPasswordField();
tf5 = new JTextField();
tf6 = new JTextField();
tf7 = new JTextField();
btn1 = new JButton("Submit");
btn2 = new JButton("Clear");
btn1.addActionListener(this);
btn2.addActionListener(this);
l1.setBounds(100, 30, 400, 30);
l2.setBounds(80, 70, 200, 30);
l3.setBounds(80, 110, 200, 30);
l4.setBounds(80, 150, 200, 30);
l5.setBounds(80, 190, 200, 30);
l6.setBounds(80, 230, 200, 30);
l7.setBounds(80, 270, 200, 30);
l8.setBounds(80, 310, 200, 30);
tf1.setBounds(300, 70, 200, 30);
tf2.setBounds(300, 110, 200, 30);
p1.setBounds(300, 150, 200, 30);
p2.setBounds(300, 190, 200, 30);
tf5.setBounds(300, 230, 200, 30);
tf6.setBounds(300, 270, 200, 30);
tf7.setBounds(300, 310, 200, 30);
btn1.setBounds(50, 350, 100, 30);
btn2.setBounds(170, 350, 100, 30);
add(l1);
add(l2);
add(tf1);
add(l3);
add(tf2);
add(l4);
add(p1);
add(l5);
add(p2);
add(l6);
add(tf5);
add(l7);
add(tf6);
add(l8);
add(tf7);
add(btn1);
add(btn2);
}
public void actionPerformed(ActionEvent e)
{
if (e.getSource() == btn1)
{
int x = 0;
String s1 = tf1.getText();
String s2 = tf2.getText();
char[] s3 = p1.getPassword();
char[] s4 = p2.getPassword();
String s8 = new String(s3);
String s9 = new String(s4);
String s5 = tf5.getText();
String s6 = tf6.getText();
String s7 = tf7.getText();
if (s8.equals(s9))
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "9182004488");
PreparedStatement ps = con.prepareStatement("insert into student values(?,?,?,?,?,?)");
ps.setString(1, s1);
ps.setString(2, s2);
ps.setString(3, s8);
ps.setString(4, s5);
ps.setString(5, s6);
ps.setString(6, s7);
ResultSet rs = ps.executeQuery();
x++;
if (x > 0)
{
JOptionPane.showMessageDialog(btn1, "Data Saved Successfully");
}
}
catch (Exception ex)
{
System.out.println(ex);
}
}
else
{
JOptionPane.showMessageDialog(btn1, "Password Does Not Match");
}
}
else
{
tf1.setText("");
tf2.setText("");
p1.setText("");
p2.setText("");
tf5.setText("");
tf6.setText("");
tf7.setText("");
}
}
public static void main(String args[])
{
new Registration();
}
}
-------------------------------------------------------------------------------------------
Table Creation with java
-------------------------------------------------------------------------------
package adv.java;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class CreateTableWithStatement
{
public static void main(String[] args)
{
String tableCreateQuery = "create table abc(name varchar2(10), course varchar2(10))";
Statement statement = null;
Connection connection = null;
Scanner scanner = new Scanner(System.in);
System.out.println("Please provide below details to connect Oracle Database");
System.out.println("Enter Database");
String dbName = scanner.next();
System.out.println("Enter UserName");
String userName = scanner.next();
System.out.println("Enter Password");
String password = scanner.next();
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
try
{
connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:" + dbName, userName,password);
}
catch (SQLException e)
{
e.printStackTrace();
}
if (connection != null)
{
System.out.println("Successfully connected to Oracle DB");
try
{
statement = connection.createStatement();
System.out.println("Create Table Query :"+tableCreateQuery);
statement.execute(tableCreateQuery);
System.out.println("Table Created Successfully");
}
catch (SQLException e)
{
e.printStackTrace();
}
}
else
{
System.out.println("Failed to connect to Oracle DB");
}
}
}
-------------------------------------------------------------------------------------
Insert Data Into Record with Java
---------------------------------------------------------------------------------------
import java.sql.*;
import java.io.*;
class InsertTest
{
public static void main(String a[])throws Exception
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
System.out.println("Enter the student name:");
String name=br.readLine();
System.out.println("Enter the course");
String course=br.readLine();
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","9182004488");
Statement st=con.createStatement();
int result=st.executeUpdate("insert into git1 values('"+name+"','"+course+"')");
if(result>0)
{
System.out.println( "Successfully inserted");
}
else
{
System.out.println("Insertion failed!");
}
}
}
--------------------------------------------------------------------------------
Retrieve Data from the Record using Java
----------------------------------------------------------------------------------
import java.sql.*;
import java.util.Scanner;
class SelectTest
{
public static void main(String a[])throws Exception
{
Scanner sc=new Scanner(System.in);
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","9182004488");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from git1");
while(rs.next())
System.out.println(rs.getString(1)+"\t"+rs.getString(2));
}
}
Update the Record in Java
--------------------------------------------------------------------------------import java.sql.*;
import java.io.*;
class UpdateTest
{
public static void main(String a[])throws Exception
{
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
System.out.println("Enter the student name to update the record:");
String name=br.readLine();
System.out.println("Enter the course:");
String course=br.readLine();
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","9182004488");
// Statement st=con.createStatement();
// int result=st.executeUpdate("update Student124 set name='"+name+"' where course='"+course+"'");
PreparedStatement st = con.prepareStatement("update git1 set name=? where course=?");
st.setString(1, name);
st.setString(2, course);
if(!st.execute())
{
System.out.println("Record was successfully updated");
}
else
{
System.out.println("Failure!");
}
}
}
---------------------------------------------------------------------------------
Delete Record using java
-------------------------------------------------------------------import java.sql.*;
import java.util.Scanner;
public class delete
{
public static void main(String args[])
{
String course;
String name;
Scanner sc=new Scanner(System.in);
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection(" jdbc:oracle:thin:@localhost:1521:xe", "system", "9182004488");
Statement stmt = con.createStatement();
System.out.println("Enter the name to Delete from the reecord");
name=sc.next();
System.out.println("Enter the course:");
course=sc.next();
// Deleting from database
String q1 = "DELETE from git1 WHERE name = '" + name + "' AND course = '" + course + "'";
int x = stmt.executeUpdate(q1);
if (x > 0)
System.out.println("One User Successfully Deleted");
else
System.out.println("ERROR OCCURED :(");
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
card layout in Swing Java
--------------------------------------------------------------------------------import java.awt.CardLayout;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
public class CardLayoutDemo extends JFrame implements ActionListener
{
JButton b1,b2,b3;
CardLayout cl=new CardLayout();
JPanel page1=new JPanel();
JPanel page2=new JPanel();
JPanel page3=new JPanel();
JPanel controlpanel=new JPanel();
public CardLayoutDemo()
{
add(controlpanel);
controlpanel.setLayout(cl);
b1=new JButton("page1");
page1.add(b1);
b1.setBounds(30,40,50,30);
b2=new JButton("page2");
page2.add(b2);
b2.setBounds(30,40,50,30);
b3=new JButton("page3");
page3.add(b3);
b3.setBounds(30,40,50,30);
controlpanel.add(page1,"1");
controlpanel.add(page2,"2");
controlpanel.add(page3,"3");
cl.show(controlpanel,"1");
page1.setBackground(Color.red);
page2.setBackground(Color.yellow);
page3.setBackground(Color.orange);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
cl.show(controlpanel,"2");
if(e.getSource()==b2)
cl.show(controlpanel,"3");
if(e.getSource()==b3)
cl.show(controlpanel,"1");
}
public static void main(String[] args)
{
CardLayoutDemo cd=new CardLayoutDemo();
cd.setVisible(true);
cd.setSize(750,650);
}
}
Java Multi Button using Button Array in swings with For Loop
------------------------------------------------------------------------------package demo;
import java.awt.FlowLayout;
import javax.swing.*;
public class SwingDemo extends JFrame
{
public SwingDemo()
{
JButton[] btn = new JButton[20];
for(int i=1;i<=10;i++)
{
btn[i]=new JButton(""+i);
add(btn[i]);
}
setLayout(new FlowLayout(FlowLayout.CENTER));
}
public static void main(String[] args)
{
SwingDemo d1=new SwingDemo();
d1.setSize(1200,900);
d1.setVisible(true);
}
}
User Registration and Login using java swings panels
-------------------------------------------------------------------import java.awt.Color;
import java.awt.Font;
import java.awt.event.*;
import javafx.scene.layout.Pane;
import javax.swing.*;
public class SwingDemo extends JFrame implements ActionListener
{
JPanel p1,p2,p3;
JTextField name,mail1,pwd1,mail2,pwd2;
JButton Reg,Login;
JLabel l1;
public SwingDemo()
{
Font fn=new Font("Verdana", Font.BOLD, 30);
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
add(p1);
add(p2);
add(p3);
p1.setBounds(10,30,350,250);
p2.setBounds(10,290,350,250);
p3.setBounds(10,550,350,250);
p1.setBackground(Color.ORANGE);
p2.setBackground(Color.CYAN);
p3.setBackground(Color.GREEN);
name=new JTextField();
p1.add(name);
name.setBounds(10,20,120,30);
mail1=new JTextField();
p1.add(mail1);
mail1.setBounds(10,55,120,30);
pwd1=new JTextField();
p1.add(pwd1);
pwd1.setBounds(10,90,120,30);
Reg=new JButton("signup");
p1.add(Reg);
Reg.setBounds(10,125,120,30);
p1.setLayout(null);
mail2=new JTextField();
p2.add(mail2);
mail2.setBounds(10,55,120,30);
pwd2=new JTextField();
p2.add(pwd2);
pwd2.setBounds(10,90,120,30);
Login=new JButton("Login");
p2.add(Login);
Login.setBounds(10,125,120,30);
p2.setLayout(null);
l1=new JLabel();
p3.add(l1);
l1.setBounds(10,20,300,50);
p3.setLayout(null);
Reg.addActionListener(this);
Login.addActionListener(this);
setLayout(null);
}
public void actionPerformed(ActionEvent e)
{
String s1,s2,s3,s4,s5;
s1=name.getText();
s2=mail1.getText();
s3=pwd1.getText();
if(e.getSource()==Reg)
{
if(name.getText().isEmpty()||mail1.getText().isEmpty()||pwd1.getText().isEmpty())
{
JOptionPane.showMessageDialog(this,"must fill the fields");
}
else
{
JOptionPane.showMessageDialog(this,"Success,Login in ur account");
}
}
if(e.getSource()==Login)
{
s4=mail2.getText();
s5=pwd2.getText();
if(mail2.getText().isEmpty()||pwd2.getText().isEmpty())
{
JOptionPane.showMessageDialog(this,"must fill the fields");
}
if(s4.equals(s2)==true&&s5.equals(s3)==true)
{
l1.setText("Hello,"+s1);
}
}
}
public static void main(String[] args)
{
SwingDemo d1=new SwingDemo();
d1.setSize(1200,900);
d1.setVisible(true);
}
}
Basic Java Swing button Action
---------------------------------------------------------------------------------------------import java.awt.Color;
import java.awt.Font;
import java.awt.event.*;
import javax.swing.*;
public class SwingDemo extends JFrame implements ActionListener
{
JTextField t1;
JButton b1,b2,b3;
JLabel l1;
public SwingDemo()
{
Font fn=new Font("Verdana", Font.BOLD, 30);
t1=new JTextField();
add(t1);
t1.setBounds(20,30,70,30);
b1=new JButton("Click1");
add(b1);
b1.setBounds(95,30,70,30);
b1.addActionListener(this);
l1=new JLabel();
add(l1);
l1.setFont(fn);
l1.setBounds(20,120,260,35);
setLayout(null);
}
public void actionPerformed(ActionEvent e)
{
String s1=t1.getText();
l1.setText("Hello,"+s1);
l1.setForeground(Color.red);
}
public static void main(String[] args)
{
SwingDemo d1=new SwingDemo();
d1.setSize(800,750);
d1.setVisible(true);
}
}
0 Comments