userregister.java

J2EE+jsp音乐网站,提供登录

package com.music;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class UserRegister extends HttpServlet {

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html;charset=GB2312");
		PrintWriter out = response.getWriter();
		String Name,Sex,PassWord,PassWords,Email,URL,Tel,Remark;
		String strSql;
		Date Birthday;
		try
		{
			LoadSQL loadsql=new LoadSQL();
			Name=ChangeData(request.getParameter("txtName"));
			Sex=ChangeData(request.getParameter("RaSex"));
			Birthday=java.sql.Date.valueOf(ChangeData(request.getParameter("txtBirthday")));
			PassWord=request.getParameter("txtPassWord");
			PassWords=request.getParameter("txtPassWords");
			Email=ChangeData(request.getParameter("txtEmail"));
			URL=ChangeData(request.getParameter("txtURL"));
			Tel=ChangeData(request.getParameter("txtTel"));
			Remark=ChangeData(request.getParameter("txtRemark"));
		    strSql="insert into UserInfor(UserName,UserSex,PassWord," +
		    "UserBirthday,UserEmail,UserUrl,UserTel,UserRemark" +
		    ") values('"+Name+"','"+Sex+"','"+PassWord+"'," +
		    		"'"+Birthday+"','"+Email+"','"+URL+"'," +
		    				"'"+Tel+"','"+Remark+"')";
		    if(PassWord.equals(PassWords))
		    {
		    	if(loadsql.CheckUser("select * from UserInfor where UserName='"+Name+"'")==0)
		    	{
		    		 loadsql.InsertData(strSql);
		 			out.write("<p align=\"center\">成功把数据保存到数据库中\n</p>");
		    	}
		    	else
		    	{
		    		out.write("<p align=\"center\">用户名已被注册，请选另一用户名返回请重新填写\n</p>");
			    	
		    	}
		    }
		    else
		    {
		    	out.write("<p align=\"center\">两次输入的密码不一致，返回请重新填写</p>");
		    }
			
			
		}
		catch(Exception e)
		{
			out.write("<p align=\"center\">数据插入数据库失败: 请确定你所填的信息是正确的\n </p>" 
					+"<p align=\"center\">信息提示为:" +e.toString()+"</p>");
		}
		out.write("<p align=\"center\"><a href=\"/MusicSite/UserRegister.jsp\">&lt;&lt;返回</a></p>");
	    out.write("<p align=\"center\"><a href=\"/MusicSite/index.jsp\">&lt;&lt;回首页</a></p>");
	    out.write("<p align=\"center\"><a href=\"/MusicSite/LongIn.jsp\">&lt;&lt;登陆</a></p>");
	    
	}
	 public String ChangeData(String str)       //解决中文问题
		{
			byte b[];
			try
			{
				b=str.getBytes("ISO-8859-1");
	            str=new String(b);
	            return str;
			}
			catch(Exception e)
			{
				return "";
			}
		}

}