📄 edit.jsp

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

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改</title>
</head>

<body>
<% 

String className="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433;DatabaseName = scm";
String user="sa";
String password="000000";
String Myid=request.getParameter("id");
session.setAttribute("id",Myid);


try{
 Class.forName(className);
 Connection con=DriverManager.getConnection(url,user,password);
 Statement stat=con.createStatement();
  String sql="select * from t_orderitem where id='"+Myid+"'";
 ResultSet rs=stat.executeQuery(sql);
 if(rs.next())//一条记录
 {
 String materirel_id=rs.getString(2);
 String materirel=rs.getString(3);
 String amount=rs.getString(4);
 String price=rs.getString(5);
//未结束

 %>

<form name="form1" method="post" action="edit_do.jsp"><div align="center"> 
</div><table width="1111" height="208" border="1" align="center" style="width: 340px;"> 
  <tr> 
    <td width="70" align="center">ID:</td> 
    <td width="300"><input type="text" name="id" value="<%= Myid%>"></td> 
  </tr> 
  <tr> 
    <td align="center">物料号:</td> 
    <td><input type="text" name="materiel_id" value="<%= materirel_id%>"> 
  </tr> 
  <tr> 
    <td align="center">物料:</td> 
    <td><input type="text" name="materiel" value="<%= materirel%>"></td> 
  </tr> 
  <tr> 
    <td align="center">数量:</td> 
    <td><input type="text" name="amount" value="<%= amount%>"></td> 
  </tr> 
  <tr> 
    <td align="center">单价:</td> 
    <td><input type="text" name="price" value="<%= price%>"></td> 
  </tr> 
  </table>
  <br><div align="center"><input type="submit" value="修改"></div> 
   
</form>
<% 

rs.close();
stat.close();
con.close();
   }//结束
}
catch(ClassNotFoundException e)
{out.println(e.toString());}
catch(SQLException e)
{out.println(e.toString());}
 %>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -