System.out.println(ex.getMessage()); }
return rs;
}
public int executeUpdate(String sql)
{
int result=0;
try{
conn
DriverManager.getConnection(connStr,user,password); stmt = conn.createStatement();
private String password = "091658";
private Connection conn = null;
private Statement stmt = null;
public DBbean()
{
try {
Class.forName(driverStr);
} catch (ClassNotFoundException e) {
{
ResultSet rs = null;
try {
conn
DriverManager.getConnection(connStr,user,password);
stmt = conn.createStatement(); =
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
</tr>
<tr>
<td
bgColor="#808000"> 密码：</td>
<td bgColor="#808000"><input name="password" type="password" id="password"></td>
PreparedStatement ps = con.prepareStatement("select * from t_book");
ResultSet rs = ps.executeQuery();
//每页显示3条,得到总页数st();//游标指针滚动到最后一行int row = rs.getRow();//得到当前记录行数int pages = row%3!=0?row/3+1:row/3;//计算出总页数rs.beforeFirst();//还原到首行之前//定位器
}
public void setUser(String user)
{
er = user;
}
public void setPassword(String password)
{
this.password = password;
}
public ResultSet executeQuery(String sql)
if(strPage!=null){
curPage=Integer.parseInt(strPage);
}
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/bk","root","123");
<!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"> <title>登录图书管理系统</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 36px;
font-weight: bold;
}
-->
</style>
</head>
<body background="image\3.jpg">
<form name="form1" method="get" action="bookDel.jsp">
</table>
</form>
</body>
</html>
3.3.4页面设计
bookList.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<input name="add" type="button" id="add" value="添加图书" onClick="location='bookAdd.jsp'">
<a href="bookList.jsp?page=1">首页</a>
<a href="bookList.jsp?page=<%=curPage-1 %>">上一页</a> <a href="bookList.jsp?page=<%=curPage+1 %>">下一页</a> <a href="bookList.jsp?page=<%=pages %>">尾页</a>
<td><a href="bookEdit.jsp?id=<%=rs.getInt("id")%>">编辑</a></td>
</tr>
<%
}
con.close();
%>
<tr>
<td colspan="6" align="center" bgColor="#ff8000"><input type="submit" name="Submit" value="删除图书">
</td>
</tr>
</table>
</form>
</body>
</html>
1、添加图书信息界面：
bookAdd.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "/TR/html4/loose.dtd">
<table width="600" border="1" align="center" bgColor="#ffffff"> <caption>
<span class="STYLE1"><br><br><br>图书管理面板</span> </caption>
<tr>
<td width="98" bgColor="#808000">全选
<table width="420" height="182" border="0" align="center" bgColor="#c0c0c0">
<caption>
<span class="STYLE1"><br><br><br>登陆图书管理系统<br></span> </caption>
<tr>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>添加图书信息</title>
}
catch(SQLException ex){
System.out.println(ex.getMessage()); }
