在使用MySQL连接eclipse中出现错误
//servelet
package com.demo;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.annotation.WebServlet;
@WebServlet("/add-book")
public class BookServlet extends HttpServlet {
Connection dbconn =null;
public void init() {
String driver = "com.mysql.jdbc.Driver";
String dburl = "jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC";
String username = "root";
String password = "123456";
try {
//加载想要链接的数据库驱动到JVM
Class.forName(driver);
//获得connecttion对象，该对象代表一个数据库连接
dbconn = DriverManager.getConnection(dburl,username,password);
}catch(ClassNotFoundException e1) {
System.out.println(e1);
getServletContext().log("驱动程序找不到");
}catch(SQLException e2) {
System.out.println(e2);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String isbn = request.getParameter("isbn");
String title = request.getParameter("title");
float price = Float.parseFloat(request.getParameter("price"));
String message="";
try {
String sql="INSERT INTO books VALUERS(?,?,?)";
PreparedStatement pstmt = dbconn.prepareStatement(sql);
pstmt.setNString(1,isbn);
pstmt.setString(2,title);
pstmt.setFloat(3,price);
int num = pstmt.executeUpdate();
if(num==1) {
message ="插入成功!";
}else {
message = "插入失败!";
}
request.setAttribute("message", message);
request.getRequestDispatcher("add-book.jsp").forward(request, response);
} catch (SQLException e) {
message = e.getMessage();
request.setAttribute("message", message);
request.getRequestDispatcher("add-book.jsp").forward(request, response);
}
}
}
//表单
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
Insert title here
请输入图书信息
${message}
书名:
价格:
报错图片
