最简单的java连接数据库步骤

来源：互联网发布：控制面板找不到mysql 编辑：程序博客网时间：2024/05/22 15:08

在JAVA中连接数据库通常会出现以下几个步骤：

1.驱动加载，

2.建立连接

3.创建语句

4.执行语句

5.处理ResultSet

具体代码如下：

package jdbcTest;

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

public class SampleJDBC {

/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException {
  //1.安装驱动
  Class.forName("com.mysql.jdbc.Driver");
  //Access
  //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  //Oracle
  //Class.forName("oracle.jdbc.dirver.OracleDriver");
  System.out.println("Driver loaded!!!");
  //2.建立连接
  Connection con = DriverManager.getConnection("jdbc:mysql://localhost/javabook","root","root");
  //Access
  //Connection con = DriverManager.getConnection("jdbc:odbc:(数据源)ExampleDBDataSource");
  //Oracle
  //Connection con = DriverManager.getConnection("jdbc:oracle:thin:@主机名（localhost）:1521","root","root");
  System.out.println("database connected.");

  //3.创建语句
  Statement stmt = con.createStatement();
  //4.执行语句
  ResultSet rs = stmt.executeQuery("show tables;");
  //5.处理查询结果
  while(rs.next())
  {
   System.out.println(rs.getString(1));

  }
  con.close();

}