jsp登录页面---将连接数据库及其方法封装（二）

建立java文件，class的就好，文件名为usermessage，加入下面代码：

 

<span style="font-size:18px;">package action.value;    


public class usermessage {
	private String username;
	private String userpwd;
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getUserpwd() {
		return userpwd;
	}
	public void setUserpwd(String userpwd) {
		this.userpwd = userpwd;
	}


}</span>

建立java文件，名为ConnectionFactory，加入下面代码：

（这个而是连接数据库的代码，health为数据库的名字）

package action.connection;

import java.sql.Connection;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class ConnectionFactory {
	public static Connection getConnection() throws Exception{
		Context ctx=new InitialContext();
		DataSource ds=(DataSource)ctx.lookup("java:comp/env/health");
		return ds.getConnection();
}
}

conn.java文件，代码如下：

（这段代码应该都明白吧，manager是表名，下面是在数据库中查询的一些语句，几乎每种语言的格式都差不多）

package action.conn;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import action.connection.ConnectionFactory;
import action.value.usermessage;
public class conn implements ad {

	public  usermessage userm(String user_id) throws Exception {
		usermessage ms=null;
		String sql="select * from manager where user_id=?";		
		Connection cn=null;
		try{
			cn=ConnectionFactory.getConnection();
			PreparedStatement ps=cn.prepareStatement(sql);
			ps.setString(1,user_id);
			ResultSet rs=ps.executeQuery();
     		while(rs.next())
     		{ 		ms=new usermessage();
     			   ms.setUserpwd(rs.getString("password"));
     		}
     		rs.close();
     		ps.close();
		}catch(Exception e){System.out.print(e.getMessage());}
			cn.close();
		return ms;
	}	
}

ad.java，代码如下：

（这是一个接口，关于接口我个人还不好解释，会在今后进行解释），注意这个文件和上面conn.java 之间的关系。

package action.conn;

import action.value.usermessage;

public interface ad {
	public  usermessage userm(String user_id) throws Exception ;
}

BusinessF.java

package action.conn;


public class BusinessF {
	public static ad createProductBusiness()
	{
		return new conn();
	}

}

test.java

package action;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import action.conn.BusinessF;
import action.conn.ad;


/**
 * Servlet implementation class ssss
 */
@WebServlet("/login.do")
public class test extends HttpServlet {
	private static final long serialVersionUID = 1L;
	
	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public test() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
	    ad ms=BusinessF.createProductBusiness();
		HttpSession session = request.getSession();
		String username=request.getParameter("username");
		String userpwd=request.getParameter("userpwd");
		
		try {
			
			String pwd=ms.userm(username).getUserpwd();
			
			if(userpwd.equals(pwd))
			{
				System.out.println("2225525");
				session.setAttribute("username",username);
				response.sendRedirect("/b/success.jsp");
			}
			else
				response.sendRedirect("/b/fail.jsp");
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	
	}



	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

至此，出了fa.java 和su.java，所有的java文件都已完成，fa与su与我上一篇中的文件内容相同，这里还缺少jsp页面，三个jsp页面也与我上一篇中的jsp页面相同，上一篇《jsp登录页面（一）》，当然，在这里也不要忘了配置web.xml文件哦！！没有说的在上一篇中均有提到