阳光温热，岁月静好，你还不来，我怎敢老去？

CREATE  TABLE  person(name varchar(40),age integer,year integer)

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

public class jdbctest
{
    public static void main(String[] args) throws SQLException
    {
        Connection con = null;
        try
        {
            con = DriverManager.getConnection(
                    "jdbc:oracle:thin:@128.20.49.33:1521:sigdb", "sig_etl_rpt",
                    "hahaha");
            Statement stmt = con.createStatement();
            // 插入
            int rs1 = stmt
                    .executeUpdate("insert into person (name,age,year) values('lin',22,2005)");
            rs1 = stmt
                    .executeUpdate("insert into person (name,age,year) values('dao',23,2005)");
            // 查找
            ResultSet rs2 = stmt.executeQuery("select * from person");
            while (rs2.next())
                System.out.println(rs2.getString("name") + ","
                        + rs2.getString("age") + "," + rs2.getString("year"));
            System.out.println("5 years passed, I get up only 1 year.");
            // 修改
            rs1 = stmt
                    .executeUpdate("update person set age='23',year='2010' where name = 'lin'");
            rs1 = stmt
                    .executeUpdate("update person set name='li',age='25',year='2010' where name = 'dao'");

            ResultSet rs3 = stmt.executeQuery("select * from person");
            while (rs3.next())
                System.out.println(rs3.getString("name") + ","
                        + rs3.getString("age") + "," + rs3.getString("year"));
            // 删除
            boolean rs4 = stmt.execute("drop table person");
        }
        finally
        {
            try
            {
                if (null != con)
                {
                    con.close();
                }
            }
            catch (SQLException e)
            {
                e.printStackTrace();
            }
        }
    }
}