jsp实现textarea中的文字保存换行空格存到数据库的方法

内容简介：下面小编就为大家分享一篇jsp实现textarea中的文字保存换行空格存到数据库的方法，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧

UploadNews.jsp

<%@ 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>
<SCRIPT LANGUAGE="JavaScript">
function upload(){
 document.getElementById("article").value = document
 .getElementById("content").value;
 document.getElementById("formid").submit();
 }
</SCRIPT>
</head>
<body>
 <form method="post" action="ShangchuanNews.jsp" id="formid">
  <table border="0" align="center">
   <tr>
    <td>title      <input type="text"
     name="title" value="a" size="40">
    </td>
   </tr>
   <tr>
    <td>author  <input type="text" name="author"
     size="40">
    </td>
   </tr>
   <tr>
    <td><input type="hidden" id="article"
     name="articleName" /></td>
   </tr>
   <tr>
    <td>date(xxxx.xx.xx)<input type="text" name="date" size="40">
    </td>
   </tr>
   <tr>
    <td><div align="center">
      <input type="button" value="submit" class="btn2" onclick = "upload();" />
     </div></td>
   </tr>
   <tr>
    <td><textarea rows="30" cols="80" id="content"></textarea></td>
   </tr>
  </table>
 </form>
</body>
</html>

换行函数在ShangchuanNews.jsp 代码如下

<%@page import="java.io.PrintWriter"%>
<%@page import="java.net.URLDecoder"%>
<%@ page language="java" contentType="text/html; charset=utf-8" 
 pageEncoding="utf-8" %> 
<%@ page import="java.sql.*" %> 
<!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; utf-8"> 
<title>上传新闻</title> 
</head> 
<body> 
<%! // 字符处理函数 换行符变成<br>
public String turn(String str) { 
 while (str.indexOf("\n") != -1) { 
  str = str.substring(0, str.indexOf("\n")) + "<br>" 
    + str.substring(str.indexOf("\n") + 1); 
 } 
 while (str.indexOf(" ") != -1) { 
  str = str.substring(0, str.indexOf(" ")) + "&nbsp" 
    + str.substring(str.indexOf(" ") + 1); 
 } 
 return str; 
} 
%>
<% 
try {
 request.setCharacterEncoding("utf-8");
 String title = request.getParameter("title");
 String author = request.getParameter("author");
 String article = request.getParameter("articleName");
 String articlebr = turn(article);
 String date = request.getParameter("date");
 String driverClass="com.mysql.jdbc.Driver";
 String url = "jdbc:mysql://****.****/****?characterEncoding=utf8";//存到数据库不会乱码
 String user="***"; 
 String password="****";
 Connection conn;
 int i=0;
 Class.forName(driverClass).newInstance();
 conn = DriverManager.getConnection(url,user,password);
 String sql = "insert into news (id,title,author,article,date) "
   + "values(?,?,?,?,?)";
 Connection conn1 = DriverManager.getConnection(url, user, password);
 PreparedStatement pstmt;
 pstmt = (PreparedStatement) conn1.prepareStatement(sql);
 pstmt.setString(1, null);
 pstmt.setString(2, title);
 pstmt.setString(3, author);
 pstmt.setString(4, articlebr);
 pstmt.setString(5, date);
 i = pstmt.executeUpdate();
 conn1.close();
 pstmt.close();
 out.println("<br>上传成功");
} catch (Exception e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
}
%> 
</body> 
</html>

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持码农网

查看所有标签

猜你喜欢:

本站部分资源来源于网络，本站转载出于传递更多信息之目的，版权归原作者或者来源机构所有，如转载稿涉及版权问题，请联系我们。

码农书籍

Head First HTML and CSS

Elisabeth Robson、Eric Freeman / O'Reilly Media / 2012-9-8 / USD 39.99

Tired of reading HTML books that only make sense after you're an expert? Then it's about time you picked up Head First HTML and really learned HTML. You want to learn HTML so you can finally create th......一起来看看《Head First HTML and CSS》这本书的介绍吧!

码农工具