【Javaweb-05】(绑定数据，查看详情，删除，修改)

最新推荐文章于 2023-02-07 16:49:21 发布

自律的藤原拓海

最新推荐文章于 2023-02-07 16:49:21 发布

阅读量130

点赞数

分类专栏： javaWeb 文章标签： eclipse

本文链接：https://blog.csdn.net/ZY_jaychou6/article/details/124772994

版权

javaWeb 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

本文介绍了JavaWeb中如何通过表单、超链接和JavaScript进行页面跳转并传递参数，展示了如何绑定数据库数据，实现查看详情、删除和修改功能。通过示例代码演示了使用JDBC连接Oracle数据库进行CRUD操作。

摘要由CSDN通过智能技术生成

form表单提交后如需传递参数 2种形式

<form action = "1.jsp?password=123" method = "post">
账号: <input type = "text" name = "username"/>


<input type ="hidden" name = "sex" value = "男"/>
<br/><br/>
<input type ="submit" value = "登录"/>
</form>

<hr/>
<h5>不带参数超链接页面跳转</h5>
<a href = "1.jsp">跳转到1.jsp页面</a>
<h5>带参数超链接页面跳转</h5>
<a href = "1.jsp?hobby=打游戏">跳转到1.jsp页面</a>

<hr/>
<button type = "button" onclick = "one()">不带参数跳转</button>
<button type = "button" onclick = "two()">带参数跳转</button>
<script type="text/javascript">
function one(){
//location对象跳转
location.href = "1.jsp";
}
function two(){
location.href = "1.jsp?age=12";
}

</script>

我们一般只要进入到一个网站后，发现就会有相应的消息展示在我们面前，那么这个功能就是我们今天要讲的内容之一：绑定数据

<%
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try{

Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
String sql="select * from tb_t281_news";
ps=conn.prepareStatement(sql);

rs=ps.executeQuery();
while(rs.next()){
%>
<li> <a href="admin_newsDetail.jsp?nid=<%=rs.getInt(1) %>"><%=rs.getString(3)%></a> <span> 作者：<%=rs.getString(4) %>

查看详情
<%
//定义全局变量存储数据库查询的结果将来可以通过jsp表达式可以在该页面的任意一个位置进行输出
String ntitle = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
String ndate = "";
int ncount = 0;


int nid=0;
//1.设置编码格式
request.setCharacterEncoding("utf-8");
//获取传过来的nid
String id=request.getParameter("nid");

if(id!=null){
nid=Integer.valueOf(id);
}

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
String sql="select * from tb_t281_news where nid=? ";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setInt(1, nid);
ResultSet rs=ps.executeQuery();

while(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);
}
%>

得到值后直接嵌套在js代码中

删除
<%
//设置编码格式
request.setCharacterEncoding("utf-8");

String id=request.getParameter("nid");

int nid=0;
if(id!=null){
nid=Integer.valueOf(id);
}


Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
String sql="delete from tb_t281_news where nid="+nid;

PreparedStatement ps=conn.prepareStatement(sql);

int n=ps.executeUpdate();

if(n>0){
out.println("<script>alert('删除成功'); window.location.href='admin.jsp'</script>");
}else {
out.println("<script>alert('删除失败'); window.location.href='admin.jsp'</script>");

}

修改
<%
//1.设置编码格式
request.setCharacterEncoding("utf-8");
//2.获取传过来的值
String id=request.getParameter("nid");
int nid=0;
if(id!=null){
nid=Integer.valueOf(id);
}
int ntid=0;
String ntidd=request.getParameter("ntid");
if(ntidd!=null){
ntid=Integer.valueOf(ntidd);
}
//标题
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);
//点击量
int ncount=0;

Class.forName("oracle.jdbc.driver.OracleDriver");
//2.建立连接
String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn= DriverManager.getConnection(url,"scott", "123");
//3.编写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();
if(n>0){
out.println("<script>alert('修改成功');location.href='admin.jsp'</script>");
}else{
out.println("<script>alert('修改失败');location.href='admin_eaitNews.jsp'</script>");
}