Create a bean called JDBCQueryBean that is a modification of JDBCBean.

(i) Create a bean called JDBCQueryBean that is a modification of

 

JDBCBean. Instead of dealing only with a fixed query 'SELECT * FROM

Accounts', this bean should be capable of processing any query directed at the

Accounts/Stock table (depending upon which database you are using). The

code for the major method getQueryResults is supplied overleaf. In addition

to this method, the bean should provide read/write access to a property called

query that holds the current query (and has a default value of 'SELECT *

FROM Accounts'). Read access should also be provided to properties

numFields (holding the number of fields in the query) and numRows (the

number of rows in the query results).

(ii) Create a simple HTML page that uses a text field in a form to accept the

user's query and pass it on to a JSP called JDBCQuery.jsp.

(iii) Possibly using JDBC.jsp as a starting point, produce a JSP that accepts

the query from the above HTML page and then uses the bean to display the

results of the query in a table.

public static Vector getQueryResults()

throws SQLException

{

results = statement.executeQuery(getQuery());

metaData = results.getMetaData();

numFields = metaData.getColumnCount();

queryResults = new Vector();

fieldNames = new Vector();

dataTypes = new Vector();

for (int i=1; i<=numfields;>

fieldNames.add(metaData.getColumnName(i));

while (results.next())

{

for (int i=1; i<=numfields;>

{

int colType = metaData.getColumnType(i);

switch (colType)

{

case Types.INTEGER:

queryResults.add(results.getInt(i));

dataTypes.add(“integer”);

break;

case Types.VARCHAR:

queryResults.add(

results.getString(i));

dataTypes.add(“string”);

break;

case Types.NUMERIC:

queryResults.add(

results.getFloat(i));

dataTypes.add(“float”);

break;

default: //Hopefully, will never happen!

queryResults.add(

results.getString(i));

dataTypes.add(“string”);

}

}

}

return queryResults;

find the cost of your paper

Use more advanced interface item rather just text fields for the form (e.g. switches or segmented controls should be use for gender, stepper for age and table view for showing the list of friends.

Personal Management App for iOS (Assignment deadline: Wednesday 03/02/2021, 11:59pm (Week 14) on vUWS. You must demonstrate your assignment at the usual tutorial in week 14) Assignment Details For this….

create a design document for the desktop part of the application.

Description In your job you are to build the Maryland State Police Vehicle of Interest user interface, your first assignment will be to create a design document for the desktop….

Provide the main interface and implemented actions where user can select an option from the buttons/menus for manipulating the events including 4. An Info screen where it will ask for read me.

Personal Management App for iOS (Assignment deadline: Wednesday 03/02/2021, 11:59pm (Week 14) on vUWS. You must demonstrate your assignment at the usual tutorial in week 14) Assignment Details For this….