how to write this query in JDBC, \" 1)ask for gender. 2)ask for region . 3) show

Question

how to write this query in JDBC, "
1)ask for gender.
2)ask for region .
3) show all gym leader bassed on there gender and region user enters also show the place of thier gym

CREATE TABLE Characters (
name CHAR (50),
gender CHAR(1),
class CHAR (25),
origin CHAR (25),
PRIMARY KEY (name)
);

CREATE TABLE Gymleaders (
characterName CHAR (50),
battleStyle CHAR (25),
badge CHAR (25),
PRIMARY KEY (characterName)
);

CREATE TABLE Gyms (
characterName CHAR (50),
placeName CHAR (50),
PRIMARY KEY (characterName)
);

Explanation / Answer

/* since there is no foreign key i am assuming charactername is common in all tables*/

String gender="male" //take user input gender
String place="place" //take user input place

//create statement
Statement stmt = conn.createStatement();

//query
//select name from character table then select gymleader and gymplace where character name is in character table
String query="SELECT Gymleaders.characterName,Gyms.placeName from Gymleaders,Gyms where Gymleaders.characterName=Gyms.characterName and Gyms.characterName in (SELECT name from character where gender=/"male/" and origin=/"place/")";

//create resultset
ResultSet rs = stmt.executeQuery(query);

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.