jdbc（java连接数据库oracle）

package day20151020jdbc;

public class Emp {
    private int id;
    private String name;
    private String gender;
    private double salary;
    public Emp(int id, String name, String gender, double salary) {
        super();
        this.id = id;
        this.name = name;
        this.gender = gender;
        this.salary = salary;
    }

    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getGender() {
        return gender;
    }
    public void setGender(String gender) {
        this.gender = gender;
    }
    public double getSalary() {
        return salary;
    }
    public void setSalary(double salary) {
        this.salary = salary;
    }

    @Override
    public String toString() {
        return id + "," + name + "," +gender+","+ salary;
    }


}

package day20151020jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class JdbcTest {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        List<Emp> list = new ArrayList<Emp>();
        try{
            //加载驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");
            //建立连接
            conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe",
                    "userid","password");
            String sql = "select * from emp";

            //预编译sql
            ps = conn.prepareStatement(sql);

            //执行sql
            rs = ps.executeQuery();         

            while(rs.next()){
                int id = rs.getInt("id");
                String name = rs.getString("name");
                String gender = rs.getString("gender");
                double salary = rs.getDouble(4);
                //System.out.println(id + "," + name + "," +gender+","+ salary);
                Emp emp = new Emp(id,name,gender,salary);
                list.add(emp);
            }
            //System.out.println(list);
            for(Emp emp : list){
                System.out.println(emp);
            }
            ps.close();
            //插入数据
            String sql1 = "insert into emp values(?,?,?,?)";
            ps = conn.prepareStatement(sql1);
            ps.setInt(1, 1005);
            ps.setString(2, "钱七");
            ps.setString(3, "F");
            ps.setDouble(4, 15000.5);
            //返回类型为int，返回值是对数据库修改了几条数据
            int a = ps.executeUpdate();
            if(a>0){
                System.out.println("插入数据成功");
            }else{
                System.out.println("插入数据失败");
            }
        }catch(Exception e){

        }finally{
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}