为什么我用eclipse连接不了SQL数据库?而且有驱动,就是感觉主机地址不知道怎么设置,请帮帮我!
下面是简单的JAVA代码:
package SQL;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;//import ;public class TestSql { public static void main(String[] args) throws ClassNotFoundException, SQLException {
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xuxin";
String user="sa";
String pass="sa";
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,pass);
String sql="select * from userinfo";
PreparedStatement pstt = conn.prepareStatement(sql);
ResultSet rs = pstt.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+"\t"+rs.getString(2));
}
conn.close();
}}
下面是简单的JAVA代码:
package SQL;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;//import ;public class TestSql { public static void main(String[] args) throws ClassNotFoundException, SQLException {
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xuxin";
String user="sa";
String pass="sa";
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,pass);
String sql="select * from userinfo";
PreparedStatement pstt = conn.prepareStatement(sql);
ResultSet rs = pstt.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+"\t"+rs.getString(2));
}
conn.close();
}}
解决方案 »
- 从表单读取数据写入数据库的问题
- 一个网站,希望大家发表点看法
- 求助!急!使用fileUpload组件上传文件,.parseRequest()返回却为0
- Struts多模块问题?急!!!!!
- 怎么防止多个用户在同一个页面上对同一条记录修改?
- 如何在struts中实现页面打印控制
- Struts2注解式开发,怎么让Spring管理action的创建
- servlet的简单问题!(急!在线等)
- 本人刚开始学习java,请问大虾如何在jbuilder7.0下把已写好的.java文件,编译成.class文件?
- 有没有Applet和Servlet通信的例子
- 有谁知道象 www.51.la 访问统计的原理?
- javabean + jsp 开发平台的问题?
不过,头部引入
import java.sql.*;
你再试一下
Exception in thread "main" java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at SQL.TestSql1.main(TestSql1.java:17)
正在连接到127.0.0.1...不能打开到主机的连接, 在端口 1433: 连接失败但是我装了P4的补丁呀``是不是SQL版本过时了?
回复``谢谢!!!