java中关于mysql数据库操作（查询）

/**

 * 查询代码

 * @author Lin

 *

 */

public class TestQuery01 {

 

    public static void main(String[] args) {

 

       // 加载驱动(5.1.18 可以省略)

       // url user password

       // /jdbc:mysql://localhost:3306/mydb?useunicode=true&characterEncoding=utf-8....

       String url = "jdbc:mysql://localhost:3306/companydb";

       String user = "root";

       String password = "root";

 

       // 准备sql语句

       String sql = "select deptNo,deptName,deptDesc from dept";

 

       Connection conn = null;

       PreparedStatement pstmt = null;

       ResultSet rs = null;

 

       // 通过DriverManager类得到Connection对象

       try {

           conn = DriverManager.getConnection(url, user, password);

 

           // 通过connection对象得到PreparedStatement

           pstmt = conn.prepareStatement(sql);

 

           // 通过preparedStatement对象执行sql

           rs = pstmt.executeQuery();

 

           // 遍历 next getxx

           // 得到结果要做处理?

           while (rs.next()) {

              // 一行记录拼接在info中

              // getXX(查询语句列名) getXX(索引)

              String info = rs.getInt("deptNo") + "," + rs.getString(2) + "," + rs.getString(3);

              System.out.println(info);

           }

 

           // executeUpdate() executeQuery

       } catch (SQLException e) {

           // TODO Auto-generated catch block

           e.printStackTrace();

       }

 

       finally {

           // 释放资源

           // result

           if (null != rs)

              try {

                  rs.close();

              } catch (SQLException e) {

                  // TODO Auto-generated catch block

                  e.printStackTrace();

              }

           // preparedstatement

           if (null != pstmt)

              try {

                  pstmt.close();

              } catch (SQLException e) {

                  // TODO Auto-generated catch block

                  e.printStackTrace();

              }

 

           // connection

 

           if (null != conn)

              try {

                  conn.close();

              } catch (SQLException e) {

                  // TODO Auto-generated catch block

                  e.printStackTrace();

              }

       }

 

    }

}