0077900f1c76001c1ea294e4bfe5d64c

来自「我们做的J2EE课程设计实验,使用JSF语言编写一个简易的订单系统,麻雀虽小五脏」· 代码 · 共 46 行

import java.sql.*;


class Test{
     public static void main(String args[])
     {  
         String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=TESTDB";
         String user ="Zacks";//默认是sa，这里替换成你自已的数据库用户名
         String password = "bigtwo";//默认为空，这里替换成你自已的数据库用户密码
         String sqlStr = "select * from test_student";

         try{     //这里的异常处理语句是必需的.否则不能通过编译!    
             Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
             System.out.println( "类实例化成功!" );
             System.out.println("slkdjf");
             Connection con = DriverManager.getConnection(RL,user,password);
             System.out.println( "创建连接对像成功!" );

             Statement st = con.createStatement();
             System.out.println( "创建Statement成功!" );

             ResultSet rs = st.executeQuery( sqlStr );
             System.out.println( "操作数据表成功!" );
             System.out.println( "----------------!" );

             while(rs.next())
             {
                 System.out.print(rs.getString("Sno") + "     ");
                 System.out.print(rs.getString("Sname") + "     ");
                 System.out.print(rs.getString("Sage") + "     ");
                 System.out.print(rs.getString("Ssex") + "     ");
                 System.out.println(rs.getString("Sclass"));
             }
             rs.close();
             st.close();
             con.close();
         }
         catch(Exception err){
             err.printStackTrace(System.out);
         }
     }
}