java.jsp.jdbc_JSP中使用JDBC操作数据库

实体类，Book.java：

package com.home.web.dto;

public class Book {

private int id;

private String name;

private double price;

private int bookCount;

private String author;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public double getPrice() {

return price;

}

public void setPrice(double price) {

this.price = price;

}

public int getBookCount() {

return bookCount;

}

public void setBookCount(int bookCount) {

this.bookCount = bookCount;

}

public String getAuthor() {

return author;

}

public void setAuthor(String author) {

this.author = author;

}

}

index.jsp：

用于放置添加图书信息所需要的表单

pageEncoding="UTF-8"%>

添加图书

添加图书信息
图书名称：
价 格：
数 量：
作 者：
value="添 加" />

result.jsp：

import="com.home.web.mamager.*" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

Insert title here

request.setCharacterEncoding("UTF-8");

%>

try {

Class.forName("com.mysql.jdbc.Driver");

String url="jdbc:mysql://localhost:3306/test";

Connection conn=DriverManager.getConnection(url,"root","123456");

String sql="insert into t_books(name,price,bookCount,author)values(?,?,?,?)";

PreparedStatement ps=conn.prepareStatement(sql);

ps.setString(1, book.getName());

ps.setDouble(2, book.getPrice());

ps.setInt(3, book.getBookCount());

ps.setString(4, book.getAuthor());

int row=ps.executeUpdate();

if(row>0){

out.print("成功添加了"+row+"条数据！");

}

ps.close();

conn.close();

} catch (Exception e) {

out.print("图书信息添加失败！");

e.printStackTrace();

}

%>

返回