import java.sql.Connection;

 import java.sql.DriverManager;

 /*

  * JDBC工具类

  */

 public class JDBCUtils {

     public static final String DRIVERNAME = "com.mysql.jdbc.Driver";

     public static final String URL = "jdbc:mysql://localhost:3306/mybase";

     public static final String USER = "root";

     public static final String PASSWORD = "root";

     static {

         try {

             Class.forName(DRIVERNAME);

         } catch (ClassNotFoundException e) {

             System.out.println("数据库驱动注册失败！");

         }

     }

     // 提供获取连接的方法

     public static Connection getConn() throws Exception {

         // 2. 获得连接

         Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);

         // 返回连接

         return conn;

     }

 }

 import java.sql.Connection;

 import java.sql.PreparedStatement;

 import java.sql.ResultSet;

 public class TestJDBCUtils {

     public static void main(String[] args) throws Exception {

         Connection conn = JDBCUtils.getConn();

         // 3获得预处理对象

         String sql = "select * from sort";

         PreparedStatement stat = conn.prepareStatement(sql);

         ResultSet rs = stat.executeQuery();

         // 处理结果集(遍历结果集合)

         while (rs.next()) {

             // 获取当前行的分类ID

             String sid = rs.getString("sid");// 方法参数为数据库表中的列名

             // 获取当前行的分类名称

             String sname = rs.getString("sname");

             // 显示数据

             System.out.println(sid + "-----" + sname);

         }

         // 释放资源

         rs.close();

         stat.close();

         conn.close();

     }

 }