jsp实现textarea中的文字保存换行空格存到数据库的方法
UploadNews.jsp
<%@pagelanguage="java"contentType="text/html;charset=utf-8" pageEncoding="utf-8"%>上传新闻 functionupload(){ document.getElementById("article").value=document .getElementById("content").value; document.getElementById("formid").submit(); } title author date(xxxx.xx.xx)
换行函数在ShangchuanNews.jsp代码如下
<%@pageimport="java.io.PrintWriter"%> <%@pageimport="java.net.URLDecoder"%> <%@pagelanguage="java"contentType="text/html;charset=utf-8" pageEncoding="utf-8"%> <%@pageimport="java.sql.*"%>上传新闻 <%!//字符处理函数换行符变成
publicStringturn(Stringstr){ while(str.indexOf("\n")!=-1){ str=str.substring(0,str.indexOf("\n"))+"
" +str.substring(str.indexOf("\n")+1); } while(str.indexOf("")!=-1){ str=str.substring(0,str.indexOf(""))+" " +str.substring(str.indexOf("")+1); } returnstr; } %> <% try{ request.setCharacterEncoding("utf-8"); Stringtitle=request.getParameter("title"); Stringauthor=request.getParameter("author"); Stringarticle=request.getParameter("articleName"); Stringarticlebr=turn(article); Stringdate=request.getParameter("date"); StringdriverClass="com.mysql.jdbc.Driver"; Stringurl="jdbc:mysql://****.****/****?characterEncoding=utf8";//存到数据库不会乱码 Stringuser="***"; Stringpassword="****"; Connectionconn; inti=0; Class.forName(driverClass).newInstance(); conn=DriverManager.getConnection(url,user,password); Stringsql="insertintonews(id,title,author,article,date)" +"values(?,?,?,?,?)"; Connectionconn1=DriverManager.getConnection(url,user,password); PreparedStatementpstmt; 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("
上传成功"); }catch(Exceptione){ //TODOAuto-generatedcatchblock e.printStackTrace(); } %>
以上这篇jsp实现textarea中的文字保存换行空格存到数据库的方法就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持毛票票。