Java开发网 - MYSQL问题

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate

打印话题 寄给朋友 订阅主题

作者

MYSQL问题

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();

%>

不知道那裡出錯...幫幫忙

作者

Re:MYSQL问题 [Re:berry1020]

Happy漫步者

发贴: 28
积分: 5

于 2008-03-17 10:17

出現cannot be resolved一般是沒有定義或重複定義
statement.executeUpdate(sql);返回的是更新的數量是int類型
而你的是ResultSet不能得到轉換的也不能得到值
---------------JDK1.5 DOC-------
int executeUpdate(String sql, int autoGeneratedKeys)
執行給定的SQL語句，並用給定標誌通知驅動程序由此Statement生成的自動生成鍵是否可用於檢索。
*******
出现 cannot be resolved 一般是没有定义或重复定义
statement.executeUpdate(sql);返回的是更新的数量是 int类型
而你的是ResultSet 不能得到转换的也不能得到值
---------------JDK1.5 DOC-------
int executeUpdate(String sql, int autoGeneratedKeys)
执行给定的 SQL 语句，并用给定标志通知驱动程序由此 Statement 生成的自动生成键是否可用于检索。

Happy漫步者花园当我们失去的时候,才知道自己曾经拥有过

已读帖子

新的帖子

被删除的帖子