合肥学院web实验八.docVIP

pressAdd.jsp %@ page language=java contentType=text/html; charset=UTF-8 pageEncoding=UTF-8% %@ page import=java.sql.* % !DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN /TR/html4/loose.dtd html head meta http-equiv=Content-Type content=text/html; charset=UTF-8 script type=text/javascript src=../script/common.js/script title书籍添加/title /head body % Connection conn = null; Statement stm = null; ResultSet rs = null; Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); String url=jdbc:sqlserver://localhost:1433;databasename=bookstore2; conn = DriverManager.getConnection(url,sa,catv); stm = conn.createStatement(); String sql = select * from publisher ; rs = stm.executeQuery(sql); % form action=bookAddProc.jsp name=myForm method=post onsubmit=return checkForm(); table tr td书号/td tdinput type=text name=bookId//td /tr tr td书名/td tdinput type=text name=bookName//td /tr tr td书价/td tdinput type=text name=bookPrice//td /tr tr td出版社/td td select name=publisher option value=0请选择/option % while(rs.next()){ % option value=%=rs.getString(xh) %%=rs.getString(mc) %/option %} % /select /td /tr tr td colspan=2 input type=submit value=保存/nbsp; input type=reset value=重置/ /td /tr /table /form /body /html pressAddpre.jsp %@ page language=java contentType=text/html; charset=UTF-8 pageEncoding=UTF-8% %@ page import=java.sql.* % !DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN /TR/html4/loose.dtd html head meta http-equiv=Content-Type content=text/html; charset=UTF-8 titleInsert title here/title /head body % request.setCharacterEncoding(utf-8); String id = request.getParameter(pressId); String name = request.getParameter(pressName); Connection conn = null; PreparedStatement pstm = null; Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); String url=jdbc:sqlserver://localhos