11-15.txt

jsp常用实例讲解

<%@ page language="java" import="java.sql.*"%>
<%-- 连接数据库使用的语句 --%>
<%
String url=new String();
String sql=new String();
url="jdbc:odbc:liuyan";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(url);
%>
<%
Statement stat=conn.createStatement();
String strSql=new String();
String id=request.getParameter("id");
strSql="delete from db2admin.guestbook where serial_no="+id;
stat.executeUpdate(strSql);
response.sendRedirect("manage.jsp");
stat.close();
conn.close();
%>