myeclipse连接数据库oracle（添加jdbc.properties）

第一步：在src下面建一个包com.xsl.conf

第二步：在建好的包下面新建一个jdbc.properties

第三步：在jdbc.properties里写入内容如下：

　　driver = oracle.jdbc.driver.OracleDriver

　　url = jdbc:oracle:thin:@127.0.0.1:1521:orcl或jdbc:oracle:thin:@localhost:1521:orcl

　　uname = scott

　　upwd = tiger

第四步：建BaseDao

package com.xsl.dao;

import java.io.IOException;
import java.io.InputStream;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;

import com.xsl.entity.Student;

public class BaseDao {
    
    private static Properties ps = new Properties();
    
    static{
        InputStream is = BaseDao.class.getClassLoader().getResourceAsStream("com/xsl/conf/jdbc.properties");
        try {
            ps.load(is);
            System.out.println(ps);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    
    /**
     * 获得数据库连接
     */
    public static Connection getConnection(){
        Connection conn = null;
        try {
            Class.forName(ps.getProperty("driver"));        //"oracle.jdbc.driver.OracleDriver"
            conn = DriverManager.getConnection(ps.getProperty("url"),ps.getProperty("uname"),ps.getProperty("upwd"));        //"jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tiger"或//"jdbc:oracle:thin:@localhost:orcl","scott","tiger"
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
    
    /**
     * 添加
     * @param obj:需要被保存的对象
     * @return 受影响的行数
     */
    public static int save(Object obj){
        //insert into 表名(列名1，列名2...) values(?,?...)
        int row = 0;
        //获取需要被保存实体对象的Class类型的对象
        Class c = obj.getClass();
        //获取实体类中的属性对象
        Field [] fs =  c.getDeclaredFields();
        //给属性对象解锁
        Field.setAccessible(fs, true);
        //拼SQL语句
        StringBuffer sql = new StringBuffer();
        sql.append(" insert into ");
        sql.append(c.getSimpleName());//添加表名
        sql.append(" ( ");
        for(int i=1;i<fs.length;i++){//添加列名
            sql.append(fs[i].getName());
            if(i<fs.length-1){//判断没有到最后一个列
                sql.append(" , ");
            }
        }
        sql.append(" ) ");
        sql.append(" values (");
        for(int i=1;i<fs.length;i++){
            sql.append(" ? ");
            if(i<fs.length-1){
                sql.append(" , ");
            }
        }
        sql.append(" ) ");
        System.out.println(sql);
        Connection conn = getConnection();
        PreparedStatement pstmt = null;
        try {
            pstmt = conn.prepareStatement(sql.toString());
            //给占位符赋值
            for(int i=1;i<fs.length;i++){
                //stu.getName();stu.getMoney();
                //fs[i].get(obj)从obj这个对象中获取fs[i]这个属性对应的值
                pstmt.setObject(i, fs[i].get(obj));
            }
            row = pstmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            closeAll(conn, pstmt, null);
        }
        return row;
    }
    
    /**
     * 查询
     */
    public static List queryList(Class c){
        List list = new ArrayList();
        Field [] fs = c.getDeclaredFields();
        Field.setAccessible(fs, true);
        //select * from 表名
        StringBuffer sql = new StringBuffer();
        sql.append(" select * from ");
        sql.append(c.getSimpleName());
        Connection conn = getConnection();
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            pstmt = conn.prepareStatement(sql.toString());
            rs = pstmt.executeQuery();
            while(rs.next()){
                //Student stu = new Student();
                //stu.setName(rs.getString("name"));
                //stu.setMoney(rs.getDouble("money"));
                Object obj =  c.newInstance();
                for(int i=0;i<fs.length;i++){
                    //fs[i].get(obj);stu.getName();
                    //fs[i].getName()获取属性名
                    //rs.getObject(Objet obj)在结果集中按列名取值
                    //fs[i].set(obj,value);调用属性的赋值方法，给属性赋值
                    fs[i].set(obj, rs.getObject(fs[i].getName()));//stu.setName(rs.getString("name"));
                }
                list.add(obj);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            closeAll(conn, pstmt, rs);
        }
        return list;
    }
    
    /**
     * 删除
     */
    public static int delete(Object obj){
        int row = 0;
        //delete from 表名 where 主键=?
        Class c = obj.getClass();
        Field [] fs = c.getDeclaredFields();
        Field.setAccessible(fs, true);
        StringBuffer sql = new StringBuffer();
        sql.append(" delete from ");
        sql.append(c.getSimpleName());
        sql.append(" where ");
        sql.append(fs[0].getName());
        sql.append(" = ?");
        //System.out.println(sql);
        Connection  conn = getConnection();
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            pstmt = conn.prepareStatement(sql.toString());
            pstmt.setObject(1, fs[0].get(obj));
            row = pstmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
            closeAll(conn, pstmt, rs);
        }
        return row;
    }

    /**
     * 关闭数据库连接
     */
    public static void closeAll(Connection conn,Statement pstmt,ResultSet rs){
        try{
            if(rs!=null){
                rs.close();
            }
            if(pstmt!=null){
                pstmt.close();
            }
            if(conn!=null){
                conn.close();
            }
        }catch (Exception e) {
            e.printStackTrace();
        }
    }
    
    
    public static void main(String[] args) {
        //System.out.println(getConnection());
        //save(new Student("刘二狗",888,new Date(System.currentTimeMillis())));
        /*List<Student> list =  queryList(Student.class);
        for(Student stu:list){
            System.out.println(stu.getId()+"	"+stu.getName()+"	"+stu.getMoney()+"	"+stu.getBrithday());
        }*/
        delete(new Student(16));
        
    }
}

 测试

public class Test 
{
    public static void main(String[] args) 
    {
        //1、获取hibernate中的配置信息（获取数据库的详细信息）
        Configuration cofig = new Configuration().configure();
        //2、创建session工厂
        SessionFactory factory = config.buildSessionFactory();
        //3、获取session对象（connection）
        Session session = factory.openSession();
        //4、开启事务
        session.beginTransaction();
        
        Student s = new Student();
        s.setAge(11);
        s.setName("xsl");

        //5、保存
        session.save(s);
        //6、事务提交
        session.getTransaction().commit();
        //7、session关闭
        session.close();
    }
}