📄 bindquery.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ 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=GBK">
<TITLE>bindQuery.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>");
}
String id[]={"60","70"};
String name[]={"研发部","产品部"};
String location[]={"北京市海淀区10号","沈阳市皇姑区12号"};
float num[]={10,30};
PreparedStatement pst=conn.prepareStatement("insert into dept values(?,?,?,?)");
for(int i=0;i<id.length;i++) {
pst.setString(1,id[i]);
pst.setString(2,name[i]);
pst.setString(3,location[i]);
pst.setFloat(4,num[i]);
pst.executeUpdate();
}
pst.close();
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from dept");
out.println("更新后dept表中的记录");
out.println("<BR>");
while(rs.next()) { // 把记录指针移到下一个记录
out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getFloat(4));
out.println("<BR>");
}
rs.close();
st.close();
}
catch (SQLException e) {
out.println("数据库连接错误:" + e);
}
finally {
conn.close( );
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -