Open an existing db to write data

[Krithika Beri]

I want to open the existing database file and write the data into it . I am using the sqlite database.
Here is the snippet:

	Class.forName("org.sqlite.JDBC");
			conn = DriverManager.getConnection("jdbc:sqlite:" + filesave);
			
			if (res == 1) {
				statement = conn.createStatement();

				statement.execute("drop table if exists logical");
				statement.execute("drop table if exists physical");
				statement.execute("drop table if exists SQLITEADMIN_QUERIES");
				statement.execute("drop table if exists android_metadata");
				statement
						.executeUpdate("CREATE TABLE logical (_id INTEGER DEFAULT '1' PRIMARY KEY AUTOINCREMENT NOT NULL,uri UNIQUE,description,post_requisite,pre_requisite,acl,passwd,is_locked,class,rating,play_order,params,status,extras,name,uid,updated_at,price,tags);");
				statement
						.executeUpdate("create table physical (_id INTEGER DEFAULT '1' PRIMARY KEY AUTOINCREMENT NOT NULL,uri UNIQUE,src,mime_type,nav_labeltext,nav_labelimg,extras,uid,publisher_id,updated_at);");
				statement
						.executeUpdate("create table SQLITEADMIN_QUERIES(ID INTEGER PRIMARY KEY,NAME VARCHAR(100),SQL TEXT);");
				statement
						.executeUpdate("create table \"android_metadata\" (\"locale\" TEXT DEFAULT 'en_US');");
				statement
						.executeUpdate("insert into \"android_metadata\" VALUES ('en_US');");
				
				statement
						.executeUpdate("CREATE INDEX edutorcontentlogical_uri	ON  edutorcontentlogical (uri);");
				statement
						.executeUpdate("CREATE INDEX edutorcontentphysical_uri	ON  edutorcontentphysical (uri);");
			}
			preparedStmt = conn
					.prepareStatement("insert into logical values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);");
			preparedStmt1 = conn
					.prepareStatement("insert into physical values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);");

			System.out.println("eeeeeeeeeeeeeeeeeeeeeeeeerrrrrrrrrrrrrrrrrrrrrrrrrrrr");
			buildTree(rootElement);
			conn.close();
		} catch (Exception e) {
			System.err.println("Error: " + e.getMessage());
		}

i am asking if you want to write the data into existing db, if there is existing db then res=1 and if it is not there res=0

[Krithika Beri]

Sorry if there is existing db then res=0 if it is not there then it is 1
if i use the existing database it is saying that file is encrypted or it is not a database