package action;

import java.io.IOException;
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.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import actionform.LoginActform;
//鐧婚檰 action
public class LoginAct extends Action{

	public ActionForward execute(ActionMapping mapping,ActionForm form,
			HttpServletRequest request,HttpServletResponse response)
	throws IOException,ServletException{

		LoginActform myForm=(LoginActform)form;
		String susername=myForm.getUsername();
		String spassword=myForm.getPassword();
		HttpSession session=request.getSession(true);
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn=DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@localhost:1521:database");
			String sql="select *from usermsg where username='"+susername+"' and password='"+spassword+"'";
			PreparedStatement ps=conn.prepareStatement(sql);
			ResultSet rs=ps.executeQuery();
			if(rs.next()){
				return mapping.findForward("success");
			}else{
				session.setAttribute("message", "綆＄悊鍛樼敤鎴峰悕鎴栧瘑鐮佽緭鍏ユ湁璇