code077.jsp
1<%@page import="java.sql.PreparedStatement"%> 2<%@page import="java.sql.DriverManager"%> 3<%@page import="java.sql.Connection"%> 4<%@ page language="java" contentType="text/html; charset=UTF-8" 5 pageEncoding="UTF-8"%> 6<!DOCTYPE html> 7<html> 8<head> 9<meta charset="UTF-8"> 10<title>AddBook</title> 11</head> 12<body> 13<% request.setCharacterEncoding("utf-8"); %> 14<jsp:useBean id="book" class="pack02.code075"></jsp:useBean> 15<jsp:setProperty property="*" name="book"/><%-- book类与页面的input控件名称一致，才可用 --%> 16<jsp:setProperty property="name" name="book" param="name"/> 17<jsp:setProperty property="price" name="book" param="price"/> 18<jsp:setProperty property="bookCount" name="book" param="bookCount"/> 19<jsp:setProperty property="author" name="book" param="author"/> 20<% 21try 22{ 23 Class.forName("com.mysql.jdbc.Driver"); 24 String url = "jdbc:mysql://localhost:3306/test"; 25 String user = "root"; 26 String pwd = "mysql123"; 27 Connection conn = DriverManager.getConnection(url,user,pwd); 28 29 String sql = "insert into tb_books(name,price,bookCount,author) values(?,?,?,?)"; 30 PreparedStatement param = conn.prepareStatement(sql); 31 param.setString(1, book.getName()); //preparedStatement下标从1开始 32 param.setDouble(2, book.getPrice()); 33 param.setInt(3, book.getBookCount()); 34 param.setString(4, book.getAuthor()); 35 int row = param.executeUpdate(); 36 37 if(row > 0) 38 { 39 out.println("成功添加了" + row + "条数据"); 40 } 41 param.close(); 42 conn.close(); 43} 44catch(Exception e) 45{ 46 out.println("图书信息添加失败"); 47 e.printStackTrace(); 48} 49%> 50<br> 51<a href="code076.jsp">返回</a> 52<%-- 53create table tb_books ( 54 id int auto_increment not null primary key comment '图书编号', 55 name varchar(45) not null comment '图书名称', 56 price double not null comment '价格', 57 bookCount int not null comment '数量', 58 author varchar(45) not null comment '作者' 59) 60 --%> 61</body> 62</html>