dealaddboard.jsp

机械工业出版社的《jsp2.0动态网站开发实例指南》的源代码

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="shop.logBean"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%!
	public String codeString(String s){
		String str=s;
                try{
			byte b[]=str.getBytes("ISO-8859-1");
			str=new String (b);
			return str;
		}catch(Exception e){return str;}
	}
%>
<%
	if(session.isNew()){
		%>
		<jsp:forward page="index.jsp"/>
		<%
	}
	else {
		%>
		<jsp:useBean id="log" class="shop.logBean" scope="session"/>
		<%
		String islog=log.getIslog();
		if(!islog.equals("true")){
			%>
			<jsp:forward page="index.jsp"/>
			<%
		}
		else{
			String title=request.getParameter("title");
			String message=request.getParameter("message");
			if(title==null)title="";
			if(message==null)message="";
			if(title.equals("")&&message.equals("")){
				response.sendRedirect("addboard.jsp");
			}
			else{
				java.util.Date date = new java.util.Date();
				String time=date.toString();
				title=codeString(title);
				message=codeString(message);
  				String fromid=log.getId(); 
				try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     					Connection con=DriverManager.getConnection("jdbc:odbc:myshop","","");
    					Statement sql = con.createStatement();
    					String insert="insert into board values (?,?,?,?);";
        				PreparedStatement pstmt=con.prepareStatement(insert);
        				pstmt.setString(1,time);
        				pstmt.setString(2,message);
        				pstmt.setString(3,fromid);
        				pstmt.setString(4,title);
        				pstmt.executeUpdate();
        				pstmt.close();
       					con.close();
       					response.sendRedirect("board.jsp");
      				}catch(SQLException e){
      					response.sendRedirect("addboard.jsp");

      				}catch(ClassNotFoundException e){
  					response.sendRedirect("addboard.jsp");
  				}
  			}
		}
	}
%>