为啥连不起啊,sqlserver 2000打了sp4的补丁 也导入了那3个jar包
可是还是连不起 怎么回事啊?代码如下
我用jdbc-odbc桥连就可以!
public class test2 {
public static void main(String[] args) { PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
try {
//1.加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2.获取连接
ct=DriverManager.getConnection
("jdbc:microsoft:sqlserver://127.0.0.1:1433; DatabaseName=mysql","sa","sql");
//3.创建火箭车
ps=ct.prepareStatement("select * from stu");
rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}finally{
try {
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(ct!=null){
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
可是还是连不起 怎么回事啊?代码如下
我用jdbc-odbc桥连就可以!
public class test2 {
public static void main(String[] args) { PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
try {
//1.加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2.获取连接
ct=DriverManager.getConnection
("jdbc:microsoft:sqlserver://127.0.0.1:1433; DatabaseName=mysql","sa","sql");
//3.创建火箭车
ps=ct.prepareStatement("select * from stu");
rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}finally{
try {
if(rs!=null){
rs.close();
}
if(ps!=null){
ps.close();
}
if(ct!=null){
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
ps=ct.prepareStatement("select * from stu");
---语法是不是这样我不是很清楚。
ct.open();rs=ps.executeQuery();