. 超链接上涉及到点击事件,要阻止超链接本身跳转
<!-- <a href='doDeleteNews.jsp?nid=< % =rs.getInt(1)%>'></a> -->
<a href='javascript:void(0)' οnclick='clickdel()'>删除</a>
2.下拉框数据绑定
<%
//定义全局变量,
//int nid=0;
int ntid=0;
String ntitle = "";
String ndate = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
int ncount = 0;
//设置编码格式
request.setCharacterEncoding("utf-8");
//2.获取参数
String id = request.getParameter("nid");
int nid = 0;
if (null != id) {
nid = Integer.valueOf(id);//转成int类型 因为数据库number类型
}
//数据库交互
//加载驱动
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();
if (rs.next()) {
ntid=rs.getInt(2);
ntitle = rs.getString(3);
nauthor = rs.getString(4);
nsummary = rs.getString(5);
ncontent = rs.getString(6);
ndate = rs.getString(8);
ncount = rs.getInt(9);
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>新闻维护--管理后台</title>
<link rel="stylesheet" type="text/css" href="css/admin.css" />
</head>
<body>
<div id="header">
<div id="welcome">欢迎使用新闻管理系统!</div>
<div id="nav">
<div id="logo"><img src="images/logo.jpg" alt="新闻中国" /></div>
<div id="a_b01"><img src="images/a_b01.gif" alt="" /></div>
</div>
</div>
<div id="admin_bar">
<div id="status">管理员: 登录     <a href&