CODEWITHSUNDEEP
mysqljspjsp-tagsjspinclude
Mohit Bhardwaj
Mohit Bhardwaj

Reputation: 23

Unable to execute the search page in jsp

Trying to execute the serachpage.jsp which can search out data from database on search id basis. Basically I'm getting an error after the select statement.

Code:

<%

try {
    String value = request.getParameter("Issue_ID");
    int Issue_ID=Integer.parseInt(value);
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/report_tracking","root", "root");
    Statement st = conn.createStatement();
    ResultSet rs = st.executeQuery("select * from issue_creating where Issue_ID='"+Issue_ID+"'");
    if(rs.next()) {         
        rs.getString("Problem_Submit");  
        rs.getString("Problem_Submit"); 
        rs.getString("Problem_Descr"); 
    }

%>

Error:

An error occurred at line: [108] in the generated java file: [D:\mohit\apache-tomcat-7.0.37\work\Catalina\localhost_\org\‌​apache\jsp\serachisue_jsp.java]
Syntax error, insert "Finally" to complete TryStatement
An error occurred at line: [109] in the generated java file: [D:\mohit\apache-tomcat-7.0.37\work\Catalina\localhost_\org\‌​apache\jsp\serachisue_jsp.java]
Syntax error, insert "}" to complete ClassBody

Upvotes: 0

Views: 203

Answers (1)

shola
shola

Reputation: 704

} bracket missing for try block:

try { 
    String value = request.getParameter("Issue_ID"); int  Issue_ID = Integer.parseInt(value);
    Class.forName("com.mysql.jdbc.Driver").newInstance(); 
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/report_tracking","root", "root"); 
    Statement st = conn.createStatement(); ResultSet rs = st.executeQuery("select * from issue_creating where Issue_ID='"+Issue_ID+"'");     
    if(rs.next()) {
        rs.getString("Problem_Submit");
        rs.getString("Problem_Submit"); 
        rs.getString("Problem_Descr"); 
    }
} 
catch(Exception e) {
   e.printStackTrace();
}

Upvotes: 1

Related Questions