Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=admin;DatabaseName=self");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from image";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
imageName=rs.getString("id");
System.out.println("TestName:"+rs.getString("image_text"));
还要下SQL Server 2000的JDBC的驱动.设好路径就行了.
给分吧!!
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=admin;DatabaseName=self");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql="select * from image";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
imageName=rs.getString("id");
System.out.println("TestName:"+rs.getString("image_text"));
还要下SQL Server 2000的JDBC的驱动.设好路径就行了.
给分吧!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货