📄 edit_do.jsp

📁 我们做的J2EE课程设计实验,使用JSF语言编写一个简易的订单系统,麻雀虽小五脏俱全,适合初学者学习J2EE时参考,代码简炼精深,具有一定的参考价值.

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>修改</title>
</head>
<% 
request.setCharacterEncoding("GB2312");
String className="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433;DatabaseName = scm";
String user="sa";
String password="000000";

String id=request.getParameter("id");
String materiel_id=request.getParameter("materiel_id");
String materiel=request.getParameter("materiel"); 
String amount=request.getParameter("amount"); 
String price=request.getParameter("price");   

 
try{
 Class.forName(className);
 Connection con=DriverManager.getConnection(url,user,password);
 Statement stat=con.createStatement();

 String sql="update t_orderitem set id='"+id+"',materiel_id='"+materiel_id+"',materiel='"+materiel+"',amount='"+amount+
   "',price='"+price+"'where id='"+id+"'";
 stat.executeUpdate(sql);
 sql="select amount,price from t_orderitem where id='"+id+"'";
 ResultSet rs=stat.executeQuery(sql);
 if(rs.next())
 {
 	int unit_price=rs.getInt(1)*rs.getInt(2);
 	out.println(unit_price);
 	sql="update t_order set unit_price="+unit_price+" where id='"+id+"'";
 	stat.executeUpdate(sql);
 }
 stat.close();
 con.close();
response.sendRedirect("db.jsp");




}
catch(ClassNotFoundException e)
{out.println(e.toString());}
catch(SQLException e)
{out.println(e.toString());}


%>
<body>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -