<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.DataSource" %>
<%@ page import="javax.naming.InitialContext" %>
<%@ page import="javax.naming.NamingException" %>
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=GB2312">
<TITLE>updateTable.jsp</TITLE></HEAD>
<BODY>
<%
Connection conn=null;
try {
request.setCharacterEncoding("GBK");
InitialContext ic=new InitialContext();
DataSource ds=(DataSource)ic.lookup("jdbc/DBConnCoreDS");
conn=ds.getConnection();
if(!conn.isClosed()) {
out.println("数据库连接成功!");
out.println("<BR>");
}
Statement st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs=st.executeQuery("select n.* from emp n");
rs.beforeFirst(); // 把记录指针移到第一个记录之前
out.println("修改前emp表中的记录");
out.println("<BR>");
while(rs.next()) { // 把记录指针移到下一个记录
out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getDouble(3)+" "+rs.getString(4)+" "+rs.getString(5)+ " "+rs.getDouble(6));
out.println("<BR>");
}
rs.absolute(4); // 把记录指针移到第4个记录
rs.deleteRow(); // 删除第4个记录
rs.moveToInsertRow(); // 插入一个新记录
rs.updateString(1,"103");
rs.updateString(2,"吴小丽");
rs.updateString(3,"10");
rs.updateDouble(4,24);
rs.updateString(5,"计划员");
rs.updateDouble(6,1800.00);
rs.insertRow(); // 把新记录插入到数据库中
rs.close();
rs=st.executeQuery("select n.* from emp n");
rs.beforeFirst(); // 把记录指针移到第一个记录之前
out.println("修改后emp表中的记录");
out.println("<BR>");
while(rs.next()) {
out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getDouble(3)+" "+rs.getString(4) +" "+rs.getString(5) +" "+rs.getDouble(6));
out.println("<BR>");
}
rs.close();
st.close();
}
catch (SQLException e) {
out.println("数据库连接错误:" + e);
}
finally {
conn.close();
}
%>
</BODY>
</HTML>
JDBC-API-WEB.rar_JDBC api_JDBC web_jdeveloper_oracle jdbc A_web
版权申诉
197 浏览量
2022-09-21
04:27:29
上传
评论
收藏 6KB RAR 举报
JDBC-API-WEB.rar （6个子文件） 
基于JDBC API的WEB开发 InsertData public_html 
InsertData.jsp 1KB queryMetaData public_html queryMetaData.jsp 1KB getDBInfo public_html getDBInfo.jsp 1KB updateTable public_html updateTable.jsp 2KB bindQuery public_html bindQuery.jsp 2KB
www.pudn.com.txt 218B资源评论
