JDBC连接ORACLE

创建工程，引入驱动包

package cn.itcast.waterboss.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/*
 * 
 * 基本数据访问类：用于获取数据库连接， 关闭资源
 * 
 * */
public class BaseDao {
    static{
        try {
            Class.forName("oracle.jabc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

    public static java.sql.Connection getConnection() throws SQLException {
        return DriverManager.getConnection("jdbc:oracle:thin:@192.168.241.130:1521:orcl", "waterboss", "oracle");

    }

    public static void closeAll(ResultSet resultSet,Statement statement,Connection connection){
        if (resultSet != null) {
            try {
                resultSet.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

        }
        if (statement != null) {
            try {
                statement.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

        }
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

        }
    }
}

2.

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.junit.Test;
import org.omg.CORBA.PUBLIC_MEMBER;

import cn.itcast.waterboss.entity.Owners;

/*
 * 
 * 业主的DAO
 * 
 * */
public class OwnersDao {
/*添加业主
 * 
 * */   
    public static void add(Owners owners){
        Connection connection = null;
        PreparedStatement preparedStatement = null;

        try {
            connection = BaseDao.getConnection();

            preparedStatement= connection.prepareStatement("insert into T_OWNERS values(?,?,?,?,?,?,?)");

            preparedStatement.setLong(1, owners.getId());
            preparedStatement.setString(2, owners.getName());
            preparedStatement.setLong(3, owners.getAddress());
            preparedStatement.setString(4, owners.getHouseNumber());
            preparedStatement.setString(5, owners.getWaterMeter());
            preparedStatement.setDate(6, new java.sql.Date(owners.getAdddate().getTime()));
            preparedStatement.setLong(7, owners.getOwnertypeID());
            preparedStatement.execute();




        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally {
            BaseDao.closeAll(null, preparedStatement, connection);
        }

    }


    @Test
    public void hah() throws ClassNotFoundException{
        System.out.println(Class.forName("oracle.jdbc.driver.OracleDriver"));
    }

}

3.

public class Owners {
    private Long id;
    private String name;
    private Long address;
    private String HouseNumber;
    private String waterMeter;
    private  java.util.Date adddate;
    private Long ownertypeID;
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public Long getAddress() {
        return address;
    }
    public void setAddress(Long address) {
        this.address = address;
    }
    public String getHouseNumber() {
        return HouseNumber;
    }
    public void setHouseNumber(String houseNumber) {
        HouseNumber = houseNumber;
    }
    public String getWaterMeter() {
        return waterMeter;
    }
    public void setWaterMeter(String waterMeter) {
        this.waterMeter = waterMeter;
    }
    public java.util.Date getAdddate() {
        return adddate;
    }
    public void setAdddate(java.util.Date adddate) {
        this.adddate = adddate;
    }
    public Long getOwnertypeID() {
        return ownertypeID;
    }
    public void setOwnertypeID(Long ownertypeID) {
        this.ownertypeID = ownertypeID;
    }

}

4

import java.util.Date;

import cn.itcast.waterboss.dao.OwnersDao;
import cn.itcast.waterboss.entity.Owners;

public class Test1 {
    public static void main(String[] args){
        Owners owners = new Owners();
        owners.setId(2L);
        owners.setName("hans");
        owners.setAddress(1L);
        owners.setHouseNumber("2-2");
        owners.setWaterMeter("3456");
        owners.setAdddate(new Date());
        owners.setOwnertypeID(2L);

        OwnersDao.add(owners);
    }
}