📄 updatestorage.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.util.Date"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Insert title here</title>
</head>
<body>
<%
//设定获取的参数的字符编码
request.setCharacterEncoding("gb2312");
//获取参数的值
String txtCode= request.getParameter("txtCode");
String txtName = request.getParameter("txtName");
String txtCapability = request.getParameter("txtCapability");
String DoType = request.getParameter("do");
//写入数据
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection cn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:name","Scott","Tiger");
String sqlStr;
if (DoType.equals("New"))
{
sqlStr = "Insert into Storage values(Seq_Storage.NextVal,?,?,?,sysdate)";
}
else if (DoType.equals("Edit"))
{
sqlStr = "Update Storage ";
sqlStr += "Set Name ='"+txtName+"',";
sqlStr += "Capability ="+txtCapability+" ";
//最后一行不要多了逗号,可以先在oracl中编译
sqlStr += "Where Code = '"+txtCode+"'";
}
else
{
String id = request.getParameter("PID");
sqlStr = "Delete From Storage Where StorID = "+id;
}
PreparedStatement pstmt = cn.prepareStatement(sqlStr);
if (DoType.equals("New"))
{
pstmt.setString(1,txtCode);
pstmt.setString(2,txtName);
pstmt.setInt(3,Integer.parseInt(txtCapability));
//pstmt.setString(15,session.getAttribute("UserName").toString());不能有因为没有这一列
}
else if (DoType.equals("Edit"))
{
}
else
{
}
pstmt.execute();
out.println(sqlStr);
pstmt.close();
cn.close();
response.sendRedirect("Storage.jsp");
}
catch(Exception e)
{
out.println("系统出错了，呵呵~~~~，原因："+e.getMessage());
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -