📄 messageupdate.jsp

📁 基于JSP的公交查询系统,很好用的,适于学习,操作语句全在jsp页面里

💻 JSP

字号:

<html>
<head>
<title>发布留言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<%@page import="java.util.*, java.sql.*" contentType="text/html;charset=gb2312" %>
<%@page import="java.text.*"%>
<%@page import="java.util.Data.*" %>

<body>
<% 
   String title=new String(request.getParameter("title").getBytes("ISO8859_1"),"GBK");
   String username=new String(request.getParameter("username").getBytes("ISO8859_1"),"GBK");
   String content=new String(request.getParameter("content").getBytes("ISO8859_1"),"GBK");
  // out.println(content);
    Statement sql=null;
   Connection con=null;
   
  java.util.Calendar calendar = java.util.Calendar.getInstance();
  java.text.SimpleDateFormat formatter1 = new java.text.SimpleDateFormat("yyyy-MM-dd");
  String strDate = formatter1.format(calendar.getTime());
	
	 try{  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		         }
		   catch(ClassNotFoundException e){
			    e.printStackTrace();
		        }
	 try{     
		     con=DriverManager.getConnection("jdbc:odbc:nbos","","");
		     sql=con.createStatement();
			 
		   //
            String condition="insert into Messages(UserName,Title,Content,PostTime) values ('"+username+"','"+title+"','"+content+"','"+strDate+"')";
          
			 sql.executeUpdate(condition);
			 // out.println("a");
             response.sendRedirect("messages.jsp");
	   }
		    
		   
		    
        
		    catch (Exception e){
		    	
		    	e.printStackTrace();
		    }
		    	
	 
	  %>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -