📄 savenopic.jsp

📁 本人用ＪＳＰ编写的一个网站程序

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.net.*,java.text.*,java.util.Date,java.lang.*,java.sql.*,java.io.*,java.util.Calendar,java.util.*" errorPage="" %>
<%@ include file="conn.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body >
<%
	String sql=null;
	
//得到上传时间
	java.util.Calendar curTime = java.util.Calendar.getInstance();
	int yr = curTime.get(Calendar.YEAR);
	int mn = curTime.get(Calendar.MONTH);
	mn = mn + 1;
	int dt = curTime.get(Calendar.DAY_OF_MONTH);
	int hr = curTime.get(Calendar.HOUR_OF_DAY);
	int mi = curTime.get(Calendar.MINUTE);
	int se = curTime.get(Calendar.SECOND);
	String timeStr =  yr+""+mn+""+dt+""+hr+""+mi+""+se;
	String buildtime = yr+"-"+mn+"-"+dt+" "+hr+":"+mi+":"+se;
	String	path = "nopic";

        String title = request.getParameter("title");
	title = new String(title.getBytes("ISO8859_1"),"GBK");
        String content = request.getParameter("content");
	content = new String(content.getBytes("ISO8859_1"),"GBK");
	out.print(title);
	out.print(content);
	out.print(path);
    PreparedStatement prestmt=null;
try{
sql="insert  into  news ( title, content, pic, buildtime) values  (?,?,?,?)";  
prestmt=conn.prepareStatement(sql);
prestmt.setBytes(1,title.getBytes("GBK"));
prestmt.setBytes(2,content.getBytes("GBK"));
prestmt.setBytes(3,path.getBytes("GBK"));
prestmt.setBytes(4,buildtime.getBytes("GBK"));
prestmt.executeUpdate();
prestmt.close();
stmt.close(); 
conn.close(); 
response.sendRedirect("newslist.jsp");
}catch(java.sql.SQLException e)
	{
		out.print(e.toString());
		prestmt.close();
		stmt.close(); 
        conn.close(); 
        response.sendRedirect("newslist.jsp");
	}

%> 

</body> 

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -