[go: up one dir, main page]
Scribd
Upload
29 views3 pages

Practical No 20

AJP

Uploaded by

Amar Gaikwad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
29 views3 pages

Practical No 20

AJP

Uploaded by

Amar Gaikwad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Practical No 20:

1.Write a program to delete a record from a table


import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement; // Import Statement

import java.util.Scanner;

public class Emp {

public static void main(String[] args) {

String databaseURL = "jdbc:ucanaccess://C:/Users/admin/OneDrive/Documents/MSBTE.accdb";

try {

Connection con = DriverManager.getConnection(databaseURL);

Statement s = con.createStatement();

s.execute("CREATE TABLE SData ([STUD JD] int, STUD_Name varchar(255), BRANCH varchar(255))");

s.execute("DELETE FROM SData WHERE [STUD JD] = 101");

ResultSet rs = s.executeQuery("SELECT * FROM SData"); // Use executeQuery for SELECT

if (rs != null) {

while (rs.next()) {

System.out.println("ID of the Student: " + rs.getString(1));

System.out.println("Name of Student: " + rs.getString(2));

System.out.println("Branch of Student: " + rs.getString(3));

System.out.println("*******************************************");

rs.close();

s.close();

con.close();

} catch (Exception err) {

System.out.println("ERROR: " + err);

}
XIII. Exercise
1. Develop a program to update name of a student from Jack to John.
import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement; // Import Statement

import java.util.Scanner;

public class Emp2 {

public static void main(String[] args) {

try {

Connection con =
DriverManager.getConnection("jdbc:ucanaccess://C:/Users/admin/OneDrive/Documents/MSBTE.accdb");

Statement s = con.createStatement();

// s.execute("Create Table std (STUD_ID int, STUD_Name varchar(255), BRANCH varchar(255))");

s.executeUpdate("Update std set STUD_NAME = 'john' where STUD_NAME = 'Jack'");

// s.execute("select * from std");

ResultSet rs = s.getResultSet();

if (rs != null) {

while (rs.next()) {

System.out.println("Id of the Student: " + rs.getString(1));

System.out.println("Name of Student: " + rs.getString(2));

System.out.println("Branch of Student: " + rs.getString(3));

System.out.println("********************************************");

s.close();

con.close();

} catch (Exception err) {

System.out.println(" ERROR: " + err);

}
2.Develop a program to delete all record for a product whose "price" id" is greater than 500 and Id is “1234"

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class Pro3 {

public static void main(String[] args) {

try {

Connection con =
DriverManager.getConnection("jdbc:ucanaccess://C:/Users/admin/OneDrive/Documents/MSBTE.accdb");

Statement s = con.createStatement();

int flag = s.executeUpdate("DELETE FROM List WHERE P_id = '1234' AND price > 500");

System.out.println("Rows Deleted: " + flag);

s.execute("SELECT * FROM List");

ResultSet rs = s.getResultSet();

if (rs != null) {

while (rs.next()) {

System.out.println("Id of the Product: " + rs.getString(1));

System.out.println("Price of the Product: " + rs.getString(2));

System.out.println(" ");

s.close();

con.close();

} catch (Exception err) {

System.out.println("ERROR: " + err);

You might also like