复制代码 代码如下:
import java.sql.Date;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
public class FirstOracleJdbc {
public static void main(String[] args) throws SQLException {
insert(new int[]{5},new String[]{"iGoder"}, new Date[]{Date.valueOf("1980-01-01")});
select();
}
public static void select() {
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "test", "test");
st = con.createStatement();
String sql = "select * from student";
rs = st.executeQuery(sql);
while (rs.next()) {
System.out.print("id=" + rs.getInt("id"));
System.out.print(",name=" + rs.getString("name"));
System.out.print(",birthday=" + rs.getDate("birthday")+"\n");
}
System.out.print("+++++++++++++++++++++++++++++++++++");
//printRS(rs);
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
st.close();
} catch (Exception e) {
}
try {
con.close();
} catch (Exception e) {
}
}
}
public static void insert(int[] ids, String[] names, Date[] dates)
throws SQLException {
Connection con = null;
PreparedStatement ps = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:xe", "test", "test");
con.setAutoCommit(false);
String sql = "insert into student(id, name, birthday) values(?,?,?)";
ps = con.prepareStatement(sql);
for (int i = 0; i < ids.length; i++) {
int index = 1;
ps.setInt(index++, ids[i]);
ps.setString(index++, names[i]);
ps.setDate(index++, dates[i]);
ps.executeUpdate();
}
con.commit();
} catch (Exception e) {
e.printStackTrace();
try {
con.rollback();
} catch (Exception e1) {
}
throw new SQLException(e.getMessage());
} finally {
try {
ps.close();
} catch (Exception e) {
}
try {
con.close();
} catch (Exception e) {
}
}
}
public static void printRS(ResultSet rs) throws SQLException
{
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
while(rs.next())
{
for(int i = 1; i <= colCount; i++)
{
if(i > 1)
{
System.out.print(",");
}
String name = rsmd.getColumnName(i);
String value = rs.getString(i);
System.out.print(name + "=" + value);
}
System.out.println();
}
}
}
jdbc,测试程序
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件! 如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
更新日志
- 《神话时代:重述版》评测:粉丝们的朝花夕拾
- 战锤40K星际战士2先锋职业介绍|先锋职业技能效果一览
- 战锤40K星际战士2重装职业介绍|重装职业技能效果一览
- 交错战线能源发电站推荐角色一览
- 阿波罗乐神之音《第4集出埃及记》[WAV+CUE]
- JohnWrightTrio-SouthSideSoul-1960-2024(24-192)
- AnthonyBruno-Cefalu(2024)[24-96]
- 《地狱潜者2》玩家人数飙升:终于不再削弱玩家了
- 黑神话引力!外媒分享孙悟空英文书籍:美生中国人等
- 《荒野大镖客》PC版曝光!《GTA6》疑似也有PC版
- 林宥嘉.2008-神秘嘉宾(引进版)【华研国际】【WAV+CUE】
- 徐小凤.1997-金曲精选(康艺经典珍藏系列)【康艺成音】【WAV+CUE】
- 群星.1994-非常精丫宝丽金】【WAV+CUE】
- 《赛马娘 热血喧闹大感谢祭!》评测:现代复古派对
- 《星球大战:亡命之徒》评测:还是看看远方的光剑吧