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();
}
}
}
}
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();
}
}
}
}