JavaEE第一次实验复习servlet,JDBC
2021/9/14 14:05:33
本文主要是介绍JavaEE第一次实验复习servlet,JDBC，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！
实验1
1.运行截图
2.代码
- 结构图
2.bean
package com.ding.bean;
/**
* @Description TODO
* @Author 丁帅帅
* @Date 21/09/11 18:56
* @Version 1.0
*/
public class Add {
private int a;
private int b;
public Add() {
}
public Add(int a, int b) {
this.a = a;
this.b = b;
}
public int getA() {
return a;
}
public void setA(int a) {
this.a = a;
}
public int getB() {
return b;
}
public void setB(int b) {
this.b = b;
}
public int sum(){
int c,s=0;
if(a>b){
c=a;
a=b;
b=c;
}
for(int x=a;x<=b;++x){
s+=x;
}
return s;
}
@Override
public String toString() {
return
"a=" + a +
", b=" + b +",a+...+b="+sum();
}
}
3.controller
package com.ding.controller;
import com.ding.bean.Add;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
/**
* @Description TODO
* @Author 丁帅帅
* @Date 21/09/11 18:33
* @Version 1.0
*/
public class Chuli extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setCharacterEncoding("UTF-8");
String s1=req.getParameter("shuju1");
String s2=req.getParameter("shuju2");
int d1=Integer.parseInt(s1);
int d2=Integer.parseInt(s2);
Add two =new Add(d1,d2);
String sum=two.toString();
req.setAttribute("sum",sum);
req.getRequestDispatcher("show.jsp").forward(req,resp);
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
super.doPost(req, resp);
}
}
4.web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<servlet>
<servlet-name>default</servlet-name>
<servlet-class>com.ding.controller.Chuli</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>/chuli</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>input.jsp</welcome-file>
</welcome-file-list>
</web-app>
5.input.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<form action="chuli" method="post">
数据1:<input name="shuju1"/><br>
数据2:<input name="shuju2"/><br>
<input type="submit" value="提交"/>
</form>
</body>
</html>
6.show.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>展示页面</title>
</head>
<body>
<%
Object sum = request.getAttribute("sum");
out.print(sum);
%>
</body>
</html>
实验2
1.运行截图
2.代码
1.结构图
2.bean
package com.ding.bean;
/**
* @Description TODO
* @Author 丁帅帅
* @Date 21/09/11 19:52
* @Version 1.0
*/
public class Student {
private int id;
private String username;
private String userpassword;
public Student(int id, String username, String userpassword) {
this.id = id;
this.username = username;
this.userpassword = userpassword;
}
public Student() {
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserpassword() {
return userpassword;
}
public void setUserpassword(String userpassword) {
this.userpassword = userpassword;
}
}
3.controller
package com.ding.controller;
import com.ding.dao.UserDao;
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;
@WebServlet("/loginCheck")
public class LoginCheck extends HttpServlet{
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String uname=req.getParameter("uname");
String pwd=req.getParameter("pwd") ;
UserDao ud =new UserDao();
boolean flag=ud.login(uname,pwd);
if(flag) {
req.setAttribute("name", uname);
req.getRequestDispatcher("welcome.jsp").forward(req, resp);
}
else {
req.getRequestDispatcher("login.jsp").forward(req, resp);
}
}
}
4.dao
package com.ding.dao;
import com.ding.utis.JDBCUtils;
import sun.security.util.Password;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* @Description TODO
* @Author 丁帅帅
* @Date 21/09/11 20:13
* @Version 1.0
*/
public class UserDao {
private Connection conn=null;
private PreparedStatement pstmt=null;
private ResultSet rs=null;
public boolean login(String name, String password) {
try {
conn=JDBCUtils.getConnection();
String sql="select *from student where name=? and password=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,name);
pstmt.setString(2,password);
rs=pstmt.executeQuery();
/*
* if(rs.next()) { return true; }else { return false; }
*/
return rs.next();
} catch (SQLException e) {
e.printStackTrace();
}finally {
JDBCUtils.close(rs, pstmt, conn);
}
return false;
}
}
5.utis
package com.ding.utis;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
/**
* @Description TODO
* @Author 丁帅帅
* @Date 21/09/11 20:08
* @Version 1.0
*/
public class JDBCUtils {
private static String url;
private static String user;
private static String password;
private static String driver;
static {
try {
Properties pro =new Properties();
ClassLoader classLoader=JDBCUtils.class.getClassLoader();
URL res=classLoader.getResource("jdbc.properties");
String path=res.getPath();
pro.load(new FileReader(path));
url=pro.getProperty("url");
user=pro.getProperty("user");
password=pro.getProperty("password");
driver=pro.getProperty("driver");
Class.forName(driver);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url,user,password);
}
public static void close(Statement stmt,Connection conn) {
if(stmt!=null) {
try {
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(conn!=null) {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
public static void close(ResultSet rs, Statement pstmt, Connection conn) {
if(rs!=null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(pstmt!=null) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
if(conn!=null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
6.login
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<form action="loginCheck" method="post">
姓名:<input type="text" name="uname"><br>
密码:<input type="password" name="pwd"><br>
<input type="submit" value="登录"><br>
</form>
</body>
</html>
7.welcome
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h1>欢迎${requestScope.name}登录成功!!!</h1>
</body>
</html>
这篇关于JavaEE第一次实验复习servlet,JDBC的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
- 2024-05-13TiDB + ES：转转业财系统亿级数据存储优化实践
- 2024-05-09“2024鸿蒙零基础快速实战-仿抖音App开发（ArkTS版）”实战课程已上线
- 2024-05-09聊聊如何通过arthas-tunnel-server来远程管理所有需要arthas监控的应用
- 2024-05-09log4j2这么配就对了
- 2024-05-09nginx修改Content-Type
- 2024-05-09Redis多数据源，看这篇就够了
- 2024-05-09Google Chrome驱动程序 124.0.6367.62（正式版本）去哪下载？
- 2024-05-09有没有大佬知道这种数据应该怎么抓取呀？
- 2024-05-09这种运行结果里的10.100000001，怎么能最快改成10.1？
- 2024-05-09企业src漏洞挖掘-有意思的命令执行
