JDBC的实例

实例1.  使用纯Java的方式连接数据库

  import java.sql.Connection;
  import java.sql.DriverManager;
  import java.sql.SQLException;
  
  
  public class Test1 {
  
      public static void main(String[] args){
         //1:加载数据库驱动
          try {
             Class.forName("com.mysql.jdbc.Driver");
         } catch (ClassNotFoundException e) {
             e.printStackTrace();
        }
         
         
       
        //2:建立连接，获得Connection对象

        //Eclipse：导入包的快捷键：Ctrl+Shift+O
         //代码的格式化：Ctro+Shift+F
          
          Connection conn=null;
         try {
            conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/day01","root","root");
             System.out.println("連接成功");
         } catch (SQLException e) {
             e.printStackTrace();
         }
             //3.获取Statement对象
        try {
            stmt=conn.createStatement();
            //stmt.execute(sql);
            stmt.executeUpdate(sql);
            
        } catch (Exception e) {
        }
         
        //4:关闭资源
          try {
           conn.close();
       } catch (SQLException e) {
             e.printStackTrace();
        }
     }
    }

需求：使用ResultSet查询dog信息

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

/**
 * 需求：使用ResultSet查询dog信息
 * 
 * @author10  *
 */

public class Test3 {
    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        String url = "jdbc:mysql://localhost:3306/day01";
        String user = "root";
        String password = "root";
        String sql = "SELECT * FROM dog";

        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url, user, password);
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);

            // 遍历rs
            // rs.next();指针下移    
            while (rs.next()) {
                // 在MySql数据库中index从1开始
                System.out.println(rs.getObject(1) + "\t");
                System.out.println(rs.getObject(2) + "\t");
                System.out.println(rs.getObject("health") + "\t");
                System.out.println(rs.getObject("love") + "\t");
                System.out.println(rs.getObject("strain") + "\t");

            }

        } catch (Exception e) {

        } finally {
            try {
                if (null != rs) {
                    rs.close();
                }
                if (null != stmt) {
                    stmt.close();
                }
                if (null != conn) {
                    conn.close();
                }
            } catch (Exception e2) {
            }

        }

    }
}