首先我们通过登录界面进入管理员界面
登录界面的代码在上一次课中已经讲过啦 用户名和密码都在数据库中分别为admin 666
用户名和密码正确之后进入admin界面即完成绑定
绑定(admin)代码:
<ul class="classlist">
<%
//jdbc连接Oracle查询所有的新闻:新闻标题 新闻作者 新闻的编号nid
//OracleDriver;
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";
//获得执行对象
PreparedStatement ps = con.prepareStatement(sql);
//获得结果集
ResultSet rs = ps.executeQuery();
//循坏遍历
while(rs.next()){
%>
<li> <a href="/web05/news/read.jsp?nid=<%=rs.getInt(1)%>"><%=rs.getString(2) %> </a>
<span> 作者: <%=rs.getString(3) %>    
<a href='/web05/news/update.jsp?=nid<%=rs.getInt(1)%>'>修改</a>     
<a href='/web05/news/dodelete.jsp?nid=<%=rs.getInt(1) %>' οnclick='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>
删除:
删除(dodelete) 代码:
<%
//接收nid 根据键拿到值
String nid = request.getParameter("nid");
//jdbc删除 delete form news280 where nid=?
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 = "delete form news280 where nid="+nid;
//获得执行对象
PreparedStatement ps = con.prepareStatement(sql);
//开始执行
int n = ps.executeUpdate();//影响行数
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
//做判断
if(n>0){
//删除成功
response.sendRedirect("/web05/news/admin.jsp");
}
else{//删除失败
out.print("<script>alert('删除失败');location.href='admin.jsp';</script>");
}
%>
查看
查看代码(read)
<body>
<%
//接收主页面传过来的值 nid
String nid = request.getParameter("nid");
//思路:根据nid 拿到对应的信息=单个查询
//jdbc连接Oracle查询所有的新闻:新闻标题 新闻作者 新闻的编号id
//OracleDriver;
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 addtime = "";
String content = "";
//循坏遍历
if(rs.next()){
//赋值
title = rs.getString(3);
author = rs.getString(4);
addtime = rs.getString(7);
content = rs.getString(6);
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
修改(update doupdate)代码:
update:
<%
//思路:跟阅读一致 接收主页面传过来的值 拿到新闻信息 并绑值
//接收主页面传过来的值 nid
String nid = request.getParameter("nid");
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();
//扩大作用域
int tid =0;//主题编号
String title = "";//标题
String author = "";//作者
String summary = "";//摘要
String content = "";//内容
//循坏遍历
if(rs.next()){
//赋值
tid = rs.getInt(2);
title = rs.getString(3);
author = rs.getString(4);
summary = rs.getString(5);
content = rs.getString(6);
}
%>
doupdate:
<%
//设置编码方式
request.setCharacterEncoding("utf-8");
//接收表单提交过来的值
String nid = request.getParameter("nid");//没有传值 隐藏域传值
String ntid=request.getParameter("tid");
String ntitle=request.getParameter("ntitle");
String nauthor=request.getParameter("nauthor");
String nsummary=request.getParameter("nsummary");
String ncontent=request.getParameter("ncontent");
String naddtime=new Date().toLocaleString();//取系统当前时间
//实现修改
String URL="jdbc:oracle:thin:@localhost:1521:orcl";
String CNAME="oracle.jdbc.driver.OracleDriver";
Class.forName(CNAME);
Connection con=DriverManager.getConnection(URL, "scott", "tiger");
String sql="update news280 set tid=?,ntitle=?,nauthor=?,nsummary=?,ncontent=?,naddtime=? where nid=?";
//获得执行对象
PreparedStatement ps=con.prepareStatement(sql);
//给占位符赋值
ps.setInt(1, Integer.parseInt(ntid));
ps.setString(2, ntitle);
ps.setString(3, nauthor);
ps.setString(4, nsummary);
ps.setString(5, ncontent);
ps.setString(6, naddtime);
ps.setInt(7, Integer.parseInt(nid));
//获得影响行数
int n=ps.executeUpdate();
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
//做判断
if(n>0){//说明修改成功
//新闻主界面
response.sendRedirect("/web05/news/admin.jsp");
}
else{//说明修改失败
out.print("<script>alert('修改失败');location.href='update.jsp?nid="+nid+"';</script>");
}
%>