berry1020
发贴: 1
积分: 0
|
于 2008-03-11 13:45
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 6 in the generated java file Only a type can be imported. com.mysql.jdbc.Driver resolves to a package
An error occurred at line: 20 in the jsp file: /ADDE.jsp url cannot be resolved 17: String sql = ("INSERT INTO employee(employee_id, employee_name, hkid, gender, hphone, mphone, email, positions, salary) VALUES ('" + employee_ID + "','" + employee_name + "','" + hkid + "','"+ gender +"','"+ hphone +"','"+ mphone +"','"+ email +"','"+ positions +"','"+ salary +"') "); 18: 19: Class.forName("com.mysql.jdbc.Driver"); 20: Connection dbcon=DriverManager.getConnection(url,user,password); 21: Statement statement = dbcon.createStatement(); 22: ResultSet rs = statement.executeUpdate(sql); 23: rs.close();
An error occurred at line: 20 in the jsp file: /ADDE.jsp user cannot be resolved 17: String sql = ("INSERT INTO employee(employee_id, employee_name, hkid, gender, hphone, mphone, email, positions, salary) VALUES ('" + employee_ID + "','" + employee_name + "','" + hkid + "','"+ gender +"','"+ hphone +"','"+ mphone +"','"+ email +"','"+ positions +"','"+ salary +"') "); 18: 19: Class.forName("com.mysql.jdbc.Driver"); 20: Connection dbcon=DriverManager.getConnection(url,user,password); 21: Statement statement = dbcon.createStatement(); 22: ResultSet rs = statement.executeUpdate(sql); 23: rs.close();
An error occurred at line: 20 in the jsp file: /ADDE.jsp password cannot be resolved 17: String sql = ("INSERT INTO employee(employee_id, employee_name, hkid, gender, hphone, mphone, email, positions, salary) VALUES ('" + employee_ID + "','" + employee_name + "','" + hkid + "','"+ gender +"','"+ hphone +"','"+ mphone +"','"+ email +"','"+ positions +"','"+ salary +"') "); 18: 19: Class.forName("com.mysql.jdbc.Driver"); 20: Connection dbcon=DriverManager.getConnection(url,user,password); 21: Statement statement = dbcon.createStatement(); 22: ResultSet rs = statement.executeUpdate(sql); 23: rs.close();
An error occurred at line: 22 in the jsp file: /ADDE.jsp Type mismatch: cannot convert from int to ResultSet 19: Class.forName("com.mysql.jdbc.Driver"); 20: Connection dbcon=DriverManager.getConnection(url,user,password); 21: Statement statement = dbcon.createStatement(); 22: ResultSet rs = statement.executeUpdate(sql); 23: rs.close(); 24: statement.close(); 25: connection.close();
An error occurred at line: 25 in the jsp file: /ADDE.jsp connection cannot be resolved 22: ResultSet rs = statement.executeUpdate(sql); 23: rs.close(); 24: statement.close(); 25: connection.close(); 26: 27: %>
Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:93) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:435) org.apache.jasper.compiler.Compiler.compile(Compiler.java:298) org.apache.jasper.compiler.Compiler.compile(Compiler.java:277) org.apache.jasper.compiler.Compiler.compile(Compiler.java:265) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:564) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
明明照足來做也是這樣/W\ <%@ page contentType="text/html; charest=Big5"%> <%@ page language="java" %> <%@ page import="com.mysql.jdbc.Driver" %> <%@ page import="java.sql.*" %>
<% String employee_ID = request.getParameter("employee_ID"); String employee_name = request.getParameter("employee_name"); String hkid = request.getParameter("hkid"); String gender = request.getParameter("gender"); String hphone = request.getParameter("hphone"); String mphone = request.getParameter("mphone"); String email = request.getParameter("email"); String positions = request.getParameter("positions"); String salary = request.getParameter("salary");
String sql = ("INSERT INTO employee(employee_id, employee_name, hkid, gender, hphone, mphone, email, positions, salary) VALUES ('" +
employee_ID + "','" + employee_name + "','" + hkid + "','"+ gender +"','"+ hphone +"','"+ mphone +"','"+ email +"','"+ positions +"','"+ salary
+"') ");
Class.forName("com.mysql.jdbc.Driver"); Connection dbcon=DriverManager.getConnection(url,user,password); Statement statement = dbcon.createStatement(); ResultSet rs = statement.executeUpdate(sql); rs.close(); statement.close(); connection.close();
%>
不知道那裡出錯...幫幫忙
|