Assignment No:3

//Assignment No:3

Set A

a) Create a PROJECT table with fields project_id, Project_name, Project_description, Project_Status. etc. Insert values in the table. Display all the details of the PROJECT table in a tabular format on the screen.(using swing).

CODE

👇

package project;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
class Project extends JFrame implements ActionListener
{
JLabel l1,l2,l3,l4;
JTextField t1,t2,t3,t4;
JButton b1,b2,b3;
String sql;
JPanel p,p1;
Connection con;
PreparedStatement ps;
JTable t;
JScrollPane js;
Statement stmt ;
ResultSet rs ;
ResultSetMetaData rsmd ;
int columns;
Vector columnNames = new Vector();
Vector data = new Vector();
Project()
{
l1 = new JLabel("Enter Project ID :");
l2 = new JLabel("Enter Project name :");
l3 = new JLabel(" Enter Project Info :");
l4 = new JLabel(" Enter Project Status :");
t1 = new JTextField(20);
t2 = new JTextField(20);
t3 = new JTextField(30);
t4 = new JTextField(30);
b1 = new JButton("Save");
b2 = new JButton("Display");
b3 = new JButton("Clear");
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
p=new JPanel();
p1=new JPanel();
p.add(l1);
p.add(t1);
p.add(l2);
p.add(t2);
p.add(l3);
p.add(t3);
p.add(l4);
p.add(t4);
p.add(b1);
p.add(b2);
p.add(b3);
add(p);
setLayout(new GridLayout(2,1));
setSize(600,800);
setVisible(true);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public void actionPerformed(ActionEvent e)
{
if((JButton)b1==e.getSource())
{
int project_id = Integer.parseInt(t1.getText());
String project_name = t2.getText();
String project_desc = t3.getText();
String project_status = t4.getText();
System.out.println("Accept Values");
try
{
Class.forName("org.postgresql.Driver");
con=DriverManager.getConnection("jdbc:postgresql:DATABASE_NAME","postgres","TYPE_PASSWORD_OF_DATABASE");
sql = "insert into project values(?,?,?,?)";
ps = con.prepareStatement(sql);
ps.setInt(1,project_id);
ps.setString(2, project_name);
ps.setString(3,project_desc);
ps.setString(4,project_status);
System.out.println("values set");
int n=ps.executeUpdate();
if(n!=0)
{
JOptionPane.showMessageDialog(null,"Record insered ...");
}
else
JOptionPane.showMessageDialog(null,"Record NOT inserted ");
}
catch(Exception ex)
{
System.out.println(ex);
}
}
else if((JButton)b2==e.getSource())
{
try
{
Class.forName("org.postgresql.Driver");
con=DriverManager.getConnection("jdbc:postgresql:DATABASE_NAME","postgres","TYPE_PASSWORD_OF_DATABASE");
System.out.println("Connected");
stmt=con.createStatement();
rs = stmt.executeQuery("select * from project");
rsmd = rs.getMetaData();
columns = rsmd.getColumnCount();
for(int i = 1; i <= columns; i++)
{
columnNames.addElement(rsmd.getColumnName(i));
}
while(rs.next())
{
Vector row = new Vector(columns);
for(int i = 1; i <= columns; i++)
{
row.addElement(rs.getObject(i));
}
data.addElement(row);
}
t = new JTable(data, columnNames);
js = new JScrollPane(t);
p1.add(js);
add(p1);
setSize(600, 600);
setVisible(true);
}
catch(Exception e1)
{
System.out.println(e1);
}
}
else
{
t1.setText(" ");
t2.setText(" ");
t3.setText(" ");
t4.setText("");
}
}
public static void main(String a[])
{
Project p = new Project();
}
}

b) Write a program to display information about the database and list all the tables in the database. (Use DatabaseMetaData).

CODE

👇

package database1;
/**
*
* @author ThE ProFessoR
*/
import java.sql.*;
public class Database1
{
public static void main(String[] args)
{
try
{
Class.forName("org.postgresql.Driver");
Connection conn=DriverManager.getConnection("jdbc:postgresql:DATABASE_NAME","postgres","TYPE_PASSWORD_OF_DATABASE");
DatabaseMetaData dbmd = conn.getMetaData();
System.out.println("\t-----------------------------------------------------");
System.out.println("\t\tDriver Name"+dbmd.getDriverName());
System.out.println("\t\tDriver Version"+dbmd.getDriverVersion());
System.out.println("\t\tUser Name"+dbmd.getUserName());
System.out.println("\t\tDatabase Product Name"+dbmd.getDatabaseProductName());
System.out.println("\t\tDatabase Product Version"+dbmd.getDatabaseProductVersion());
System.out.println("\t-------------------------------------------------------");
String table[] = {"TABLE"};
ResultSet rs = dbmd.getTables(null, null, null, table);
System.out.println("\t\tTables Names:");
while(rs.next())
{
System.out.println(rs.getString("TABLE_NAME"));
}
rs.close();
conn.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}

c) Write a program to display information about all columns in the DONAR table using ResultSetMetaData.

CODE

👇

package donar;
/**
*
* @author ThE ProFessoR
*/
import java.sql.*;
public class Donar
{
public static void main(String[] args)
{
try
{
Class.forName("org.postgresql.Driver");
Connection con = DriverManager.getConnection("jdbc:postgresql:DATABASE_NAME","postgres","TYPE_PASSWORD_OF_DATABASE");
Statement stmt = null;
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * From Donar");
ResultSetMetaData rsmd = rs.getMetaData();
System.out.println("----------------------------------------");
int count = rsmd.getColumnCount();
System.out.println("\tNo. of Cloumns"+rsmd.getColumnCount());
System.out.println("----------------------------------------");
for(int i =1; i < count; i++)
{
System.out.println("\t\tColumn No "+i);
System.out.println("\t\tColumn Name "+rsmd.getColumnName(i));
System.out.println("\t\tColumn Type "+rsmd.getColumnTypeName(i));
System.out.println("\t\tColumn Display Size"+rsmd.getColumnDisplaySize(i));
System.out.println();
}
System.out.println("----------------------------------------");
rs.close();
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}

Set B

a) Create a MOBILE table with fields Model_Number, Model_Name, Model_Color, Sim_Type, NetworkType, BatteryCapacity, InternalStorage, RAM and ProcessorType. Insert values in the table. Write a menu driven program to pass the input using Command line argument to perform the following operations on MOBILE table.

1. Insert 2. Modify 3. Delete 4. Search 5. View All 6. Exit

CODE

👇

package mobile;
import java.sql.*;
import java.util.*;
public class Mobile
{
public static void main(String[] args) {
{
Connection con;
con = null;
PreparedStatement pstmt ;
pstmt = null ;
Statement stmt ;
stmt = null;
ResultSet rs = null;
try
{
Class.forName("org.postgresql.Driver");
con = DriverManager.getConnection("jdbc:postgresql:DATABASE_NAME","postgres","TYPE_PASSWORD");
Scanner sc = new Scanner(System.in);
System.out.println("\n Mobile Information ");
do {
System.out.println("\n \t 1.Insert \n \t 2. Modify \n\t 3.delete \n\t 4.search \n\t 5.view all 6.Exit \n");
System.out.println("\n Enter Your Choice");
int ch = sc.nextInt();
switch(ch)
{
case 1 :
pstmt = con.prepareStatement("insert into Mobile values (?,?,?,?,?,?,?,?)");
System.out.println("\n Enter Model Number ");
int mno = sc.nextInt();
pstmt.setInt(1,mno);
sc.nextLine();
System.out.println("\n Enter Model Name ");
String name = sc.next();
sc.nextLine();
pstmt.setString(2,name);
System.out.println("\n Enter Model_color ");
String color = sc.next();
sc.nextLine();
pstmt.setString(3, color);
System.out.println("\n Enter sim type ");
String type = sc.next();
sc.nextLine();
pstmt.setString(4, type);
System.out.println("\n Enter Battery Capacity");
int battery = sc.nextInt();
pstmt.setInt(5, battery);
System.out.println("\n Enter Internal Storage in GB:");
int internal = sc.nextInt();
pstmt.setInt(6, internal);
System.out.println("\n Enter RAM in GB ");
int ram = sc.nextInt();
pstmt.setInt(7, ram);
sc.nextLine();
System.out.println("\n Enter Procsser Type ");
String pr = sc.next();
sc.nextLine();
pstmt.setString(8, pr);
int result = pstmt.executeUpdate();
System.out.println(result+" Recort Inserted \n ");
break;
case 2 :
String SQL = "update mobile set name=? where mno=?";
pstmt = con.prepareStatement(SQL);
System.out.println("\n Enter Model No for Update Record ");
int no = sc.nextInt();
pstmt.setInt(2, no);
sc.nextLine();
System.out.println("\n Enter Upadated Model Name ");
String mname = sc.next();
sc.nextLine();
pstmt.setString(1, mname);
int result2 = pstmt.executeUpdate();
System.out.println(result2+"\n Record updated");
break;
case 3 :
pstmt = con.prepareStatement("delete from Mobile where mno=?");
System.out.println("\n Enter Model no for delete the record");
int model = sc.nextInt();
pstmt.setInt(1, model);
int result3 = pstmt.executeUpdate();
System.out.println(result3+"\n Record deleted");
break;
case 4 :
pstmt = con.prepareStatement("select * from Mobile where mno=?");
System.out.println("\n Enter Model No for search record ");
int m = sc.nextInt();
pstmt.setInt(1, m);
rs = pstmt.executeQuery();
System.out.println("\n ---------------- ");
while(rs.next())
{
System.out.println("\n" +rs.getInt(1) + "\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getInt(5)+"\t"+rs.getInt(6)+"\t"+rs.getInt(7)+"\t"+rs.getString(8));
}
System.out.println("\n ---------------- ");
break;
case 5:
pstmt = con.prepareStatement("select * from Mobile");
System.out.println("\n ---------------- ");
while(rs.next())
{
System.out.println("\n" +rs.getInt(1) + "\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getInt(5)+"\t"+rs.getInt(6)+"\t"+rs.getInt(7)+"\t"+rs.getString(8));
}
System.out.println("\n ---------------- ");
break;
case 6:
System.exit(1);
rs.close();
stmt.close();
pstmt.close();
con.close();
sc.close();
}
} while(true);
}
catch(ClassNotFoundException | SQLException e)
{
System.out.println(e);
}
}
}
}

b) Design a following Registration form and raise an appropriate exception if invalid information is entered like Birth Year ‘0000’

CODE

👇

//Code Of Java2

Search This Blog

Assignment No:3