Hi all, I can't solve the problem in Lesson14.java.Hope to get some help here.
Error message --------------------- cannot resolve symbol -basically,the errors are about the classes(DriverManager,ResultSet,PreparedStatement,Connection...) I hope u guys can help me solve these bugs Lesson14.java --------------------- package rayexamples; import java.sql.*; import java.io.Serializable; public class Lesson14 extends Object implements Serializable { public Lesson14() {} private String deptId ; private String deptName ; private String deptEmpId ; /* THE SETTER METHOD FOR deptId - This is the key column, & it identifies the dept.*/ public void setDeptId(String deptId) { this.deptId = deptId ; } /* THE SETTER METHOD FOR deptName. This is the name of the dept (accounting, etc.) */ public void setDeptName(String deptName) { this.deptName = deptName; } /* THE SETTER METHOD FOR deptEmpId. This the employee ID of the department's manager.*/ public void setDeptEmpId(String deptEmpId) { this.deptEmpId = deptEmpId ; } /* = = = = = = = = = > INSERT DEPTARTMENT < = = = = = = = = = */ public String insertDept () { Connection sqlca = null; String lesson14_output = ""; PreparedStatement lesson14_stmt= null; ResultSet lesson14_data= null; int myDeptId = 0; int myDeptEmpId = 0; /* = = = = = = = = = > CONNECT < = = = = = = = = = */ try { /* Connection to the database */ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String lesson14_database = "jdbc:odbc:lesson14_database"; String usr="E-BookMall Admin"; String pwd="peilengdh00677833811"; sqlca = DriverManager.getConnection(lesson14_database,usr,pwd); } catch (Exception e) { lesson14_output = "<br>Connection Error #1: JDBC Class creation: " + e.getMessage()+"<br><br>"; } /* = = = = = = = = = > INSERT < = = = = = = = = = */ /* Convert deptId from a string to an integer. */ try { myDeptId = Integer.parseInt(deptId.trim()); } catch (NumberFormatException e) { lesson14_output = " <br>Convert Error #1 Number Format Exception: " + e.getMessage(); } catch (NullPointerException e) { lesson14_output = " <br>Convert Error #2: NullPointerException: " + e.getMessage(); } /* Convert deptEmpId from a string to an integer. */ try { myDeptEmpId = Integer.parseInt(deptEmpId.trim()); } catch (NumberFormatException e) { lesson14_output = " <br>Convert Error #3 Number Format Exception: " + e.getMessage(); } catch (NullPointerException e) { lesson14_output = " <br>Convert Error #4: NullPointerException: " + e.getMessage(); } /* Create and execute the insert statement. */ try { lesson14_stmt = sqlca.createStatement() ; } catch (Exception e) { lesson14_output = " <br>Insert Error #1: SQL error of: " + e.getMessage(); } try { int rowsAffected = lesson14_stmt.executeUpdate( "insert into department " + "(dept_id, dept_name, dept_head_id) " + "values (" + myDeptId + ", '" + deptName + "', " + myDeptEmpId + " )"); if ( rowsAffected == 1 ) { lesson14_output = "Department WAS added.<br><br>";} else { lesson14_output = "Department WAS NOT added.<br><br>";} } catch (Exception e) { lesson14_output += "<br>Department was not added." + "<br><br>Insert Error #2: SQL error of: " + e.getMessage(); } /* = = = = = = = = = > DISPLAY DEPARTMENT < = = = = = = = = = */ try { /* Build & execute the sql, positioning before the first row in the result set */ lesson14_stmt = sqlca.createStatement(); lesson14_data = lesson14_stmt.executeQuery( "select " + "dept_id, " + "dept_head_id, " + "dept_name " + "from department " + "where dept_id = " + myDeptId ); /* Construct the heading for the table */ lesson14_output += "<br><br><table border=1 align=center width=75%>" + "<caption><i><b>The Current State Of Department " + this.deptId + "</b></i></caption>" ; /* "<caption><i><b>The Current State Of Department </b></i></caption>" ; */ /* Construct the column headings for the table */ lesson14_output += "<i><b><th align=left>Dept ID</th>" + "<th>Dept Name</th>" + "<th>Dept Manager</th></b></i>" ; /* Move to the first (and only) row and & add its contents to the html output */ lesson14_data.next() ; { lesson14_output += "<TR><TD>" + lesson14_data.getObject("dept_id").toString() + "</TD><TD>" + lesson14_data.getObject("dept_name").toString()+"</TD><TD>" + lesson14_data.getObject("dept_head_id").toString() + "</TD></TR>" ; } lesson14_stmt.close(); } catch (Exception e) { lesson14_output += " <br>Display Error #1: SQL error of: " + e.getMessage() ; } catch (Exception e) { lesson14_output += " <br>Display Error #2: JDBC Class creation: " + e.getMessage(); } lesson14_output += "</table><br><br>" ; /* = = = = = = = = = DISCONNECT = = = = = = = = = */ try { sqlca.close(); } catch (Exception e) { lesson14_output = "<br>Disconnect Error #1: SQL error of: " + e.getMessage(); } /* Complete the html and return it to the Java Server Page */ return lesson14_output; } }