第一步
创建一个java项目
第二步
创建lib目录并导入jar包
第三步
把jar包添加到library
第四步
进入project structure====>artificts
点击右下角的fix按钮选择add all missing…选项如下图:
第五步
在src目录下设置包,主要有dao、servlet、service、uitl、model五个包
util包:存放工具类,主要用于连接数据库和释放连接。
dao包:存放的类主要用于数据库操作
model包:存放的类主要是各种自定义存放的类,比如user这些自定义的类
service包:存放的类主要起到了逻辑操作层和数据库操作之间的中间作用
servlet包:存放的类起到实现逻辑的功能
第六步
编写model下的user类:
public class User {
private int id;
private String name;
private String password;
private String age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", name='" + name + '\'' +
", password='" + password + '\'' +
", age='" + age + '\'' +
'}';
}
}
编写util包下的DBuitl进行数据库连接:
public class DBUtil {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_test?useSSL=false&autoReconnect=true&serverTimezone=GMT","root","********");
//*****为用户数据库密码
return connection;
}
public static void closeAll(ResultSet rs, PreparedStatement statement, Connection connection){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(statement!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(connection!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
编写dao包下的UserDao:
public class UserDao {
public User selectByName(String name){
ResultSet rs=null;
Connection conn=null;
PreparedStatement pstmt=null;
DBUtil util=new DBUtil();
User user=new User();
try {
conn=util.getConnection();
pstmt=conn.prepareStatement("select * from user where name=?");
pstmt.setString(1,name);
rs=pstmt.executeQuery();
while (rs.next()){
//System.out.println("found");
//System.out.println(rs.getInt(1));
user.setId(rs.getInt(1));
//System.out.println(user.getId());
user.setName(rs.getNString(2));
user.setPassword(rs.getNString(3));
user.setAge(rs.getNString(4));
// System.out.println(user.toString());
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} finally {
util.closeAll(rs,pstmt,conn);
}
return user;
}
}
编写service包下的UserService:
public class UserService {
UserDao userDao=new UserDao();
public User selectByName(String name){
return userDao.selectByName(name);
}
}
servlet下的LoginServlet:
public class LoginServlet extends HttpServlet {
UserService userService=new UserService();
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String name= req.getParameter("name");
String password=req.getParameter("password");
//System.out.println(name+password);
User user=userService.selectByName(name);
//System.out.println(user.toString());
if(password.equals(user.getPassword())){
resp.getWriter().write("success");
}else {
resp.getWriter().write("failed");
}
}
}
在生成的index.jsp下添加html代码:
<html>
<head>
<title>servlet登录跳转</title>
</head>
<body>
<h1>登录界面</h1>
<form action="/login" method="post">
name:<input name="name" type="text">
password:<input name="password" type="password">
<input type="submit" value="登录">
</form>
</body>
</html>
添加web.xml文件内容绑定loginServelt
<servlet>
<servlet-name>loginServlet</servlet-name>
<servlet-class>com.xs1701.servlet.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>loginServlet</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
成果展示
总结
这一次踩了很多坑,很多吃了基础不牢的坑。
①
配置tomcat时这里边的内容没有删干净导致了一直在404,这是tomcat的默认路径导致的删掉即可
②创建对象时没有new导致了一直为空指针
这里的user设置为null结果导致了空指针异常
在打印日志时发现数据库查询到了但是user却一直是null
遂想到是对象没有创建的原因。说到底是吃了基础不牢的亏。