java连接mysql数据库

import  java.sql. * ;
public   class   connMysql
... {
    Connection conn=null;
    Statement stmt=null;
    ResultSet rs=null;
    String url="jdbc:mysql://localhost:3306/webteam?useUnicode=true&characterEncoding=8859_1";
    String dbName="root";
    String dbPw="2351230";
    public Connection getConn()throws Exception...{
        Connection conn=null;
        try...{
            conn=DriverManager.getConnection(url,dbName,dbPw);
            System.out.println("conn="+conn);
        }
        catch(Exception e)...{e.printStackTrace();}
        return conn;
    }

    public Statement createStmt()throws Exception...{
        Statement stmt=null;
        try...{
            stmt=conn.createStatement();
        }
        catch(SQLException e)...{System.err.print(e.getMessage());
        throw e;
        }
        return stmt;
    }
    public connMysql()throws Exception...{
        try
            ...{
                Class.forName("org.gjt.mm.mysql.Driver");
                System.out.println("动态加载成功");

            }
        catch(Exception e)...{e.printStackTrace();}
    }

    public ResultSet executeQuery(String sql)throws Exception...{
        try...{
            System.out.println("Before Connection");
            conn=getConn();
            System.out.println("conn="+conn);
            System.out.println("连接成功");
            stmt=createStmt();
            System.out.println("创建内容成功");
            rs=stmt.executeQuery(sql);
            System.out.println("查询成功");
        }
        catch(Exception e)...{e.printStackTrace();}
        return rs;
    }

    public int executeUpdate(String sql)throws Exception...{
        int result=0;
        try...{
            
            conn=getConn();
            stmt=createStmt();
            result=stmt.executeUpdate(sql);
        }
        catch(Exception e)...{e.printStackTrace();}
        return result;
    }

    public void close()throws Exception...{
    rs.close();
    stmt.close();
    conn.close();
    }
    public void closeRet()throws Exception...{
    stmt.close();
    conn.close();
    }
    
    
    public static void main(String[] args) 
    ...{
        try...{
        connMysql cm=new connMysql();
        //cm.Mysql();
        ResultSet rs=cm.executeQuery("select * from mathweb");
        System.out.println("successful");
        while(rs.next())
        ...{
            System.out.println(rs.getString(1));
            System.out.println(rs.getString(2));
        }
        cm.close();
        System.out.println("Hello World!");
        }
        catch(Exception e)...{e.printStackTrace();}
    }
}