JDBC数据库连接

来源：互联网发布：淘宝哪个店铺女装好编辑：程序博客网时间：2024/05/01 02:06

package com.hq;

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

public class TestJDBC {
public static void main(String[] args) throws Exception{
  Statement stmt = null;
  Connection conn = null;
  ResultSet rs = null;
  try{
  //Class.forName("oracle.jdbc.driver.OracleDriver");
   Class.forName("com.mysql.jdbc.Driver");
  //new oracle.jdbc.driver.OracleDriver();

   //conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:heqiang","heqiang","258525");
   conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/heqiang","root","root");

  //System.out.println(conn);

  stmt = conn.createStatement();
  rs = stmt.executeQuery("select * from rain");

  while (rs.next()){
   System.out.println(rs.getString("id"));
   System.out.println(rs.getString("name"));
   System.out.println(rs.getString("age"));
  }
  }catch(ClassNotFoundException e){
   e.printStackTrace();

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

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

}