JSP中使用JDBC操作数据库

原创已于 2022-04-18 16:46:27 修改 · 4.8k 阅读

14 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #jsp #java #数据库

于 2017-02-28 16:50:49 首次发布

JAVA 同时被 3 个专栏收录

140 篇文章

订阅专栏

JSP

39 篇文章

订阅专栏

MySQL

25 篇文章

订阅专栏

随时随地阅读更多技术实战干货，获取项目源码、学习资料，请关注源代码社区公众号(ydmsq666)

实体类，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：

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

<%@page import="java.net.URLDecoder"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>添加图书</title>
</head>
<body>

	<form action="result.jsp" method="post" onsubmit="return check(this);">
		<table align="center" width="450">

			<tr>
				<td align="center" colspan="2">
					<h2>添加图书信息</h2>
				</td>
			</tr>

			<tr>
				<td align="right">图书名称：</td>
				<td><input type="text" name="name" /></td>
			</tr>

			<tr>
				<td align="right">价 格：</td>
				<td><input type="text" name="price" /></td>
			</tr>

			<tr>
				<td align="right">数 量：</td>
				<td><input type="text" name="bookCount" /></td>
			</tr>

			<tr>
				<td align="right">作 者：</td>
				<td><input type="text" name="author" /></td>
			</tr>

			<tr>
				<td align="center" colspan="2"><input type="submit"
					value="添   加" /></td>
			</tr>

		</table>
	</form>

</body>
</html>

result.jsp：

<%@page import="java.sql.*"%>
<%@ page language="java" import="java.util.*" autoFlush="true"
	import="com.home.web.mamager.*" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>

	<%
	    request.setCharacterEncoding("UTF-8");
	%>

	<jsp:useBean id="book" class="com.home.web.dto.Book"></jsp:useBean>
	<jsp:setProperty property="*" name="book" />

	<%
	    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();
	    }
	%>
	
	<br>
	
	<a href="index.jsp">返回</a>

</body>
</html>