伙伴们本次学习javaweb绑定和删除和查看
一、绑定
<body>
<div id="header">
<div id="welcome">欢迎使用新闻管理系统!</div>
<div id="nav">
<div id="logo">< img src="/Project01/images/logo.jpg" alt="新闻中国" /></div>
<div id="a_b01">< img src="/Project01/images/a_b01.gif" alt="" /></div>
</div>
</div>
<div id="admin_bar">
<div id="status">管理员: <%=request.getParameter("aa") %>      < a href=" ">退出</ a></div>
<div id="channel"> </div>
</div>
<div id="main">
<div id="opt_list">
<ul>
<li>< a href="/Project01/news/add.jsp">添加新闻</ a></li>
<li>< a href="/Project01/news/admin.jsp">编辑新闻</ a></li>
<li>< a href="#">查找新闻</ a></li>
<li>< a href="/Project01/news/zt.jsp">添加主题</ a></li>
<li>< a href="/Project01/news/ztadmin.jsp">编辑主题</ a></li>
</ul>
</div>
<div id="opt_area">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<script language="javascript">
function clickdel(){
return confirm("删除请点击确认");
}
</script>
<ul class="classlist">
<%
//jdbcl连接oracle查询所有的新闻:id 标题 作者
String CNAME = "oracle.jdbc.driver.OracleDriver";
String URL="jdbc:oracle:thin:@localhost:1521:orcl";
//加载驱动
Class.forName(CNAME);
//创建连接
Connection con = DriverManager.getConnection(URL, "scott", "tiger");
//定义sql语句
String sql = "select nid,ntitle,nauthor from news280 order by nid desc";
//获得执行对象
PreparedStatement ps = con.prepareStatement(sql);
//获得结果集
ResultSet rs = ps.executeQuery();
//循环遍历
while(rs.next()){
%>
<li>< a href="/Project01/news/read.jsp?nid=<%=rs.getInt(1)%>"><%=rs.getString(2) %></ a>
<span> 作者:<%=rs.getString(3) %>     
< a href='/Project01/news/update.jsp?nid=<%=rs.getInt(1)%>'>修改</ a>     
< a href='/Project01/news/dodelete.jsp?nid=<%=rs.getInt(1) %>' onclick='return clickdel()'>删除</ a>
</span>
</li>
<%
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
<li class='space'></li>
<p align="right"> 当前页数:[1/3] < a href="#">下一页</ a> < a href="#">末页</ a> </p >
</ul>
</div>
</div>
<div id="site_link"> < a href="#">关于我们</ a><span>|</span> < a href="#">Aboue Us</ a><span>|</span> < a href="#">联系我们</ a><span>|</span> < a href="#">广告服务</ a><span>|</span> < a href="#">供稿服务</ a><span>|</span> < a href="#">法律声明</ a><span>|</span> < a href="#">招聘信息</ a><span>|</span> < a href="#">网站地图</ a><span>|</span> < a href="#">留言反馈</ a> </div>
<div id="footer">
<p class="">24小时客户服务热线:010-68988888      < a href="#">常见问题解答</ a>      新闻热线:010-627488888<br />
文明办网文明上网举报电话:010-627488888      举报邮箱:< a href="#">jubao@jb-aptech.com.cn</ a></p >
<p class="copyright">Copyright © 1999-2009 News China gov, All Right Reserver<br />
新闻中国 版权所有</p >
</div>
</body>
二、查找
<%
//接收主界面传过来的值
String nid = request.getParameter("nid");
//思路:根据nid拿到起对应的信息
//jdbcl连接oracle查询所有的新闻:id 标题 作者
String CNAME = "oracle.jdbc.driver.OracleDriver";
String URL="jdbc:oracle:thin:@localhost:1521:orcl";
//加载驱动
Class.forName(CNAME);
//创建连接
Connection con = DriverManager.getConnection(URL, "scott", "tiger");
//定义sql语句
String sql = "select * from news280 where nid="+nid;
//获得执行对象
PreparedStatement ps = con.prepareStatement(sql);
//获得结果集
ResultSet rs = ps.executeQuery();
//扩大作用域
String title="";
String author="";
String content="";
String addtime="";
//循环遍历
if(rs.next()){
//赋值
title=rs.getString(3);
author=rs.getString(4);
content=rs.getString(6);
addtime=rs.getString(7);
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
三 、删除
<%
//定义sql语句
sql = "select * from zt order by tid";
//获得执行对象
ps = con.prepareStatement(sql);
//获得结果集
rs = ps.executeQuery();
//循环遍历
while(rs.next()){
//做判断
if(rs.getInt(1)==tid){
out.print("<option selected='selected' value='"+rs.getInt(1)+"'>"+rs.getString(2)+"</option>");//输送到页面
}
else{
out.print("<option value='"+rs.getInt(1)+"'>"+rs.getString(2)+"</option>");//输送到页面
}
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
四、改
<%
//定义sql语句
sql = "select * from zt order by tid";
//获得执行对象
ps = con.prepareStatement(sql);
//获得结果集
rs = ps.executeQuery();
//循环遍历
while(rs.next()){
//做判断
if(rs.getInt(1)==tid){
out.print("<option selected='selected' value='"+rs.getInt(1)+"'>"+rs.getString(2)+"</option>");//输送到页面
}
else{
out.print("<option value='"+rs.getInt(1)+"'>"+rs.getString(2)+"</option>");//输送到页面
}
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
本次的分享到这了后面还有更多分享