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&#