database_back.java

这个程序是花了好几十万请人开发的

/*
 * 创建日期 2004-10-26
 *
 * 更改所生成文件模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
package javabean;

import java.sql.*;

/**
 * @author jason
 *
 * 更改所生成类型注释的模板为
 * 窗口 > 首选项 > Java > 代码生成 > 代码和注释
 */
public class DataBase_back {
	private Connection con;
	private Statement sql;
	private ResultSet rs;
	private Connection con_excel;
	private Statement sql_excel;
	private ResultSet rs_excel;
	public DataBase_back()
	{
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
		}
		catch(ClassNotFoundException e){}
	}
	public boolean Insert(String str)
	{
		
		try
		{
			con=DriverManager.getConnection("jdbc:oracle:thin:@211.67.54.20:1521:dbora04","hbfz","j2eeoracle");
			sql=con.createStatement();
			sql.executeUpdate(str);
			if(sql!=null)
				sql.close();
			if(con!=null)
			{
				con.close();
			}
		}
		catch(SQLException e){return false;}
		return true;
	}
	public ResultSet query(String str)
	{
		try
		{
			con=DriverManager.getConnection("jdbc:oracle:thin:@211.67.54.20:1521:dbora04","hbfz","j2eeoracle");
			sql=con.createStatement();
			rs=sql.executeQuery(str);
			}
			catch(SQLException e){return null;}
			return rs;
	}
	
	public boolean ExceltoOracle(String code,String excelname)
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){return false;}
		try
		{
			con_excel=DriverManager.getConnection("jdbc:odbc:star","","");
			con=DriverManager.getConnection("jdbc:oracle:thin:@211.67.54.20:1521:dbora04","hbfz","j2eeoracle");
			sql_excel=con_excel.createStatement();
			sql=con.createStatement();
			String str="select * from "+excelname;
			rs_excel=sql_excel.executeQuery(str);
			while(rs_excel.next())
			{
				float price=Float.parseFloat(rs_excel.getString(2));
				String timedate=rs_excel.getString(1).trim();
				timedate=timedate.substring(0,10);
				String insert="insert into data values("+price+",'"+timedate+"','"+code+"')";
				sql.executeUpdate(insert);
			}
		}
		catch(SQLException e){return false;}
		return true;
	}
}