首先应该新建一个配置文件用来放连接jdbc的所需的信息
conflg.properties
<span style="font-size:14px;">driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/javaBook
username=root
password=123456</span>
新建一个class去进行连接数据库
DBUtil.class
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class DBUtil {
private static String driver;
private static String url;
private static String username;
private static String password;
static{
Properties prop = new Properties();
try {
// Reader in = new FileReader("src\\conflg.properties");
prop.load(DBUtil.class.getClassLoader().getResourceAsStream("conflg.properties"));
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
driver = prop.getProperty("driver");
url = prop.getProperty("url");
username = prop.getProperty("username");
password = prop.getProperty("password");
}
public static Connection open(){
try {
Class.forName(driver);
return DriverManager.getConnection(url,username,password);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public static void close(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
login.html 登录页面
<span style="font-size:14px;"><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="MyLogin" method="post">
UserName:<input type="text" name="username"><br/>
Password:<input type="password" name="password"><br/>
<input type="submit" value="Login">
</form>
</body>
</html></span>
<span style="font-size:14px;"><%@ 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">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
welcom,${UserSession.username}
</body>
</html></span>
新建一个class存放用户表的信息
User.class
<span style="font-size:14px;">public class User {
private String username;
private String password;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}</span>
新建一个接口,里面定义一个登入验证的方法
UserDao.interface
public interface UserDao {
public User login(String username,String password);
}
UserDaoImpl.class
<span style="font-size:14px;">import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class UserDaoImpl implements UserDao{
@Override
public User login(String username, String password) {
// TODO Auto-generated method stub
Connection conn = DBUtil.open();
String sql = "select username,password from user where username=? and password=?";
try {
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, password);
ResultSet rs = pstmt.executeQuery();
if(rs.next()){
User u = new User();
u.setUsername(username);
u.setPassword(password);
return u;
}
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}</span><span style="color:#ff0000;font-size:18px;">
</span>
MyLogin.class
<span style="font-size:14px;">import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
/**
* Servlet implementation class MyLogin
*/
@WebServlet("/MyLogin")
public class MyLogin extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public MyLogin() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String username = request.getParameter("username");
String password = request.getParameter("password");
UserDao dao = new UserDaoImpl();
User u = dao.login(username, password);
if(u!=null){
HttpSession session = request.getSession();
session.setAttribute("UserSession", u);
request.getRequestDispatcher("Welcome.jsp").forward(request, response);
}
else{
System.out.println("username or password error,please relog!");
request.getRequestDispatcher("login.html").forward(request, response);
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
</span>
最重要的一点是一定要把mysql的jar包导入到WebContent/WEB-INF/lib下
如果无法导入,可以参考http://dev-song.iteye.com/blog/1290639