具体代码怎么写?
ä¸é¢ç代ç å³å¯å®ç°ï¼å¯¹æ°æ®åºçæä½ï¼ï¼
<%@ pagelanguage="java"
contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
%>
<%@page import="java.sql.*"%>
<center>
<H1> <font color="blue" size="12">管çä¸å¿</font></H1>
<HR />
<table width="80%" border="1">
<tr>
<th>ID</th>
<th>书å</th>
<th>ä½è </th>
<th>ä»·æ ¼</th>
<th>å é¤</th>
</tr>
<%
// æ°æ®åºçåå
String dbName = "zap";
// ç»å½æ°æ®åºçç¨æ·å
String username = "sa";
// ç»å½æ°æ®åºçå¯ç
String password = "123";
// æ°æ®åºçIPå°åï¼æ¬æºå¯ä»¥ç¨ localhost æè 127.0.0.1
String host = "127.0.0.1";
// æ°æ®åºç端å£ï¼ä¸è¬ä¸ä¼ä¿®æ¹ï¼é»è®¤ä¸º1433
int port = 1433;
String connectionUrl = "jdbc:sqlserver://" + host + ":" + port + ";databaseName=" + dbName + ";user=" + username
+ ";password=" + password;
//
//声æéè¦ä½¿ç¨çèµæº
// æ°æ®åºè¿æ¥ï¼è®°å¾ç¨å®äºä¸å®è¦å ³é
Connection con = null;
// Statement è®°å¾ç¨å®äºä¸å®è¦å ³é
Statement stmt = null;
// ç»æéï¼è®°å¾ç¨å®äºä¸å®è¦å ³é
ResultSet rs = null;
try {
// 注å驱å¨
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// è·å¾ä¸ä¸ªæ°æ®åºè¿æ¥
con = DriverManager.getConnection(connectionUrl);
String SQL = "SELECT * from note";
// å建æ¥è¯¢
stmt = con.createStatement();
// æ§è¡æ¥è¯¢ï¼æ¿å°ç»æé
rs = stmt.executeQuery(SQL);
while (rs.next()) {
%>
<tr>
<td>
<%=rs.getInt(1)%>
</td>
<td>
<a href="prepareupdate?ID=<%=rs.getInt("ID")%>" target="_blank"><%=rs.getString(2)%></a>
</td>
<td>
<%=rs.getString(3)%>
</td>
<td>
<%=rs.getString(4)%>
</td>
<td>
<a href="delete?ID=<%=rs.getInt("ID")%>" target="_blank">å é¤</a>
</td>
</tr>
<%
}
} catch (Exception e) {
// æè·å¹¶æ¾ç¤ºå¼å¸¸
e.printStackTrace();
} finally {
// å ³éæ们使ç¨è¿çèµæº
if (rs != null)
try {
rs.close();
} catch (Exception e) {}
if (stmt != null)
try {
stmt.close();
} catch (Exception e) {}
if (con != null)
try {
con.close();
} catch (Exception e) {}
}
%>
</table>
<a href="insert.jsp">æ·»å æ°çºªå½</a>
</center>
温馨提示:答案为网友推荐,仅供参考
第1个回答 2014-06-28
插入是什么 意思? 插入一条记录? 那一般不会放在这里
比如用户id 是 user.id
删除: <a href="url?userid=${user.id}">删除</a> -- url 就是你修改或者删除的方法路径本回答被提问者采纳
比如用户id 是 user.id
删除: <a href="url?userid=${user.id}">删除</a> -- url 就是你修改或者删除的方法路径本回答被提问者采纳