do_register.jsp

jsp入门级代码

<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="error.jsp" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.ParsePosition" %>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="java.util.Date" %>
<%!
	long getDate(String s)
	{
		SimpleDateFormat simpledateformat = new SimpleDateFormat("yyyy-MM-dd");
		ParsePosition parseposition = new ParsePosition(0);
		Date date = simpledateformat.parse(s, parseposition);
		return date.getTime();
	}
%>
<%
String ID = request.getParameter("ID");
String password = request.getParameter("password");
String rpassword = request.getParameter("rpassword");
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String year = request.getParameter("year");
       if(year.length ==1) year = "0"+year;
String mouth = request.getParameter("mouth");
       if(mouth.length == 1) mouth = "0"+mouth;
String day = request.getParameter("day");
       if(day.length == 1) day =  "0"+day;
String date = year+"-"+mouth+"-"+day;
String description = request.getParameter("description");

Connection con = null;
PreparedStatement psm = null;
ResultSet rs = null;
try
{
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    String url = "jdbc:mysql://localhost/mydb";
    con = DriverManager.getConnection(url,"root","12345");
    psm = con.preparedStatement("insert into users values(?,?,?,?,?,?)");
    psm.setString(1,ID);
	psm.setString(2,password);
	psm.setString(3,name);
	psm.setString(4,sex);
	psm.setLong(5,getDate(date));
	psm.setString(6,descriptioin);
	psm.executeUpdate();
	session.setAttribute("user",ID);
	response.sendRedirect("index.jsp");
}
catch(Exception e){
  response.sendRedirect("register.jsp");
}
 finally
 {
     if(rs!=null){
	    try{ rs.close();}catch(Exception e){e.printStackTrace();}
	  }
     if(psm!=null){
	    try{ psm.close();}catch(Exception e){e.printStackTrace();}
	  }	 
	  if(con!=null){
	    try{ con.close();}catch(Exception e){e.printStackTrace();}
	  } 
}
%>