这是代码
package databasetest;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DataBaseTest { public static void main(String[] args) {
PreparedStatement ps = null;
Connection ct = null;
ResultSet rs = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver ");
ct = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1032;databaseName=jwglxt", "sa", "12345678910");
ps = ct.prepareStatement("select * from Student");
rs = ps.executeQuery();
while (rs.next()) {
String name = rs.getString(1);
System.out.print("" + name + "\t");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}是不是在NetBeans中还得引入sqljdbc.jar这个包呢?请介绍详细一些
谢谢!
package databasetest;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DataBaseTest { public static void main(String[] args) {
PreparedStatement ps = null;
Connection ct = null;
ResultSet rs = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver ");
ct = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1032;databaseName=jwglxt", "sa", "12345678910");
ps = ct.prepareStatement("select * from Student");
rs = ps.executeQuery();
while (rs.next()) {
String name = rs.getString(1);
System.out.print("" + name + "\t");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}是不是在NetBeans中还得引入sqljdbc.jar这个包呢?请介绍详细一些
谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货