📄 bookmarkadd.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.io.*,java.text.*,java.util.*,java.sql.*,DBstep.iDBManager2000.*" %>
<html>
<head>
<title>标签管理</title>
<link rel='stylesheet' type='text/css' href='../test.css'>
</head>
<body bgcolor="#ffffff">
<div align="center"><font size=4 color=ff0000>标签管理〖标签保存〗</font></div>
<hr size=1>
<br>
<%
int mBookMarkID;
String mBookMarkName=new String(request.getParameter("BookMarkName").getBytes("8859_1"));
String mBookMarkDesc=new String(request.getParameter("BookMarkDesc").getBytes("8859_1"));
String mBookMarkText=new String(request.getParameter("BookMarkText").getBytes("8859_1"));
boolean mResult=false;
DBstep.iDBManager2000 DbaObj=new DBstep.iDBManager2000();
if (DbaObj.OpenConnection())
{
String mSql="select BookMarkName from BookMarks where BookMarkName='" + mBookMarkName + "'";
try
{
ResultSet result=DbaObj.ExecuteQuery(mSql) ;
if (result.next())
{
out.write("保存失败，数据库中已存在相同的标签〖"+mBookMarkName+"〗<input type='button' value='返 回' onclick='javascript:history.back();'");
mResult=false;
}
else
{
mBookMarkID=DbaObj.GetMaxID("BookMarks","BookMarkID");
java.sql.PreparedStatement prestmt=null;
mSql="Insert Into BookMarks (BookMarkID,BookMarkName,BookMarkDesc,BookMarkText) values ('" +String.valueOf(mBookMarkID) + "','" + mBookMarkName + "','" + mBookMarkDesc + "','" + mBookMarkText + "')";
prestmt =DbaObj.Conn.prepareStatement(mSql);;
DbaObj.Conn.setAutoCommit(true) ;
prestmt.execute();
DbaObj.Conn.commit();
prestmt.close();
mResult=true;
}
result.close();
}
catch(Exception e)
{
System.out.println(e.toString());
}
DbaObj.CloseConnection() ;
}
if (mResult)
{
response.sendRedirect("BookMarkList.jsp");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -