Question: What are the errors in the following code? In addition, are there any security vulnerabilities present in this code? Example DAO for a shipping tracking
Example DAO for a shipping tracking system import java.sql.ResultSet import java.sql.ResultSetMetaData: mport java.sqlSQLExceptiorn import java.sql Statement: import java.util.Vector import com.mysql.jdbc.MySQLConnection Is used as the database access object to retum a result set of a given query public class DAO ( public MySQLConnection mConnection private ResultSetMetaData mMetaData; private VectorsString mColumns public DAO(MySQLConnection Connection) this.mConnectionConnection Runs the query and retums a Vector of Vectors as a result @param mQuery @retum Vectors Veclors Stringe> @hrows SQlException public VectorsVectorsStrings runQuery(String mQuery) throws SQLException VectorsVector String> mResults new Vector VectorsString 0 Statement mStatement (Statement) this.mConnection.createStatement); Resultset m ResultSet = mStatement.executeQuery(mQuery); mMetaData = mResultSet.getMetaData(); int mNumColumns mMetaData.getColumnCounto setColumns(mNumColumns mMetaData) whilefmResuiltset.nexto)X Vector
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
