import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;
public class FirstOracleJdbc {
public static void main(String[] args) throws SQLException {
insert(new int[]{5},new String[]{"iGoder"}, new Date[]{("1980-01-01")});
select();
}
public static void select() {
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
("");
con = (
"jdbc:oracle:thin:@localhost:1521:xe", "test", "test");
st = ();
String sql = "select * from student";
rs = (sql);
while (()) {
("id"));
(",name=" + ("name"));
(",birthday=" + ("birthday")+"\n");
}
("+++++++++++++++++++++++++++++++++++");
//printRS(rs);
} catch (Exception e) {
();
} finally {
try {
();
} catch (Exception e) {
}
try {
();
} catch (Exception e) {
}
try {
();
} catch (Exception e) {
}
}
}
public static void insert(int[] ids, String[] names, Date[] dates)
throws SQLException {
Connection con = null;
PreparedStatement ps = null;
try {
("");
con = (
"jdbc:oracle:thin:@localhost:1521:xe", "test", "test");
(false);
String sql = "insert into student(id, name, birthday) values(?,?,?)";
ps = (sql);
for (int i = 0; i < ; i++) {
int index = 1;
(index++, ids[i]);
(index++, names[i]);
(index++, dates[i]);
();
}
();
} catch (Exception e) {
();
try {
();
} catch (Exception e1) {
}
throw new SQLException(());
} finally {
try {
();
} catch (Exception e) {
}
try {
();
} catch (Exception e) {
}
}
}
public static void printRS(ResultSet rs) throws SQLException
{
ResultSetMetaData rsmd = ();
int colCount = ();
while(())
{
for(int i = 1; i <= colCount; i++)
{
if(i > 1)
{
(",");
}
String name = (i);
String value = (i);
(name + "=" + value);
}
();
}
}
}