jdbc我得到的错误是:java。sql。SQLSyntaxErrorException:您的SQL语法有错误;我怎样才能克服这个问题
我只是想开发一个简单的web应用程序,我们可以在其中编写注释,如下图所示:
当我在添加注释中添加任何文本,并单击按钮“添加注释”提交时,它不会存储在数据库中
*我已经创建了一个数据库名“Enote”和表名=“post”,如下所示:
Sql查询是
以下是jsp的代码:
添加注释。jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Add Notes</title>
<%@include file="all_component/allcss.jsp" %>
</head>
<body>
<div class="container-fluid">
<%@include file="all_component/navbar.jsp" %>
<h1 class="text-center">Add Your Notes</h1>
<div class="container">
<div class="row">
<div class="col-md-12">
<form action="AddNotesServlet" method="post">
<div class="form-group">
<%
UserDetails us=(UserDetails)session.getAttribute("userD");
%>
<input type="hidden" value="<%=us.getId()%>" name="uid">
<label for="exampleInputEmail1">Enter Title</label>
<input type="text" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" name="title" required="required">
</div>
<div class="form-group">
<label for="exampleInputEmail1">Enter Content</label>
<textarea rows="9" cols="" class="form-control" name="content" required="required"></textarea>
</div>
<div class="container text-center">
<button type="submit" class="btn btn-primary">Add Notes</button>
</div>
</form>
</div>
</div>
</div>
</div>
</body>
</html>
发帖。java
package com.User;
import java.util.Date;
public class Post
{
private int id;
private String title;
private String content;
private Date pdate;
private UserDetails user;
public Post(int id, String title, String content, Date pdate, UserDetails user) {
super();
this.id = id;
this.title = title;
this.content = content;
this.pdate = pdate;
this.user = user;
}
public Post() {
super();
// TODO Auto-generated constructor stub
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
public Date getPdate() {
return pdate;
}
public void setPdate(Date pdate) {
this.pdate = pdate;
}
public UserDetails getUser() {
return user;
}
public void setUser(UserDetails user) {
this.user = user;
}
}
PostDAO。java
package com.DAO;
import java.sql.Connection;
import java.sql.PreparedStatement;
public class PostDAO
{
private Connection con;
public PostDAO(Connection con) {
super();
this.con = con;
}
public boolean AddNotes(String ti, String co,int ui)
{
boolean f=false;
try
{
String qu="insert into post(title,content,uid) values=(?,?,?)";
PreparedStatement ps=con.prepareStatement(qu);
ps.setString(1, ti);
ps.setString(2, co);
ps.setInt(3, ui);
int i=ps.executeUpdate();
if(i==1)
{
f=true;
}
}
catch(Exception e)
{
e.printStackTrace();
}
return f;
}
}
添加Notesservlet。java
package com.Servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.DAO.PostDAO;
import com.DB.DBConnect;
@WebServlet("/AddNotesServlet")
public class AddNotesServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
int uid=Integer.parseInt(request.getParameter("uid"));
String title=request.getParameter("title");
String content=request.getParameter("content");
PostDAO dao =new PostDAO(DBConnect.getConn());
boolean f= dao.AddNotes(title, content, uid);
if (f)
{
System.out.println("data insert successfully");
}
else
{
System.out.println("data not inserted");
}
}
}
以下是我执行代码时的错误,该代码在控制台中给出了未插入数据的输出:
共 (0) 个答案