1、导入oracle驱动包至工程的Build Path中,本人使用的是ojdbc14.jar
2、创建数据库操作类DBManager:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBManager{
Connection con = null;
PreparedStatement pre = null;
ResultSet result = null;
public static boolean _Convert = true;
public Static String ENCODE_DB = "UTF-8";
//方法1,连接数据库
public Connection newConnection(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();//加载数据库驱动
System.out.println("开始数据库连接!");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String user = "system";
String password = "123";
con = DriverManager.getConnection(url,user,password);//获取连接
System.out.println("连接成功!");
return this.conn;
}catch(Exception e){
e.printStackTrace();
}
//方法2,转换字符集
public String convert(String paramString){
try{
if((paramString !=null)&&(!(paramString.equals(""))))
return new String(paramString.getBytes(),ENCODE_DB);
return null;
}catch(Exception e){
e.printStackTrace();
}
return paramtring;
}
//方法3,sql语句加入编译器
public PreparedStatement getPre (String sqlStr){
pre = con.preparedStatement(sqlStr);
return pre;
}
//方法4,执行查询
public final String executeQueryString(String sqlStr){
String res = " ";
try{
res = getPre(sqlStr).executeQuery().toString;
}catch(Exception e){
e.printStackTrace();
}
return res;
}
}