📄 update_do.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>jsp数据库留言板-登陆页面</title>
</head>
<body>
<center>
<h1>留言管理范例-jsp+jdbc实现</h1>
<hr>
<br>
<%
request.setCharacterEncoding("GB2312") ;
if(session.getAttribute("uname")!=null)
{
//用户已登陆
%>
<%!
//声明变量
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String DBurl = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=notes";
String DBuser = "sa";
String DBpassword = "sa";
Connection conn = null;
PreparedStatement prestmt = null;
%>
<%
boolean flag = false;
//String id = request.getParameter("id");
String title = request.getParameter("title");
String author = request.getParameter("author");
String content = request.getParameter("content");
int id = 0;
try
{
id = Integer.parseInt(request.getParameter("id"));
} catch (Exception e)
{
out.println("有误！");
}
%>
<%
//更新note表中的数据
String sql = "update note set title=?,author=?,content=? where id=?";
try
{
Class.forName(DBDriver);
conn = DriverManager.getConnection(DBurl,DBuser,DBpassword);
prestmt = conn.prepareStatement(sql);
//prestmt.setString(1,id);
prestmt.setString(1,title);
prestmt.setString(2,author);
prestmt.setString(3,content);
prestmt.setInt(4,id);
prestmt.executeUpdate();
}
catch (ClassNotFoundException e)
{
out.println("驱动找不着");
e.printStackTrace();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(prestmt != null)
{
prestmt.close();
prestmt = null;
}
if(conn != null)
{
conn.close();
conn = null;
}
flag = true;
}
catch (SQLException e)
{
e.printStackTrace();
}
}
%>
<%
response.setHeader("refresh","2;URL=login_notes.jsp");
if(flag)
{
%>
留言修改成功，两秒后跳转到留言页表！！！<br>
如果没有成功，请按<a href="list_notes.jsp">这里</a>
<%
}
else
{
%>
如果留言修改失败，两秒后跳转到留言页表！！！<br>
如果没有成功，请按<a href="list_notes.jsp">这里</a>
<%
}
%>
<%
}
else
{
//用户未登陆，提示用户登陆,并跳转
response.setHeader("refresh","2;URL=login.jsp");
%>
您还未登陆，请先登陆！！！<br>
两秒后自动跳转到登陆页面！！！<br>
如果没有跳转，请按<a href="login.jsp">这里</a>
<%
}
%>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -