📄 addequip.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*, java.util.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<%!
Connection con=null;
int iNewEquipmentID;
String sNewEquipmentName = null;
java.sql.Date sBouDate = null;
Calendar rightNow = null;
java.util.Date now=null;
int iEquipmentPurchaser;
int iEquipmentRoomNo;
int iDr_id;
String sDeptBelong = null;
String sEquipDetails=null;
%>
<body>
<%
out.print("adsfjasl;fja;lsfj;lask");
try{
iNewEquipmentID = Integer.parseInt(request.getParameter("EquipmentID"));
sNewEquipmentName = request.getParameter("EquipmentName");
rightNow = Calendar.getInstance();
now=rightNow.getTime();
sBouDate = new java.sql.Date(now.getTime());
iEquipmentPurchaser = Integer.parseInt(request.getParameter("EquipmentPurchaser"));
iEquipmentRoomNo = Integer.parseInt(request.getParameter("EquipmentRoomNo"));
iDr_id = Integer.parseInt(request.getParameter("EquipmentManager"));
sDeptBelong = request.getParameter("DeptBelong");
sEquipDetails = request.getParameter("EquipDetails");
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql:///lenovo_db?user=root&password=amethyst");
PreparedStatement ps=con.prepareStatement("insert into equipment values(?,?,?,?,?,?,?,?)");
ps.setInt(1,iNewEquipmentID);
ps.setInt(2,iDr_id);
ps.setString(3,sNewEquipmentName);
ps.setDate(4,sBouDate);
ps.setString(5,sDeptBelong);
ps.setInt(6,iEquipmentPurchaser);
ps.setInt(7,iEquipmentRoomNo);
ps.setString(8,sEquipDetails);
System.out.println("test!!!!!!!!!!!");
ps.executeUpdate();
ps.close();
out.println("Successfully Inserted!");
System.out.println("The equipment ID is:"+iNewEquipmentID);
%>
<br><a href="../ljx/AddEquipment.html">Back</a>
<%
}
catch(Exception e){ out.println("Insert Failed!");}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -