<!-- 功能:显示所有新闻 -->
<%
//数据库交互oracleDriver
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott","123");
//sql
String sql="select *from tb_t281_news";
PreparedStatement ps=conn.prepareStatement(sql);
//返回结果集对象
ResultSet rs=ps.executeQuery();
//遍历
while(rs.next()){
out.print("<li><a href='adminNewsDetail.jsp?nid="+rs.getInt(1)+"'>"+rs.getString(3)+"</a> <span> 作者:"+rs.getString(4)+"     <a href='adminEditNews.jsp?nid="+rs.getInt(1)+"'>修改</a>      <a href='#' οnclick='return clickdel("+rs.getInt(1)+")'>删除</a></span> </li><li class='space'></li>");
}
%>
2.删除
<%
//1.设置reuqest请求的编码格式
request.setCharacterEncoding("utf-8");
//2.获取location拼接的参数 新闻编号
String id = request.getParameter("nid");
int nid = Integer.parseInt(id);
//3.数据库交互 根据获取的新闻编号进行删除
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
//sql
String sql = "delete from tb_t281_news where nid=" + nid;
PreparedStatement ps = conn.prepareStatement(sql);
//返回所影响的行数
int n = ps.executeUpdate();
//4.根据所影响的行数进行判断跳转到指定的页面
if (n > 0) {
out.println("<script>alert('删除成功');location.href='adminHome.jsp'</script>");
} else {
out.println("<script>alert('删除失败');location.href='adminHome.jsp'</script>");
}
%>
3.查看
<%
//定义全局变量存储数据库查询的结果 将来可以通过jsp表达式可以在该页面的任意一个位置进行输出
String ntitle = "";
String ndate = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
int ncount = 0;
//获取新闻编号
//1.设置编码
request.setCharacterEncoding("utf-8");
//2.获取参数
String id = request.getParameter("nid");
int nid = 0;
if (null != id) {
nid = Integer.valueOf(id);//转成int类型 因为数据库number类型
}
//3.数据库交互
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
//sql
String sql = "select * from tb_t281_news where nid = " + nid;
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
//sql 1条记录 没有记录
if (rs.next()) {
ntitle = rs.getString(3);
nauthor = rs.getString(4);
nsummary = rs.getString(5);
ncontent = rs.getString(6);
ndate = rs.getString(8);
ncount = rs.getInt(9);
}
%>
4.修改
<%
//1.设置编码
request.setCharacterEncoding("utf-8");
//2.获取表单提交的值
//新闻编号
String id = request.getParameter("nid");
int nid = 0;
if (null != id) {
nid = Integer.valueOf(id);//转成int类型 因为数据库number类型
}
//新闻分类编号
String tid = request.getParameter("ntid");
int ntid = 0;
if (null != tid) {
ntid = Integer.valueOf(tid);//转成int类型 因为数据库number类型
}
//标题
String ntitle = request.getParameter("ntitle");
//作者
String nauthor = request.getParameter("nauthor");
//摘要
String nsummary = request.getParameter("nsummary");
//内容
String ncontent = request.getParameter("ncontent");
//时间
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String ndate = sdf.format(date);
//点击量 不写
//3.数据库交互修改
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
//sql
String sql = "update tb_t281_news set ntid = ? , ntitle = ? , nauthor = ? , nsummary = ? , ncontent = ? , ndate = to_date(?,'yyyy-mm-dd hh24:mi:ss') where nid = ?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, ntid);
ps.setString(2, ntitle);
ps.setString(3, nauthor);
ps.setString(4, nsummary);
ps.setString(5, ncontent);
ps.setString(6, ndate);
ps.setInt(7, nid);
//返回所影响的行数
int n = ps.executeUpdate();
//4.跳转页面
if (n > 0) {
out.println("<script>alert('修改成功');location.href='adminHome.jsp'</script>");
} else {
out.println("<script>alert('修改失败');location.href='adminHome.jsp?nid=" + nid + "'</script>");
}
%>
5.绑定
<%
//绑定所有的主题
sql = "select * from tb_t281_news_themes";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
if(rs.getInt(1) == ntid){
out.println("<option selected = 'selected' value='"+rs.getInt(1)+"'> "+rs.getString(2)+" </option>");
}else{
out.println("<option value='"+rs.getInt(1)+"'> "+rs.getString(2)+" </option>");
}
}