schq_excel_oracle.java

来自「这个程序是花了好几十万请人开发的」· Java 代码 · 共 124 行

package javabean;

import java.sql.*;


public class Schq_Excel_oracle {
	private Connection con;
	private Statement sql;
	private ResultSet rs;
	private Connection con_excel;
	private Statement sql_excel;
	private ResultSet rs_excel;
	
	public String Insert(String str)
	{
		String msg="";
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
		}
		catch(ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
		
		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();
			}
			msg="success";
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
			msg="failure";
		}
		return msg;
	}
	
	public ResultSet Oracle_query(String str)
	{
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
		}
		catch(ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
		
		try
		{
			con=DriverManager.getConnection("jdbc:oracle:thin:@211.67.54.20:1521:dbora04","hbfz","j2eeoracle");//连接到oracle
			sql=con.createStatement();
			rs=sql.executeQuery(str);
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
		}
		return rs;
	}
	
	/*public ResultSet Excel_query(String str)
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
		
		try
		{
			con_excel=DriverManager.getConnection("jdbc:odbc:schq","","");//连接excel
			sql=con.createStatement();
			rs=sql.executeQuery(str);
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
		}
		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:schq","","");
			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;
	}*/
}