<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<%! 
Connection conn=null;
Statement stmt=null;
ResultSet rs;
String sql="";
String str="";

%>
<% 
request.setCharacterEncoding("GBK");

 try{
		String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/jsp/db1.mdb";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	 	conn=DriverManager.getConnection(strurl);
		stmt=conn.createStatement();
		rs=stmt.executeQuery("select * from admin");
	}
	catch(Exception e)
	{
		out.println("語句輸入錯誤!");
	}
	



 %>
 
 <% 
 
  		String name=request.getParameter("User");
		String pwd=request.getParameter("Password");
		boolean b=false;
		while(rs.next())
		{
			if(name.equals(rs.getString("name")) && pwd.equals(rs.getString("pwd")))
			{
				out.println("<a href=newsedit.jsp>驗證成功,點擊進入!</a>");
				b=true;	
			}
		}
		if(!b)
			out.println("用戶名或密碼錯誤！");
%>