比如我想做个网上书城,我想把封面图片加进去,怎么操作数据库和jsp?
我用的是Myeclipse10 和MySQL,纯小白一个,请多指教
*
``` <%@ page pageEncoding="GBK" import="java.sql.*" %>
<%
request.setCharacterEncoding("GBK");
String id = request.getParameter("id");
String bookname = request.getParameter("bookname");
String author = request.getParameter("author");
String press = request.getParameter("press");
String price = request.getParameter("price");
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?characterEncoding=utf8","root","123456");
String sql="update bookinfo set bookname=?,author=?,press=?,price=? where id=?";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setString(1, bookname);
pstmt.setString(2, author);
pstmt.setString(3, press);
pstmt.setFloat(4, Float.parseFloat(price));
pstmt.setInt(5, Integer.parseInt(id));
int result = pstmt.executeUpdate();
String msg = "修改失败,点击确定跳转到图书列表页!";
if(result == 1){
msg = "修改成功,点击确定跳转到图书列表页!";
}
pstmt.close();
con.close();
%>
<script>window.alert('<%=msg %>');</script>
<%
response.setHeader("Refresh", "1;url=index.jsp");
%>
<%@ page pageEncoding="GBK" import="java.sql.*" %>
<html>
<head>
<title>修改图书信息</title>
<link rel="stylesheet" href="book.css" type="text/css">
<script type="text/javascript" src="book.js"></script>
</head>
<body>
<%
String id = request.getParameter("id");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?characterEncoding=utf8","root","123456");
String sql="select * from bookinfo where id=?";
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setInt(1, Integer.parseInt(id));
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
String bookname = rs.getString("bookname");
String author = rs.getString("author");
String press = rs.getString("press");
float price = rs.getFloat("price");
%>
<h2 align="center">修改图书信息</h2>
<form name="form1" onSubmit="return check()" action="edit_do.jsp" method="post">
<input type="hidden" name="id" value="<%=id %>">
<table align="center" width="30%" border="1">
<tr><th width="30%">书名:</th>
<td><input type="text" name="bookname" value="<%=bookname %>"></td></tr>
<tr><th>作者:</th>
<td><input type="text" name="author" value="<%=author %>"></td></tr>
<tr><th>出版社:</th>
<td><input type="text" name="press" value="<%=press %>"></td></tr>
<tr><th>价格:</th>
<td><input type="text" name="price" value="<%=price %>"></td></tr>
<tr><th colspan="2">
<input type="submit" value="修改">
<input type="reset" value="重置"></th></tr>
</table>
</form>
<%
}
rs.close();
pstmt.close();
con.close();
%>
</body>
</html>