项目ORACLE的JDBC驱动
代码如下:
- package com.gui.file;
- import java.awt.FlowLayout;
- import java.awt.TextField;
- import java.awt.event.ActionEvent;
- import java.awt.event.ActionListener;
- import java.util.List;
- import javax.swing.JButton;
- import javax.swing.JFrame;
- public class filenameSave {
- private static TextField text1;
- private static JButton send = new JButton("确定");
- public static void main(String[] args) {
- JFrame f = new JFrame();
- f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- f.setLayout(new FlowLayout());
- f.setBounds(50, 50, 300, 200);
- text1 = new TextField("", 30);
- text1.setLocation(30, 30);
- f.add(text1);
- f.add(send);
- // 在文本框中的事件是:输入文本并回车
- text1.addActionListener(new ActionListener() {
- public void actionPerformed(ActionEvent e) {
- if (!text1.getText().equals("")) {
- text1.setText("");
- }
- }
- });
- send.addActionListener(new ActionListener(){
- @Override
- public void actionPerformed(ActionEvent e) {
- String strPath = text1.getText();
- fileTraverse filenameList = new fileTraverse();
- DataOperate ds = new DataOperate();
- List<String> list = filenameList.refreshFileList(strPath);
- if(list!=null){
- for(String name :list){
- String sql = "insert into fileName (filename) values ('" + name+"')" ;
- System.out.println(sql);
- ds.saveDate(sql);
- }
- }
- }});
- f.setVisible(true);
- }
- }
- package com.gui.file;
- /*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.ResultSet;
- /**
- *数据库操作类
- * @author zhuyuehua
- */
- public class DataOperate {
- private String dbDriver = "oracle.jdbc.driver.OracleDriver";
- private String url = "jdbc:oracle:thin:@127.0.0.1:1521:test";
- private String username = "test";
- private String password = "test";
- private Connection con = null;
- public void JDBConnection() {
- try {
- Class.forName(dbDriver).newInstance(); //加载数据库驱动
- System.out.println("数据库加载成功");
- }
- catch (Exception ex) {
- System.out.println("数据库加载失败");
- }
- }
- //创建数据库连接
- public boolean creatConnection() {
- try {
- Class.forName(dbDriver);
- con = DriverManager.getConnection(url, username, password);
- System.out.println("连接数据库成功");
- }catch(ClassNotFoundException ce)
- {
- System.out.println(" 数据库连接失败!\n");
- ce.printStackTrace();
- }
- catch (SQLException e) {
- e.printStackTrace();
- }
- return true;
- }
- //关闭数据库的操作
- public void closeConnection() {
- if (con != null) {
- try {
- con.close();
- System.out.println("关闭数据库成功");
- }
- catch (SQLException e) {
- e.printStackTrace();
- }
- finally {
- con = null;
- }
- }
- }
- //保存数据
- public boolean saveDate(String sql){
- if (con == null) {
- creatConnection();
- }
- try {
- Statement stmt = con.createStatement();
- stmt.executeUpdate(sql);
- stmt.close();
- }catch (SQLException e) {
- return false;
- }finally{
- closeConnection();
- }
- return true;
- }
- }
- package com.gui.file;
- import java.io.File;
- import java.util.ArrayList;
- import java.util.List;
- public class fileTraverse {
- private List<String> list = new ArrayList<String>();
- public List<String> refreshFileList(String strPath) {
- File dir = new File(strPath);
- File[] files = dir.listFiles();
- if (files == null)
- return null;
- for (int i = 0; i < files.length; i++) {
- if (files[i].isDirectory()) {
- refreshFileList(files[i].getAbsolutePath());
- } else {
- //String strFileName = files[i].getAbsolutePath().toLowerCase();
- String strFileName = files[i].getName();
- //System.out.println(strFileName);
- list.add(strFileName);
- }
- }
- return list;
- }
- }