package sef.module11.activity;

import junit.framework.TestCase;

public class NotepadTest extends TestCase {

	public void testSaveAs() {
		fail("Not yet implemented");
	}

	public void testTypeIn() {
		fail("Not yet implemented");
	}

}

junit.framework.AssertionFailedError: Not yet implemented

	at junit.framework.Assert.fail(Assert.java:47)
	at sef.module11.activity.NotepadTest.testSaveAs(NotepadTest.java:8)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:567)
	at junit.framework.TestCase.runTest(TestCase.java:164)
	at junit.framework.TestCase.runBare(TestCase.java:130)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:120)
	at junit.framework.TestSuite.runTest(TestSuite.java:230)
	at junit.framework.TestSuite.run(TestSuite.java:225)
	at junit.textui.TestRunner.doRun(TestRunner.java:121)
	at com.intellij.junit3.JUnit3IdeaTestRunner.doRun(JUnit3IdeaTestRunner.java:113)
	at junit.textui.TestRunner.doRun(TestRunner.java:114)
	at com.intellij.junit3.JUnit3IdeaTestRunner.startRunnerWithArgs(JUnit3IdeaTestRunner.java:45)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)


junit.framework.AssertionFailedError: Not yet implemented

	at junit.framework.Assert.fail(Assert.java:47)
	at sef.module11.activity.NotepadTest.testTypeIn(NotepadTest.java:12)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:567)
	at junit.framework.TestCase.runTest(TestCase.java:164)
	at junit.framework.TestCase.runBare(TestCase.java:130)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:120)
	at junit.framework.TestSuite.runTest(TestSuite.java:230)
	at junit.framework.TestSuite.run(TestSuite.java:225)
	at junit.textui.TestRunner.doRun(TestRunner.java:121)
	at com.intellij.junit3.JUnit3IdeaTestRunner.doRun(JUnit3IdeaTestRunner.java:113)
	at junit.textui.TestRunner.doRun(TestRunner.java:114)
	at com.intellij.junit3.JUnit3IdeaTestRunner.startRunnerWithArgs(JUnit3IdeaTestRunner.java:45)
	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)


Process finished with exit code -1

Create a very simple console text file editor using Java.
When the application is launched pass via command-line arguments the name of a file (new or existing) where the text will be saved.
When the application is launched the application will keep on reading lines entered via the keyboard until the user types ‘END’ and presses ‘ENTER’.
The application should save all the lines of text entered in the designated file.
In the package explorer, place all files in sef.module11.activity package.

public boolean insertAccount(String firstName, String lastName, String email)
			throws AccountDAOException {

		try {
			pst=conn.prepareStatement("Insert into ACCOUNT (ID,FIRST_NAME,LAST_NAME,E_MAIL) values ([color=yellow]id.nextVa[/color]l,?,?,?)");

		pst.setString(1,firstName);
		pst.setString(2,lastName);
		pst.setString(3,email);
			b=pst.execute();
		} catch (SQLException e) {
			e.printStackTrace();
		}return b;

public boolean insertAccount(String firstName, String lastName, String email)
			throws AccountDAOException {

		try {
			pst=conn.prepareStatement("Insert into ACCOUNT (ID,FIRST_NAME,LAST_NAME,E_MAIL) values ([color=yellow]id.nextVa[/color]l,?,?,?)");

		pst.setString(1,firstName);
		pst.setString(2,lastName);
		pst.setString(3,email);
			b=pst.execute();
		} catch (SQLException e) {
			e.printStackTrace();
		}return b;

CREATE sequence ACCOUNT_SEQ;
CREATE sequence EMPLOYEE_SEQ;
CREATE sequence PROJECT_SEQ;
CREATE sequence EMPL_PROJECT_MAP_SEQ;

--------------------------------------------------------
--  DDL for Table ACCOUNT
--------------------------------------------------------

  CREATE TABLE "ACCOUNT"
   (	"ID" NUMBER(10,0) PRIMARY KEY,
	"FIRST_NAME" VARCHAR2(45 CHAR) NOT NULL,
	"LAST_NAME" VARCHAR2(45 CHAR) NOT NULL,
	"E_MAIL" VARCHAR2(45 CHAR) NOT NULL
   );
--------------------------------------------------------
--  DDL for Table EMPLOYEE
--------------------------------------------------------

  CREATE TABLE "EMPLOYEE"
   (	"ID" NUMBER  PRIMARY KEY,
	"FIRSTNAME" VARCHAR2(45 CHAR) NOT NULL,
	"LASTNAME" VARCHAR2(45 CHAR) NOT NULL,
	"PROF_LEVEL" NUMBER(10,0) NOT NULL
   );
--------------------------------------------------------
--  DDL for Table EMPLOYEE_PROJECT_MAP
--------------------------------------------------------

  CREATE TABLE "PROJECT"
   (
	"ID" NUMBER(10,0)  PRIMARY KEY,
	"NAME" VARCHAR2(45 CHAR) NOT NULL,
	"DESCRIPTION" VARCHAR2(100 CHAR) NOT NULL
   );

  CREATE TABLE "EMPLOYEE_PROJECT_MAP"
   (	"ID" NUMBER(10,0)  PRIMARY KEY,
	"EMPLOYEE_ID" NUMBER(10,0)  NOT NULL,
	"PROJECT_ID" NUMBER(10,0)  NOT NULL,

	CONSTRAINT "EMPLOYEE_PROJECT_MAP_EMPL_FK1" FOREIGN KEY ("ID") REFERENCES "EMPLOYEE" ("ID"),
	CONSTRAINT "EMPLOYEE_PROJECT_MAP_PROJ_FK1" FOREIGN KEY ("ID") REFERENCES "PROJECT" ("ID")
   );

--------------------------------------------------------
--  Insert data
--------------------------------------------------------

Insert into ACCOUNT (ID, FIRST_NAME,LAST_NAME,E_MAIL) values (ACCOUNT_SEQ.NEXTVAL, 'JOHN','DOE','JOHN.DOE@FASTMAIL.COM');
Insert into ACCOUNT (ID, FIRST_NAME,LAST_NAME,E_MAIL) values (ACCOUNT_SEQ.NEXTVAL, 'JANE','DOE','JANE.DOE@FASTMAIL.COM');

Insert into EMPLOYEE (ID, FIRSTNAME,LASTNAME,PROF_LEVEL) values (EMPLOYEE_SEQ.NEXTVAL, 'John','Doe',1);
Insert into EMPLOYEE (ID, FIRSTNAME,LASTNAME,PROF_LEVEL) values (EMPLOYEE_SEQ.NEXTVAL, 'Jane','Doe',2);
Insert into EMPLOYEE (ID, FIRSTNAME,LASTNAME,PROF_LEVEL) values (EMPLOYEE_SEQ.NEXTVAL, 'Scott','Feist',1);
Insert into EMPLOYEE (ID, FIRSTNAME,LASTNAME,PROF_LEVEL) values (EMPLOYEE_SEQ.NEXTVAL, 'James','Donnell',3);
Insert into EMPLOYEE (ID, FIRSTNAME,LASTNAME,PROF_LEVEL) values (EMPLOYEE_SEQ.NEXTVAL, 'Michael','Dorn',5);

Insert into PROJECT (ID, NAME,DESCRIPTION) values (PROJECT_SEQ.NEXTVAL, 'Online Insurance System','A web application that automates insurance transactions.');
Insert into PROJECT (ID, NAME,DESCRIPTION) values (PROJECT_SEQ.NEXTVAL, 'Time Report System','A stand-alone application that records and generates time reports.');
Insert into PROJECT (ID, NAME,DESCRIPTION) values (PROJECT_SEQ.NEXTVAL, 'Real Estate Search System','An online search engine specifically for real estates.');
Insert into PROJECT (ID, NAME,DESCRIPTION) values (PROJECT_SEQ.NEXTVAL, 'Online Shopping System','A web application that handles shopping transactions online.');

Insert into EMPLOYEE_PROJECT_MAP (ID, EMPLOYEE_ID,PROJECT_ID) values (EMPL_PROJECT_MAP_SEQ.NEXTVAL, 2,3);
Insert into EMPLOYEE_PROJECT_MAP (ID, EMPLOYEE_ID,PROJECT_ID) values (EMPL_PROJECT_MAP_SEQ.NEXTVAL, 3,2);
Insert into EMPLOYEE_PROJECT_MAP (ID, EMPLOYEE_ID,PROJECT_ID) values (EMPL_PROJECT_MAP_SEQ.NEXTVAL, 1,1);
Insert into EMPLOYEE_PROJECT_MAP (ID, EMPLOYEE_ID,PROJECT_ID) values (EMPL_PROJECT_MAP_SEQ.NEXTVAL, 4,3);