我用的是Oreclo數據庫該怎樣寫這一段？？
private static final String driver = "com.mysql.jdbc.Driver"; //數據庫驅動
?? ?//連接數據庫的URL地址?? ?
?? ?private static final String url="jdbc:mysql://localhost:3306/shopping?useUnicode=true&characterEncoding=UTF-8";
?? ?private static final String username="root";//數據庫的用戶名
?? ?private static final String password="";//數據庫的密碼
2016-12-12
package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBHelper {
private static Connection connection=null;
private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orc";
private static final String USERNAME = "SYS as SYSDBA";
private static final String PASSWORD = "admin";
static{
try {
Class.forName(DRIVER);
} catch (Exception e) {
e.printStackTrace();
}
}
private static Connection getConnection() {
if (connection==null) {
try {
connection = DriverManager.getConnection(URL,USERNAME,PASSWORD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
} else {
return connection;
}
}
private static void closeConnection(Connection connection) {
if (connection!=null) {
try {
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
Connection conn = null;
conn = DBHelper.getConnection();
if (conn!=null) {
System.out.println("數據庫連接正常");
}else {
System.out.println("數據庫連接異常");
}
DBHelper.closeConnection(conn);
}
}
2016-11-14
應該是其他步驟都一樣，改一下數據庫驅動和url地址就行了；
可以參考博客園的一篇文章：http://www.cnblogs.com/liuxianan/archive/2012/08/05/2624300.html
private static final String driver = "oracle.jdbc.driver.OracleDriver";//數據庫驅動
private static final String url = "jdbc:oracle:thin:@localhost:1521:shopping";//連接數據庫的URL地址?
private static final String username="root";//數據庫的用戶名
private static final String password="";//數據庫的密碼
oracle里的jdbc url沒有設定字符集的參數,下面是CSDN上一個討論帖，個人覺得里面那個while (rs.next()) {?
ARRAY my_array = ((OracleResultSet)rs).getARRAY(1); 。。。}的示例不錯
:
http://blog.csdn.net/haiross/article/details/38380449