JSP操作mysql数据库,添加数据,解决乱码
<%@ 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">
<%@page import="java.sql.Connection" %>
<%@page import="java.sql.DriverManager" %>
<%@page import="java.sql.PreparedStatement" %><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>添加结果</title>
</head>
<body>
<jsp:useBean id="book" class="com.lyq.bean.Book"></jsp:useBean>
<jsp:setProperty property="*" name="book"/>
<%try{Class.forName("com.mysql.jdbc.Driver");// String url="jdbc:mysql://localhost:3306/db_cjky?useUnicode=true&characterEncoding=utf8";String url="jdbc:mysql://localhost:3306/db_cjky";String username="root";String password="123456";Connection conn=DriverManager.getConnection(url,username,password);String sql="insert into tb_books(name,price,bookCount,author)values(?,?,?,?)";PreparedStatement ps=conn.prepareStatement(sql);ps.setString(1, new String(book.getName().getBytes("iso8859-1"),"utf-8"));//存入数据,解决乱码System.out.println("name: "+new String(book.getName().getBytes("iso8859-1"),"utf-8"));ps.setDouble(2, book.getPrice());ps.setInt(3, book.getBookCount());ps.setString(4, new String(book.getAuthor().getBytes("iso8859-1"),"utf-8"));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>