java servlet 数据库_java servlet 连接数据库

最新推荐文章于 2023-04-12 18:11:53 发布

灵之翼

最新推荐文章于 2023-04-12 18:11:53 发布

阅读量94

点赞数

文章标签： java servlet 数据库

本文链接：https://blog.csdn.net/weixin_28703507/article/details/114433145

版权

该博客展示了如何在Java Servlet环境中初始化数据库连接，创建并填充`bookstore`数据库，包括`bookinfo`表。博客强调了配置Servlet初始化参数、加载JDBC驱动、执行SQL语句等关键步骤。

摘要由CSDN通过智能技术生成

import java.io.*;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import javax.servlet.*;

import javax.servlet.http.*;

public class CreatDBServlet extends HttpServlet{

private String url,user,password;

@Override

public void init() throws ServletException {

// TODO Auto-generated method stub

String driverClass = this.getInitParameter("driverClass");

url = this.getInitParameter("url");

user = this.getInitParameter("user");

password = this.getInitParameter("password");

try

{

Class.forName(driverClass);

}

catch (ClassNotFoundException ce)

{

throw new ServletException(driverClass+"数据库加载失败");

}

protected void doGet(HttpServletRequest req, HttpServletResponse resp)

throws ServletException, IOException {

// TODO Auto-generated method stub

//super.doGet(req, resp);

Connection conn=null;

Statement stmt=null;

try

{

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

stmt=conn.createStatement();

stmt.executeUpdate("drop database if exists bookstore");

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 web 开发','author','.....','2006-4-20',99.00,35,null)");

stmt.executeBatch();

resp.setContentType("text/html;charset=gbk");

PrintWriter out=resp.getWriter();

out.println("success,创建数据库成功");

out.close();

}

catch (SQLException se)

{

throw new ServletException(se);

}

finally