java中servlet源码下载_createdbservlet.java 源代码在线查看 - Java Web开发详解.书中例子的源代码(JSPlesson) 资源下载 虫虫电子下载站...

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(); } finally { if(stmt!=null) { try { stmt.close(); } catch(SQLException se) { se.printStackTrace(); } stmt=null; } if(conn!=null) { try { conn.close(); } catch(SQLException se) { se.printStackTrace(); } conn=null; } } }}