tomcat 7 连接mysql_tomcat7 windows 7系统 mysql 5.5 用JDBC连接mysql写入数据库数据时报错...

最新推荐文章于 2021-04-01 14:13:01 发布

Lekecui

最新推荐文章于 2021-04-01 14:13:01 发布

阅读量70

点赞数

文章标签： tomcat 7 连接mysql

本文链接：https://blog.csdn.net/weixin_30428981/article/details/113188408

版权

HTTPStatus500-typeExceptionreportmessagedescriptionTheserverencounteredaninternalerror用jsp建立数据库时报这个错误。但是自己手动建立数据库，是可以在网页读取出来的。代码如下...

HTTP Status 500 - type Exception report message description The server encountered an internal error

用jsp建立数据库时报这个错误。但是自己手动建立数据库，是可以在网页读取出来的。代码如下package org.sunxin.lesson.jsp.bookstore;

import javax.servlet.*;

import java.io.*;

import javax.servlet.http.*;

import java.sql.*;

public class CreateDBServlet extends HttpServlet

{

private String url;

private String user;

private String password;

public void init() throws ServletException

{

String driverClass=getInitParameter("driverClass");

url=getInitParameter("url");

user=getInitParameter("user");

password=getInitParameter("password");

try

{

Class.forName(driverClass);

}

catch(ClassNotFoundException ce)

{

throw new UnavailableException("加载数据库驱动失败！");

}

public void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException,IOException

{

Connection conn=null;

Statement stmt=null;

try

{

conn=DriverManager.getConnection(url,user,password);

stmt=conn.createStatement();

stmt.executeUpdate("create database bookstore");

stmt.executeUpdate("use bookstore");

stmt.executeUpdate("create table bookinfo(id INT not null primary key,title VARCHAR(50) not null,author VARCHAR(50) not null,bookconcern VARCHAR(100) not null,publish_date DATE not null,price FLOAT(4,2) not null,amount SMALLINT,remark VARCHAR(200)) ENGINE=InnoDB");

stmt.addBatch("insert into bookinfo values(1,'Java从入门到精通','张三','张三出版社','2004-6-1',34.00,35,null)");

stmt.addBatch("insert into bookinfo values(2,'JSP深入编程','李四','李四出版社','2004-10-1',56.00,20,null)");

stmt.addBatch("insert into bookinfo values(3,'J2EE高级编程','王五','王五出版社','2005-3-1',78.00,10,null)");

stmt.executeBatch();

PrintWriter out=resp.getWriter();

out.println("success!");

out.close();

}

catch(SQLException se)

{

se.printStackTrace();

}