jdbc实例

import java.sql.*;  
class Testj{  
     public static void main(String args[])  
     {    
         String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=TESTDB";  
         String user ="jack";//这里替换成你自已的数据库用户名  
         String password = "jack";//这里替换成你自已的数据库用户密码  
         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.getInt("Sno") + "     ");  
                 System.out.print(rs.getString("Sname") + "     ");  
                 System.out.print(rs.getInt("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);  
         }  
     }  
} 

 

http://developer.51cto.com/art/200907/136555.htm