querysample.java

来自「因此本系统的目标就是让顾客方便快捷和满意的购物。为了达到这一目标」· Java 代码 · 共 25 行

import java.sql.*;
class QuerySample{
   public static void main(String args[])
{
     try{
      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url = "jdbc:sqlserver://localhost;databaseName=Student";
Connection conn = DriverMananger.getConnection(url, "MyUserName", "MyPWD");
        Statement stmt = conn.createStatment();        
       ResultSet rs = stmt.executeQuery("SELECT Sno,Sname,Sage,Sadd FROM Student");
while (rs.next()) 
{ 
String sno = rs.getString(1); //取得数据集rs当前行中第一列（即Sno）的属性//值，并将该值转化成String类型
String sname = rs.getString(2); 
int sage = r.getInt(3); 
String sadd = r.getString(4);
System.out.println("学号："+sno+"姓名："+sname+"年龄："+sage+"地址："+sadd);
}
        conn.close();
}catch(SQLException e){
   e.printStack();
}
}
}