你把class12.jar这个文件放到你的classpath路径里面去
解决方案 »
- xml版的word存到oracle数据库,并且取出来能正确显示
- 如何将文件中的对象全部读取出来
- 回车就会飞?
- JSP程序员面试的问题
- java连接Access数据库问题
- 求助一个Applet小程序问题
- Eclipse如何汉化!!!!请多指教!!!
- 请问compare()&compareTo()方法是否功能上差不多?各有什么优缺点?
- 帮助我修改一下程序 好吗 是有关和数据库连接的
- HELP!!!!!!
- 在简体Windows Advanced 2000下安装SQL Server 2000后,控制面板上没有ODBC DATE SOURCE,请问如何设置在JAVA中数据庫連接?
- 看看这个关于JBuilder中Jframe的问题
Class.forName(jdbcDriver);不是oracle.jdbc.OracleDriver
你的 driver 没导进来。。
//classpath=yourClassPath;class12.zip
//File database.properties
jdbc.drivers=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:ouyang
jdbc.username=scott
jdbc.password=tiger
*************/
import java.io.*;
import java.util.*;
import java.sql.*;
class DatabaseOption
{
public static Connection getConnection(String databaseFileName)
throws SQLException, IOException
{
Properties props = new Properties();
FileInputStream in = new FileInputStream(databaseFileName);
props.load(in);
in.close();
String drivers = props.getProperty("jdbc.drivers");
if (drivers != null){
try{
Class.forName(drivers);
}catch(Exception e)
{
e.printStackTrace();
}
}
String url = props.getProperty("jdbc.url");
String username = props.getProperty("jdbc.username");
String password = props.getProperty("jdbc.password");
return
DriverManager.getConnection(url, username, password);
}
public static void executeSQL(Connection conn,String insertSqlStr)
throws SQLException, IOException
{
Statement stat = conn.createStatement();
boolean hasResultSet = stat.execute(insertSqlStr);
if (hasResultSet)
showResultSet(stat);
}
public static void showResultSet(Statement stat)
throws SQLException
{
ResultSet result = stat.getResultSet();
ResultSetMetaData metaData = result.getMetaData();
int columnCount = metaData.getColumnCount();
for (int i = 1; i <= columnCount; i++)
{
if (i > 1) System.out.print(", ");
System.out.print(metaData.getColumnLabel(i));
}
System.out.println();
while (result.next())
{
for (int i = 1; i <= columnCount; i++)
{
if (i > 1) System.out.print(", ");
System.out.print(result.getString(i));
}
System.out.println();
}
result.close();
}
}
public class Test
{
public static void main(String args[])
{
String strCreateTableSQL="create table table_name1(a number(10),b number(10),c number(10),d number(10))";
String strSQL="insert table_name1(a,b,c,d) values (1,2,3,4)";
try{
Connection conn=DatabaseOption.getConnection(args[0]);
System.out.println("database connect success");
DatabaseOption.executeSQL(conn,strCreateTableSQL);
System.out.println("create table success");
while(true)
{
System.out.println("main will sleep 50s to be continued...");
Thread.sleep(5*10000);
DatabaseOption.executeSQL(conn,strSQL);
System.out.println("insert table success");
}
}catch(SQLException e)
{
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
Connection connection=null;
try{
//加载 JDBC 驱动
String driverName=”oracle.jdbc.driver.OracleDriver”;
Class.forName(driverName);
String serverName=”127.0.0.1” //创建连接
String portNumber=”1521”
String sid=”mydatabase”;
String url=”jdbc:oracle:thin@”+serverName+”:”+portNumber+”:”+sid;
String username=”username”;
String password=”password”;
Connection=DriverManager.getConnection(url,username,password);
}catch(ClassNotFoundException e){
//无法找到数据库驱动
}catch(SQLException e){
//无法连接到数据库
}
同时也谢大家。
因为分数太少,给的少别见笑。