delete_db.jsp

网上书店网站源代码

<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<%! 
    String no=new String();
    String name=new String();
	String author=new String();
	String press=new String();
	String price=new String();
	String note=new String(); 
%>
<% 
       no=request.getParameter("text1");
       name=request.getParameter("text2");
	   author=request.getParameter("text3");
	   press=request.getParameter("text4");
	   price=request.getParameter("text5");
	   note=request.getParameter("text6");
       Connection con;
		Statement st;
		try
		{System.out.println("正在连接数据库");
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:bookstore");
		st=con.createStatement();
		String sql="delete from b_book where b_no='"+no+"'";
		st.executeUpdate(sql);
		System.out.println("已经成功的删除了一条记录");
		st.close();
		con.close();
		}
		catch(Exception e)
		{
			System.out.println(e.toString());
		}
%>
<style type="text/css">
<!--
.style1 {
	font-size: 18px;
	color: #0000FF;
	font-weight: bold;
}
-->
</style>

<span class="style1">恭喜删除成功！！！</span>