数据库用SQLServer2000student表在jz数据库中。第一列的属性是student_ID,为char型eclipse调试结果如下:驱动程序以加载以连接数据库null代码如下:importjava.sql.*;importjava.io....
数据库用SQLServer 2000
student表在jz数据库中。第一列的属性是student_ID,为char型
eclipse调试结果如下:
驱动程序以加载
以连接数据库
null
代码如下:
import java.sql.*;
import java.io.*;
import java.util.*;
public class Test
{
public static void main(String[] args)
{
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jz";
Connection con = null;
String command = null;
Statement stmt = null;
ResultSet rs =null;
try
{
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
System.out.println("驱动程序以加载");
con = DriverManager.getConnection(url,"sa","");
System.out.println("以连接数据库");
command = "select * from student";
rs = stmt.executeQuery(command);
while(rs.next())
{
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
con.close();
}
catch(Exception ex)
{
System.out.println(ex.getMessage());
return;
}
}
}
展开