📄 inform.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*, oracle.jdbc.*"%>
<HTML>
<HEAD>
<TITLE></TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
background-color: #CCFF99;
}
-->
</style></HEAD>
<BODY>
<div align="center">测试 OracleDriver</div>
<P>
<%
ResultSet rs = null;
String oracleURL="jdbc:oracle:thin:@zzzz:1521:zzzz";
String oracleUser="scott";
String oraclePass="tiger";
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
}catch (SQLException e){
out.print("Driver Error");
}
try {
Connection conn = DriverManager.getConnection(oracleURL,oracleUser,oraclePass);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select * from moble");
out.println("<table border='2' align='center' width='600'>");
out.println("<tr bgcolor=''><th>品牌</th><th>型号</th><th>是否3G</th><th>外观</th><th>价格(元)</th><th>操作</th></tr>");
while(rs.next()){
out.println("<tr><td width='120'>"+rs.getString(2)+"</td><td width='120'>"+rs.getString(3)+"</td><td width='120'>"+rs.getString(4)+"</td><td width='120'>"+rs.getString(5)+"</td><td width='120'>"+rs.getString(6)+"</td>"+"<td width='120' align='center'><a href='del.jsp?id="+rs.getString(1)+"'>删除"+"</a>"+" "+"<a href='update1.jsp?id="+rs.getString(1)+"'>修改"+"</a></td></tr>");
}
out.println("</table>");
rs.close();
stmt.close();
conn.close();
}catch (SQLException ce){
out.println("产生异常错误!");
out.println(ce);
}
%>
<form name="form1" method="post" action="add.jsp">
<table width="600" border="2" align="center" cellpadding="2" cellspacing="2">
<tr>
<td colspan="2" align="center"><label>
<input type="submit" name="Submit" value="添加">
</label>
<label></label></td>
</tr>
<tr>
<td width="300" align="right">品牌:</td>
<td width="300"><label>
<input type="text" name="pai">
</label></td>
</tr>
<tr>
<td width="300" align="right">型号:</td>
<td width="300"><label>
<input type="text" name="xing">
</label></td>
</tr>
<tr>
<td width="300" align="right">外观:</td>
<td width="300"><label>
<select name="wai">
<option>black</option>
<option>white</option>
<option>blue</option>
</select>
</label></td>
</tr>
<tr>
<td width="300" align="right">是否3G:</td>
<td width="300"><label>
<select name="shi">
<option>Yes</option>
<option selected>No</option>
</select>
</label></td>
</tr>
<tr>
<td width="300" align="right">价格:</td>
<td width="300"><label>
<input type="text" name="jia">
</label></td>
</tr>
</table>
</form>
<P>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -