zhuce.java

网上购书系统 采用jsp+servlet+sql2000

package servlet;


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


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

import base.DaoBase;
import bean.User;

public class Zhuce extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.setContentType("text/html;charset=gbk");
		String username=request.getParameter("username");
		String password=request.getParameter("password");
		User user=new User();
		user.setUsername(username);
		user.setPassword(password);
		DaoBase dao=new DaoBase();
		Connection conn=dao.getConn();
		String sqli="insert into [user] values(?,?)";
		String sqls="select * from [user] where username=?";
		try {
			PreparedStatement pst=conn.prepareStatement(sqls);
			pst.setString(1, user.getUsername());
			ResultSet rs=pst.executeQuery();
			if(rs.next())
			{
				request.setAttribute("s", "sb");
			}
			else
			{
				PreparedStatement ps=conn.prepareStatement(sqli);
				ps.setString(1, user.getUsername());
				ps.setString(2, user.getPassword());
				ps.executeUpdate();
				ps.close();
				request.setAttribute("s", "cg");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		dao.closeConn();
		request.getRequestDispatcher("zhuce.jsp").forward(request, response);
	}

	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		super.doGet(request, response);
	}

}