javaweb(主页新闻展示&&删除&&查看&&修改&&主题绑定）

目录

主页面新闻展示

新闻删除功能

新闻查看功能

新闻修改功能

主题绑定

---

主页面新闻展示

	//数据库交互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)+"&#160;&#160;&#160;&#160; <a href='adminEditNews.jsp?nid="+rs.getInt(1)+"'>修改</a> &#160;&#160;&#160;&#160; <a href='#' onclick='return clickdel("+rs.getInt(1)+")'>删除</a></span> </li><li class='space'></li>");
				}

新闻删除功能

//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>");
	}

新闻查看功能

//定义全局变量存储数据库查询的结果  将来可以通过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);
	}

新闻修改功能

	//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>");
}

主题绑定

//绑定所有的主题
	sql = "select * from tb_t281_news_themes";
	ps = conn.prepareStatement(sql);
	rs = ps.executeQuery();
	while(rs.next()){
		(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>");
		}
	}