javaWeb作业之前后台交互小Demo

java后台代码：

package util;
/**
 * @author LYB
 * 实现获取连接数据库对象方法类
 */
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

//获取连接数据库对象
public class DBUtil {
	static{
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public static Connection getConnection(String url){
		Connection conn = null;
		Properties pro = null;
		InputStream in = null;
		try {
			pro = new Properties();
			in = new FileInputStream("e:"+File.separator+"info.properties");
			pro.load(in);
			conn = DriverManager.getConnection(url,pro);
		} catch (Exception e) {
			e.printStackTrace();
		}
		  return conn;
	}

}

package myservlet;
/**
 * @author LYB
 * java后台实现登录servlet代码
 */
import java.io.*;
import java.sql.*;

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

import util.DBUtil;

public class LoginServletDemo extends HttpServlet{
	boolean flag = true;
	@Override
	public void init() throws ServletException {
		System.out.println("LoginServlet初始化了...");
	}
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		String name = req.getParameter("username");
		String pwd = req.getParameter("pwd");
		login(name,pwd);
		if(flag){
			//resp.sendRedirect("/WebTest/MyJsp/welcome.jsp");
			req.getRequestDispatcher("/MyJsp/welcome.jsp").forward(req, resp);
		}else{
			//resp.sendRedirect("/WebTest/MyHtml/fail.html");
			req.getRequestDispatcher("/MyHtml/fali.html").forward(req, resp);
		}	
	}
	//用户登录方法
	private void login(String name, String pwd) {
		Connection conn = DBUtil.getConnection("jdbc:mysql://localhost:3306/mydb");
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select * from user where name&#