您所在位置：主题：大家帮忙看下这段代码，哪里错了，jdbc连接sqlserver
272148444
[专家分：0] 发布于 2008-05-13 11:26:00
<%@ page language="java" contentType="text/html; charset=gb2312"
page-Encoding="gb2312"%>
<%@ page import = "java.sql.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>创建数据库</title>
</head>
<body>
<font size = 2>
<%
//连接需要的对象
Connection conn = null;
Statement stmt = null;
String sql = null;
int ret;
String userName = "sa";
String userPwd = "123";
try{
Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver");//载入jdbc驱动程序
String strCon = "jdbc:microsoft:sqlserver://localhost:1433;";//连接字
conn = DriverManager.getConnection(strCon,userName,userPwd);//连接数据库
stmt = conn.createStatement();//初始化查询
sql = "create 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) defaul NULL,"+
"PRIMARY KEY (ID) "+")"; //创建表
ret = stmt.executeUpdate(sql); //执行创建表
}catch(ClassNotFoundException ex){ //意外处理，驱动程序无法找到
ex.printStackTrace();
out.println("<h1>无法找到数据库驱动</h1>");
}catch(SQLException el){ //意外处理，数据库操作失败
el.printStackTrace();
out.println("<h1>数据库操作失败</h1>");
}
out.println("<h1>新建数据库JspSmles成功</h1>");
%>
</font>
</body>
</html>
page-Encoding="gb2312"%>
<%@ page import = "java.sql.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>创建数据库</title>
</head>
<body>
<font size = 2>
<%
//连接需要的对象
Connection conn = null;
Statement stmt = null;
String sql = null;
int ret;
String userName = "sa";
String userPwd = "123";
try{
Class.forName ("com.microsoft.jdbc.sqlserver.SQLServerDriver");//载入jdbc驱动程序
String strCon = "jdbc:microsoft:sqlserver://localhost:1433;";//连接字
conn = DriverManager.getConnection(strCon,userName,userPwd);//连接数据库
stmt = conn.createStatement();//初始化查询
sql = "create 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) defaul NULL,"+
"PRIMARY KEY (ID) "+")"; //创建表
ret = stmt.executeUpdate(sql); //执行创建表
}catch(ClassNotFoundException ex){ //意外处理，驱动程序无法找到
ex.printStackTrace();
out.println("<h1>无法找到数据库驱动</h1>");
}catch(SQLException el){ //意外处理，数据库操作失败
el.printStackTrace();
out.println("<h1>数据库操作失败</h1>");
}
out.println("<h1>新建数据库JspSmles成功</h1>");
%>
</font>
</body>
</html>
