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();} }}