在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();
}
}