UC知道JSP数据库连接时候出现org.apache.jasper.JasperException: Unable to compile class for JSP:
来源：百度知道 编辑：UC知道 时间：2024/05/27 08:59:59
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*" errorPage="errorpage.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改数据</title>
</head>
<body>
<%
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String age=request.getParameter("age");
String diploma=request.getParameter("diploma");
String tel=request.getParameter("tel");
Connection con=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/Tomcat 6.0/webapps/usersmanage/userM.mdb;");
Statement stmt=con.createStatement();
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改数据</title>
</head>
<body>
<%
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String age=request.getParameter("age");
String diploma=request.getParameter("diploma");
String tel=request.getParameter("tel");
Connection con=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/Tomcat 6.0/webapps/usersmanage/userM.mdb;");
Statement stmt=con.createStatement();
//sql没定义，id也没定义和初始化
sql="update user set
//这里不能换行。。换行请用字符串相加操作
name='"+name+"',sex='"+sex+"',age='"+age+"',diploma='"+diploma+"',tel='"+tel+"' where id='"+id+"'";
stmt.executeUpdate(sql);