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

2023-09-17 14:07:05 73

<%@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)

<%@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中的文字保存换行空格存到数据库的方法

热门推荐

随机推荐