连接数据库:
package com.sinosoft.wwl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Dbconnection
{
final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";//加载oracle驱动
final static String sConnStr = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";//127.0.0.1 是本机:1521 是接口:orcl 是数据库名,如果不知道数据库名可在SOL Plus中输入select * from v$database;得到当前数据库名。
final static String user="system";//用户名
final static String password="orcl";//密码
public Dbconnection()
{
}
public static Connection connectionDbByOci()
{
Connection conn = null;
try {
Class.forName(sDBDriver);
conn = (Connection) DriverManager.getConnection(sConnStr,user,password);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void closeConnection(Connection conn)
{
if(conn !=null)
{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void closePrepStmt(PreparedStatement prepStmt)
{
if(prepStmt !=null)
{
try {
prepStmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void closeResultSet(ResultSet re)
{
if(re != null)
{
try {
re.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
得到当前数据库名:
测试是否连接到数据库:
package com.sinosoft.wwl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBUser {
public static void main(String[] args)
{
Connection conn = null;
PreparedStatement pre = null;
ResultSet re = null;
Dbconnection dbcon = new Dbconnection();
conn = Dbconnection.connectionDbByOci();
String sql = "select * from stuinfo";
try {
pre = conn.prepareStatement(sql);
re = pre.executeQuery();
while(re.next())
{
System.out.println("stuname:"+re.getString("stuname"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally
{
dbcon.closeConnection(conn);
dbcon.closePrepStmt(pre);
dbcon.closeResultSet(re);
}
}
}
即可得到数据库表stuinfo中的数据。