index.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page language="java" import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head> <title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
This is my JSP page. <br><%
Connection con=null;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft.sqlserver://127.0.0.1:1433;Database=test","sa","sql");
//在数据库中创建表;
out.println(con.toString());
int createTable=-1;
String strCreateTable="create table books(book_id int,book_name varchar(50),price float,quantity int)";
Statement stmtCreate=con.createStatement();
createTable=stmtCreate.executeUpdate(strCreateTable);
stmtCreate.close();
if(createTable==0)
{
out.println("创建表成功<br>");
}
else
{
out.println("创建失败");
}
%>
大家好啊。。
</body>
</html>
错误提示:2010-1-19 17:50:01 org.apache.catalina.startup.Catalina stopServer
严重: Catalina.stop:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:395)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:337)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:415)
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page language="java" import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head> <title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
This is my JSP page. <br><%
Connection con=null;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft.sqlserver://127.0.0.1:1433;Database=test","sa","sql");
//在数据库中创建表;
out.println(con.toString());
int createTable=-1;
String strCreateTable="create table books(book_id int,book_name varchar(50),price float,quantity int)";
Statement stmtCreate=con.createStatement();
createTable=stmtCreate.executeUpdate(strCreateTable);
stmtCreate.close();
if(createTable==0)
{
out.println("创建表成功<br>");
}
else
{
out.println("创建失败");
}
%>
大家好啊。。
</body>
</html>
错误提示:2010-1-19 17:50:01 org.apache.catalina.startup.Catalina stopServer
严重: Catalina.stop:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:395)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:337)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:415)
解决方案 »
- JavaScript代码在IE中出错,在其他浏览器能用 急......
- 再线等小问题,请帮忙
- 大家做论坛有碰到这个问题嘛?
- 这个错误,为什么啊?
- 紧急求助(给条路走):如何实现这样的数组表示形式:数组名->参数????
- 新手求教ava.lang.NoClassDefFoundError的问题
- 关于用JavaMail来发邮件.......在线等
- 关于一个登陆的问题
- 新手求助jsp 关于数据库的问题
- com.github.tobato.fastdfs.exception.FdfsServerException: 错误码:2,错误信息:找不到节点或文件
- Spring2.0申明事务或配置一个切面的时候总是抛出入下的异常,请大家帮忙看下!
- JSP 嵌入播放器无法播放AVI问题
--------------------------------------
con=DriverManager.getConnection("jdbc:microsoft.sqlserver://127.0.0.1:1433;DatabaseName=test","sa","sql");
确保你的SqlServer服务启动,并且SqlServer打了补丁
jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test","sa","sql"sql 2000才是jdbc:microsoft.sqlserver://127.0.0.1:1433;DatabaseName=test","sa","sql"
呵呵。再次谢谢各位。