先引入对应的驱动包,sqlServer对应的是sqljdbc4.jar,文件名可以随便改,java需要的只是jar包中的某些文件
java代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
//JDBC,sun提供的接口,所以都是java.sql包中的
public class TestJDBC {
public static void main(String[] args) {
try {
//若更换的数据库,只需要修改driverName、url,注释起来的是oracle连接方式
//String driverName ="oracle.jdbc.driver.OracleDriver";
//String url = "jdbc:oracle:thin:@localhost:1521:haitun";
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433; DatabaseName=haitun";
Class.forName(driverName);
Connection con =DriverManager.getConnection(url, "sa", "sqlserver");
ResultSet rs =con.createStatement().executeQuery("select * from student");
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
} catch (Exception e) {
e.printStackTrace();
}
}
}