JSP中使用JDBC操作数据库

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/u010142437/article/details/58604215

随时随地阅读更多技术实战干货,充分利用闲暇时间,请关注源代码社区公众号和技术交流群。

实体类,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>

 

 

 

 

 

展开阅读全文

没有更多推荐了,返回首页