%@ 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>titlenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;input type="text"
name="title" value="a" size="40">
/td>
/tr>
tr>
td>authornbsp;nbsp;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>
%@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>
