JSP連結資料庫問題 @ 百科全書

標題:

JSP連結資料庫問題

發問:

在上個網頁我有傳表單至這個網頁 name=passwd 我需要將passwd更新在表格account下欄位為account 以下是我的JSP我資料庫為account 欄位有 account passwd name student為何無法執行有錯誤<%@ page contentType="text/html; charset=Big5" import="java.sql.*"%> 寫入資料庫

<% request.setCharacterEncoding("big5"); String passwd = request.getParameter("passwd"); Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/projectgis?useUnicode=true&characterEncoding=big5","root", ""); String sql="update account set passwd="+passwd+" where account= xml"; PreparedStatement pstmt=conn.prepareStatement(sql); pstmt.execute(); pstmt.close(); %> 該如何修改才能更新我要的值還有update 與 inset serlect該如何表示 exception org.apache.jasper.JasperException: An exception occurred processing JSP page /correct_w.jsp at line 24 root cause javax.servlet.ServletException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'xml' in 'where clause' org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781) org.apache.jsp.correct_005fw_jsp._jspService(correct_005fw_jsp.java:93) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'xml' in 'where clause'

最佳解答:

這邊就表示出錯誤了! javax.servlet.ServletException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'xml' in 'where clause' 看一下下列一段程式碼有問題, String sql="update account set passwd="+passwd+"where account= xml"; 改成以下試看看吧. String sql="update account set passwd="+passwd+" where account= 'xml' "; 或: String sql="update account set passwd='"+passwd+"' where account= 'xml' ";

其他解答: