<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<% request.setCharacterEncoding("UTF-8"); %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
创建数据库
<%
//连接需要的对象
Connection conn = null;
Statement stmt = null;
String sql = null;
ResultSet rs = null;
int ret;
try
{
Class.forName("com.mysql.jdbc.Driver");//载入JDBC驱动程序
String strCon = "jdbc:mysql://localhost:3306";//连接字
conn = DriverManager.getConnection(strCon,"root","123456");//连接数据库
stmt = conn.createStatement();//初始化查询
sql = "create datebase JspSamples";//创建数据库
ret = stmt.executeUpdate(sql);//执行创建数据库
sql = "use JspSamples";//选择数据库
ret = stmt.executeUpdate(sql);//执行选择数据库
sql ="CREATE TABLE customers(" + //创建表
" Id int(6) unsigned NOT NULL auto_increment," +
" Name varchar(20) default NULL," +
" addTime timestamp NULL default NULL," +
" Tel varchar(15) default NULL," +
" Email varchar(20) default NULL," +
" PRIMARY KEY (Id)" +
")";
ret = stmt.executeUpdate(sql);//执行创建表
}
catch(ClassNotFoundException e)//意外处理,驱动程序无法找到
{
e.printStackTrace();
out.println("<h1>无法找到数据库驱动</h1>");
}
catch(SQLException e1)//意外处理,数据库操作失败
{
e1.printStackTrace();
out.println("<h1>数据库操作失败</h1>");
}
out.println("<h1>新建数据库JspSamples成功</h1>");
DatabaseMetaData meta = conn.getMetaData();
//获取数据库信息
out.println("<br>");
out.println("连接字:" + meta.getURL());//获取连接字
out.println("<br>");
out.println("数据库产品:" + meta.getDatabaseProductName());//获取数据库产品名
out.println("<br>");
out.println("数据库版本:" + meta.getDatabaseProductVersion());//获取数据库产品版本
out.println("<br>");
out.println("驱动程序:" + meta.getDriverName());//获取数据库驱动名
out.println("<br>");
out.println("驱动程序版本:" + meta.getDriverVersion());//获取数据库驱动版本
stmt.close();//关闭查询
conn.close();//关系连接
%>
</font>