dell.jsp

一个bug管理系统

<%@ page contentType="text/html; charset=gb2312" language="java"
	import="java.sql.*" errorPage="" import="java.lang.*"%>
<%
	String host = "localhost";
	String user = "root";
	String pw = "123";
	String db = "numb1";

	String pass = null;
	pass = (String) session.getAttribute("pass");
	if ("y".equals(pass)) {

		Class.forName("com.mysql.jdbc.Driver").newInstance();
		String url = "jdbc:mysql://" + host + "/" + db;
		Connection con = DriverManager.getConnection(url, user, pw);
		Statement st = con.createStatement();
		String sql;

		int showrow, p, no;
		String rw = (String) request.getParameter("showrow");
		String pages = (String) request.getParameter("pages");
		if (rw == null) {
			showrow = 1;
		} else {
			showrow = Integer.parseInt(rw);
		}
		if (pages == null) {
			p = 1;
		} else {
			p = Integer.parseInt(pages);
		}

		for (int i = 1; i <= showrow; i++) {
			no = i + (p - 1) * showrow;
			String del = request.getParameter("del" + no);
			if (del != null) {
		sql = "delete from lyb where id=" + del;
		st.executeUpdate(sql);
			}
		}

		st.close();
		con.close();
		response.sendRedirect("index.jsp");
	} else {
		response.sendRedirect("login.jsp");
	}
%>