图书管理系统课程设计(4)

Valid.jsp代码：

<%@ page language=\ contentType=\

pageEncoding=\%> <%@ page import=\ %>

<%

String user=request.getParameter(\); String pass=request.getParameter(\); Class.forName(\); Connection

con

=

html

PUBLIC

\

HTML

4.01

Transitional//EN\

\>

DriverManager.getConnection(\,\,\);

PreparedStatement ps =con.prepareStatement(\* from t_account where ps.setString(1,user); ps.setString(2,pass);

ResultSet rs = ps.executeQuery();

username=? and password=?\);

if(rs.next()){response.sendRedirect(\);} else response.sendRedirect(\); %> 添加图书

BookAdd.jsp代码：

<%@ page language=\ contentType=\ pageEncoding=\%>

删除图书

BookDel.jsp代码：

<%@ page language=\ contentType=\

pageEncoding=\%> <%@page import=\%>

<%

//[\

String[] ids = request.getParameterValues(\); Class.forName(\); Connection

con

=

html

PUBLIC

\

HTML

4.01

Transitional//EN\

\>

DriverManager.getConnection(\,\,\);

PreparedStatement ps = con.prepareStatement(\from t_book where for(int i = 0;i

con.close();

ps.setInt(1,Integer.parseInt(ids[i])); ps.execute();

id=?\); %>

正在删除图书，3秒后自动跳转......

bookEdit.jsp代码：

<%@ page language=\ contentType=\ pageEncoding=\%> <%@ page import=\ %>

html

PUBLIC

\

HTML

4.01

Transitional//EN\

\>

<% %>

\> 编辑图书信息

书名：

出版社：

name=\

type=\

id=\

value=\<%=rs.getString(\) %>\>

width=\>

name=\

type=\

id=\

value=\<%=rs.getString(\) %>\>

String strId = request.getParameter(\);//获取传过来的参数（网络上传输

的只能是字符串）

Class.forName(\);//java的反射

Connection

con

=

font-size: 36px; font-weight: bold;

DriverManager.getConnection(\,\,\);

PreparedStatement ps =con.prepareStatement(\ps.setInt(1,Integer.parseInt(strId));

ResultSet rs=ps.executeQuery(); if(rs.next()){

id=?\);