非常基础的代码,导入相应数据库的驱动包,代码如下:
package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.junit.Test;
/**
* 测试连接数据库代码
*/
public class DatabaseConnection {
private String url = null;
private String user = null;
private String pwd = null;
private String sql = null;
private Connection con = null;
private PreparedStatement pre = null;
private ResultSet resultSet = null;
@Test
public void mysql() {
url = "jdbc:mysql://127.0.0.1:3306/test";
user = "root";
pwd = "123";
sql = "select * from test where id = ?";
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(url, user, pwd);
pre = con.prepareStatement(sql);
pre.setString(1, "1");
resultSet = pre.executeQuery();
while (resultSet.next()) {
System.out.println(resultSet.getString(1) + " "
+ resultSet.getString(2));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (resultSet != null) {
resultSet.close();
}
if (pre != null) {
pre.close();
}
if (con != null) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
@Test
public void oracle() {
url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
user = "system";
pwd = "123";
sql = "SELECT * FROM TEST";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url, user, pwd);
pre = con.prepareStatement(sql);
resultSet = pre.executeQuery();
while (resultSet.next()) {
System.out.println(resultSet.getString(1) + " "
+ resultSet.getDate(3));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (resultSet != null) {
resultSet.close();
}
if (pre != null) {
pre.close();
}
if (con != null) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}