Question-1 Implement the Employee DAO Factory & JDBC
Answer:-
package temp;
public class EmployeeDAOFactory {
public static void main(String[] args){
EmployeeDAOJDBCImpl edji=new EmployeeDAOJDBCImpl();
edji.AddEmployee(1,"hita", "IT");
edji.AddEmployee(2, "meenal", "IT");
edji.AddEmployee(3, "deepika", "IT");
edji.AddEmployee(4, "aniket", "IT");
edji.AddEmployee(5, "piyu", "HR");
edji.RemoveEmployee(5, "piyu", "HR");
}
}
package temp;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class EmployeeDAOJDBCImpl {
Connection con;
String query1,query2;
public EmployeeDAOJDBCImpl(){
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/Employee","root","root");
System.out.println("Database connected successfully");
} catch (ClassNotFoundException ex) {
System.out.println("Driver not found");
} catch (SQLException ex) {
System.out.println("DB not found");
}
}
public void AddEmployee(int id,String name,String depart){
try {
query1="insert into employee values(?,?,?)";
PreparedStatement pst1=con.prepareStatement(query1);
pst1.setInt(1, id);
pst1.setString(2, name);
pst1.setString(3, depart);
pst1.executeUpdate();
System.out.println("Added"+name);
} catch (SQLException ex) {
System.out.println("Error in data");
}
}
public void RemoveEmployee(int id,String name,String depart){
try {
query2="delete from Employee where id=? name=? depart=? ";
PreparedStatement pst2=con.prepareStatement(query2);
pst2.setInt(1, id);
pst2.setString(2, name);
pst2.setString(3, depart);
pst2.executeUpdate();
System.out.println("Removed"+name);
} catch (SQLException ex) {
System.out.println("Error in data");
}
}
}
Question-2 Read,Write the file using Buffered Reader.
Answer:-
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.FileReader;
import java.io.FileWriter;
import java.util.Scanner;
public class FileOperation {
public void readFile() {
Scanner sc = new Scanner(System.in);
String fileName;
System.out.print("Enter the text file name that you want to read from the D:\\ drive: "); fileName = sc.nextLine();
try (BufferedReader br = new BufferedReader(new FileReader("D:\\" + fileName + ".txt "))) {
String s;
System.out.println("\nThe " + fileName + " contains the following text:\n");
System.out.println
while ((s = br.readLine()) != null) {
System.out.println(s);
}
} catch (Exception e) {
System.out.println("File does not exists."); menu();
}
}
public void writeFile() {
Scanner sc = new Scanner(System.in);
String fileName, text;
System.out.print("Enter the file name from the D:\\ drive in which you 'want to write: "); fileName = sc.nextLine ();
System.out.print("Enter the text you want to write in the " + fileName + " file: "); text = sc.nextLine();
try {
FileWriter fos = new FileWriter("D:\\" + fileName + ".txt", true);
BufferedWriter bw = new BufferedWriter(fos); bw.newLine(); bw.write(text);
bw.close (); fos.close();
System.out.println("\nThe text has been added in the file");
} catch (Exception e) {
System.out.println("File does not exists"); menu();
}
}
public void searchFileO {
Scanner sc = new Scanner(System.in);
String fileName, text; int counter = 0, flag = 0;
System.out.print("Enter the file name from the D:\\ drive in which you want to search: ");
fileName = sc.nextLine();
System.out.print("Enter the string you want to search in the " + fileName + " file: "); text = sc.nextLine();
try (BufferedReader br = new BufferedReader(new FileReader("D:\\" + fileName + ".txt "))) {
String s;
while ((s = br.readLine()) != null) {
String splitData() = s.split(" ");
{
for (int i = 0; i < splitData.length; i++) if (splitData(i].equals(text)) {
if (splitData(i].equals(text)) {
counter++; flag = 1;
}
}
} catch (Exception e) {
System.out.println("File does not exits"); menu () ;
}
if (flag == 1) (
if (counter == 1) {
System.out.println("\"" + text + "\" has occured " + counter + " time");
} else {
System.out.println("\"" + text + "\" has occured " + counter + " times");
}
} else {
System.out.println("The entered word doest not exist in the file.");
}
public void menu() { int option;
Scanner sc = new Scanner(System.in);
System, out. print In (" \n-----Menu---------") ;
System.out.println("1. Reading");
System.out.println("2. Writing");
System.out.println("3. Searching");
System.out.println("4. Exit");
System.out.print("\nChoose the option: ")
option = sc.nextInt();
switch (option) { case 1:
readFile(); menu(); break; case 2:
writeFile(); menu(); break; case 3:
searchFile();
menu(); break; case 4:
System.exit(0); break; default:
System.out.println("Incorrect menu option");
menu(); break;
}
}
public static void main(String!) args) {
FileOperation fo = new FileOperation() fo.menu();
}
}
i need this
ReplyDelete