<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.sql.*"%>
Insert title here
<%
request.setCharacterEncoding("utf-8");
String dlname = request.getParameter("dlname");
String pwd = request.getParameter("pwd");
boolean flag=false;
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=lianxi";
String user = "sa";
String password = "123456";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
String sql = "select * from yonghu where dlname=? and pwd=?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, dlname);
pstmt.setString(2, pwd);
rs=pstmt.executeQuery();
while(rs.next()){
flag=true;
}
rs.close();
pstmt.close();
conn.close();
if(flag==true){
response.sendRedirect("huanying.jsp");
}else{
response.sendRedirect("index.jsp");
}
// if (dlname.equals("aaa") && pwd.equals("123456")) {
// response.sendRedirect("huanying.jsp");
// } else {
// response.sendRedirect("index.jsp");
// }
%>
