代码如下:(说是有些字符不支持)
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>创建数据库</title>
<body><font size=2>
<%
//连接需要的对象
Connection conn=null;
Statement stmt=null;
String sql=null;
ResultSet rs=null;
int ret;
try{
Class.forName("com.mysql.jdbc.Driver");
String strCon="jdbc:mysql:localhost:3306/";
conn=Drivermanager.getConnection(strCon,"root","xy102310");
stmt=conn.createStatement();
sql="creat database 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.getDatabaseProductName());
out.println("<br>");
out.println("连接字:"+meta.getURL());
stmt.close();
conn.close();
%>
</font>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>创建数据库</title>
<body><font size=2>
<%
//连接需要的对象
Connection conn=null;
Statement stmt=null;
String sql=null;
ResultSet rs=null;
int ret;
try{
Class.forName("com.mysql.jdbc.Driver");
String strCon="jdbc:mysql:localhost:3306/";
conn=Drivermanager.getConnection(strCon,"root","xy102310");
stmt=conn.createStatement();
sql="creat database 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.getDatabaseProductName());
out.println("<br>");
out.println("连接字:"+meta.getURL());
stmt.close();
conn.close();
%>
</font>
</body>
</html>
解决方案 »
- 求助!上传图片图片大小转换异常!Found class com.sun.image.codec.jpeg.JPEGImageEncoder, but inter
- 在代码中如何获取hibernate的SQL语句
- 还是spring2.0 WEB整合问题
- Hibernate 异常
- 关于webwork入门的问题(100分)
- 急,在线等待,解决问题马上结帖!jb建立标签问题!
- JEJ
- help me 需要多少分。 低级问题
- 各位大侠,请问用SQL SERVER2000数据库,在JSP中用String tmp=rs.getString("link1");,用的是Jrun服务器,老是出错,为什么?
- websphere下的servlet配置问题,急!
- 为什么我编写的html文件在IE浏览器中打开正常,在FireFox浏览器中打开排版就乱了?
- JSP中如何在每个页面判断用户是否已正常登陆的,不是直接根据URL访问页面的?就像ASP.NET中的User.Identity.IsAuthenticated功能一样功能.
<%@ page language= "java " contentType= "text/html; charset=ISO-8859-1 "
pageEncoding= "ISO-8859-1 "%> 把ISO-8859-1改为GBK就可以了。
<meta http-equiv= "Content-Type " content= "text/html; charset=ISO-8859-1 ">
pageEncoding= "ISO-8859-1”
,不知为什么?希望前辈们能够给于解决
pageEncoding="GBK"%>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>创建数据库</title>
<body><font size=2>
<%
//连接需要的对象
Connection conn=null;
Statement stmt=null;
String sql=null;
ResultSet rs=null;
int ret;
try{
Class.forName("com.mysql.jdbc.Driver");
String strCon="jdbc:mysql:localhost:3306/";
conn=Drivermanager.getConnection(strCon,"root","xy102310");
stmt=conn.createStatement();
sql="creat database 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.getDatabaseProductName());
out.println("<br>");
out.println("连接字:"+meta.getURL());
stmt.close();
conn.close();
%>
</font>
</body>
</html>
应该没有错吧
把页面编码ISO-8859-1改为utf-8,如果还不行,不要给我分