Java EE WEB工程师培训-JDBC+Servlet+JSP整合开发之01.JDBC简介

package com.michael.jdbc;    

import java.sql.Connection;    
import java.sql.DriverManager;    
import java.sql.ResultSet;    
import java.sql.SQLException;    
import java.sql.Statement;    

public  class Tester {    

         /**    
         * @param args    
         */    
         public  static  void main(String[] args) {    
                query();    

        }    
         public  static  void query(){    
                Connection conn =  null;    
                 try {    
                        Class.forName( "com.mysql.jdbc.Driver");    
                        conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/jdbc_db", "root", "mysqladmin");    
                        String sql = "select * from UserTbl";    
                        Statement stmt = conn.createStatement();    
                        ResultSet rs = stmt.executeQuery(sql);    
                        while(rs.next()){    
                                int id = rs.getInt(1);    
                                String username = rs.getString(2);    
                                String password = rs.getString(3);    
                                int age = rs.getInt(4);    
                                System.out.println(id+":"+username+":"+password+":"+age);    
                        }    
                } catch (Exception e) {    
                        // TODO Auto-generated catch block    
                        e.printStackTrace();    
                }finally{    
                        if(conn!=null){    
                                try {    
                                        conn.close();    
                                } catch (SQLException e) {    
                                        conn = null;    
                                        e.printStackTrace();    
                                }    
                        }    
                }    
        }    

}