📄 db.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>
<script type="text/JavaScript">
<!--
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>
<body>
<table width="585" border="1" align="center">
<tr>
    <td width="39">操作1</td>
    <td width="44">操作2</td>
	<td width="49"><div align="center">ID</div></td>	
    <td width="55" align="center">物料号<br></td>
    <td width="100"><div align="center">物料</div></td>
    <td width="40"><div align="center">数量</div></td>
    <td width="53"><div align="center">单价</div></td>
    <td width="100"><div align="center">购买者</div></td>
    <td width="53"><div align="center">总价</div></td>
  </tr>
<% 
String className="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433;DatabaseName = scm";
String user="sa";
String password="000000";
try{
 Class.forName(className);
 Connection con=DriverManager.getConnection(url,user,password);
 Statement stat=con.createStatement();
 String sql="select * from t_orderitem,t_order where t_orderitem.id=t_order.id";
 ResultSet rs=stat.executeQuery(sql);
 while(rs.next())
 {
 out.println("<tr><td><a href='edit.jsp?id="+rs.getString(1)+"'>修改</a></td>");
 out.println("<td><a href='delete_do.jsp?id="+rs.getString(1)+"'>删除</a></td>");
 out.println("<td><center>"+rs.getInt(1)+"</center></td>");
 out.println("<td><center>"+rs.getString(2)+"</center></td>");
 out.println("<td><center>"+rs.getString(3)+"</center></td>");
 out.println("<td><center>"+rs.getInt(4)+"</center></td>");
 out.println("<td><center>"+rs.getInt(5)+"</center></td>");
 out.println("<td><center>"+rs.getString(7)+"</center></td>");
 out.println("<td><center>"+rs.getInt(8)+"</center></td></tr>");
 }
 
rs.close();
stat.close();
con.close();

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



 %>
 <tr>
    <td ><div align="center"></div></td>
	 <td><div align="center"></div></td>
	<td><div align="center">
      
	  <input name="Submit" type="submit" onClick="MM_goToURL('parent','insert.html');return document.MM_returnValue" value="加入"  /> 
       
    </div></td>
    <td><div align="center"></div></td>
    <td ><div align="center"></div></td>
    <td ><div align="center"></div></td>
    <td ><div align="center"></div></td>
    <td ><div align="center"></div></td>
    <td ><div align="center"></div></td>
    <td ><div align="center"></div></td>
  </tr>
 
</table>

<br><div align="center"><a href="loginsuccess.jsp">返回主页</a>
</div></body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -