相对完善的Java通过JDBC操纵mysql的例子

工具类:

 

 1import java.sql.Connection;
 2import java.sql.DriverManager;
 3import java.sql.ResultSet;
 4import java.sql.SQLException;
 5import java.sql.Statement;
 6
 7
 8public final class JDBCUtils {
 9
    private JDBCUtils(){}
    
    private static String url="jdbc:mysql://localhost:3306/forum";
    private static String user="root";
    private static String password="root";
    
    static{
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            throw new ExceptionInInitializerError(e);
        }
    }
    
    public static Connection getConnection() throws SQLException
    {
        return DriverManager.getConnection(url, user, password);        
    }
    
    public static void free(ResultSet rs,Statement st,Connection conn)
    {
        try{
            
            if(rs!=null)
                rs.close();
        }catch(SQLException e){
            e.printStackTrace();
        }finally{
            
                        try{
                            if(st!=null)
                                st.close();
                        }catch(SQLException e){
                            e.printStackTrace();
                        }finally{
                            
                                        try{
                                            if(conn!=null)
                                                conn.close();
                                        }catch(SQLException e){
                                            e.printStackTrace();
                                        }        
                        }
        }
    }
}

使用的例子:

 

 1public static void main(String[] args) {
 2        // TODO Auto-generated method stub
 3        try {
 4            JDBCUtilsTest();
 5        } catch (Exception e) {
 6            // TODO Auto-generated catch block
 7            e.printStackTrace();
 8        }
 9
    }
    
    
    public static void JDBCUtilsTest() throws Exception
    {
        Connection conn=null;
        Statement st=null;
        ResultSet rs=null;
        
        try{
            conn=JDBCUtils.getConnection();
            st=conn.createStatement();
            rs=st.executeQuery("select * from user");
            while(rs.next())
            {
                System.out.println(rs.getObject(1)+"\t"+rs.getObject(2));
            }
        }finally{
            JDBCUtils.free(rs, st, conn);
        }    
        
    }