Java访问数据库通用帮助类

public class DBHelper {  
      
    /** 
     * 获得connection 
     * @return 
     */  
    public Connection getConnection()  
    {  
        Connection c=null;  
        try {  
            Class.forName("com.mysql.jdbc.Driver");  
            c=DriverManager.getConnection("jdbc:mysql://localhost:3306/projectSelect","root","sa");  
        } catch (ClassNotFoundException e) {  
            e.printStackTrace();  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }  
        return c;  
    }  
      
    /** 
     * 关闭连接 
     * @param c 
     * @param s 
     * @param r 
     */  
    public void closeAll(Connection c,Statement s,ResultSet r)  
    {  
        if(r!=null){try {  
            r.close();  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }r=null;}  
        if(s!=null){try {  
            s.close();  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }s=null;}  
        if(c!=null){try {  
            c.close();  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }c=null;}  
    }  
      
    /** 
     * 增删改 
     * @param sql 
     * @return 
     */  
    public int excuteSql(String sql)  
    {  
        Connection c=null;  
        Statement s=null;  
        int num=-1;  
        try {  
            c=this.getConnection();  
            s=c.createStatement();  
            num=s.executeUpdate(sql);  
        } catch (Exception e) {  
            e.printStackTrace();  
        }finally  
        {  
            this.closeAll(c, s, null);  
        }  
        return num;  
    }  
}</