TYUT太原理工大学2022javaweb编程大题_太原理工大学javaweb

作者：知新_RL | 2024-06-02 06:17:42

踩

太原理工大学javaweb

MVC操作（30分）

听说考学生注册，那我就浅把用户注册改成学生注册

编程题就是给你一个表，几个jsp页面的显示图，让你根据题意写出MVC编码

其中，MVC包含了3部分：

1、视图（V）——编写jsp页面（HTML、CSS代码）

2、模型（M）——编写javabean.java（字符串处理、数据库操作）

3、控制器（C）——编写servlet.java（封装对HTTP请求的处理）

主要出的题型就这么几类：用户注册、用户登录、用户留言、图书管理

题目简单的话，只会要求我们补充MVC，难一点的话会让我们写全部的MVC，这次大题30分，估计难一点

大家能理解的理解，理解不了就背下来（都是手打的代码，难免出错，出错的代码段大家评论区告我）

学生注册：

1、jsp：

（1）addStudent.jsp:


<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<html>
    <head>
        <title>网页左上角要写的标题</title>
    </head>
    <body>
        <h3>学生注册</h3>
        <form action="StudentServlet" method="post">
        学生姓名：<input type="text" name="name" /><br/><br/>
        学生年龄：<input type="text" name="age" /><br/><br/>
        <input type="submit" value="提交"/>
        <input type="reset" value="重置"/>
        </form>
    </body>
</html>

（2）addStudentSuccess.jsp:


<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<html>
    <head>
        <title>网页左上角要写的标题</title>
    </head>
    <body>
        学生注册成功<br/>
        学生姓名：${requestScope.name}<br/>
        学生年龄：${requestScope.age}<br/>
        <a href="addStudent.jsp">再次注册</a>
    </body>
</html>

2、javabean:


import java.sql.*;
public class StudentBean{
    private Integer id;
    private String name;
    private String age;
    public Integer getId(){
        return id;
    }   
    public void setId(Integer id){
        this.id=id;
    }           
    public String getName(){
        return name;
    }   
    public void setName(String name){
        this.name=name;
    }           
    public String getAge(){
        return age;
    }   
    public void setAge(String age){
        this.age=age;
    }    
 	public boolean insortStudent(StudentBean student){
 		Integer id=student.getId();
 		String name=student.getName();
 		String age=student.getAge();
 		try{
 		Class.forName("com.mysql.jdbc.Driver");
 		String url="jdbc:mysql://localhost:3306/jdbc1";
 		Connection conn=DriverManager.getConnection(url,"root","123");
 		String sql="insert into student(name,age)values(?,?)"
 		PreparedStatement ps=conn.prepareStatement(sql);
 		ps.setString(1,name);
 		ps.setString(2,age);
 		int result=ps.executeUpdate();
 		if(result>0)
 			return true;
 		else
 			return false;
 		}catch(Exception e)
 			{e.printStackTrace();}
 		return false;		
 	}
}

3、servlet：


import java.io.IOException;
import javax.servlet.*;
import edu.tyut.bean.StudentServlet;
@WebServlet("/StudentServlet")
public class StudentServlet extends HttpServlet{
	protected void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
		request.setCharacterEncoding("UTF-8");
		String name=request.getParameter("name");
		String age=request.getParameter("age");
		
		StudentBean student=new StudentBean();
		student.setName(name);
		student.setAge(age);
		boolean result=student.insortStudent(student);
		if(result)
			response.sendRedirect("addStudentSuccess.jsp");
		else
			response.sendRedirect("addStudent.jsp");
	}
	protected void doPost(HttpServletRequest request,HttpServletResponse)throws ServletException,IOException{
		doGet(request,response);
	}
}

用户留言：

1、jsp：

（1）addMessage.jsp:


<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<html>
    <head>
        <title>网页左上角要写的标题</title>
    </head>
    <body>
        <h3>用户留言</h3>
        <form action="MessageServlet" method="post">
        昵称：<input type="text" name="nickname" /><br/><br/>
        主题：<input type="text" name="title" /><br/><br/>
        内容：<br/>
        <textarea rows="5" cols="25" name="content"></textarea><br/><br/>
        <input type="submit" value="留言"/>
        <input type="reset" value="重置"/>
        </form>
    </body>
</html>

（2）addMessageSuccess.jsp:


<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<html>
    <head>
        <title>网页左上角要写的标题</title>
    </head>
    <body>
        <h3>添加留言成功！<a href="addMessage.jsp">再次留言</a></h3>
    </body>
</html>

2、javabean:


import java.sql.*;
public class MessageBean{
    private Integer id;
    private String nickname;
    private String title;
    private String content;
    public Integer getId(){
        return id;
    }   
    public void setId(Integer id){
        this.id=id;
    }           
    public String getNickname(){
        return nickname;
    }   
    public void setNickname(String nickname){
        this.nickname=nickname;
    }    
//......剩下的getter和setter方法省略，考试自己写上
 	public boolean addMessage(MessageBean message){
 		Integer id=message.getId();
 		String title=message.getTitle();
 		//......剩下两个省略，考试写
 		try{
 		Class.forName("com.mysql.jdbc.Driver");
 		String url="jdbc:mysql://localhost:3306/jdbc1";
 		Connection conn=DriverManager.getConnection(url,"root","123");
 		String sql="insert into message(nickname,title,content)values(?,?,?)"
 		PreparedStatement ps=conn.prepareStatement(sql);
 		ps.setString(1,nickname);
 		ps.setString(2,title);
 		ps.setString(3,content);
 		int result=ps.executeUpdate();
 		if(result>0)
 			return true;
 		else
 			return false;
 		}catch(Exception e)
 			{e.printStackTrace();}
 		return false;		
 	}
}

3、servlet：


import java.io.IOException;
import javax.servlet.*;
import edu.tyut.bean.MessageBean;
@WebServlet("/MessageServlet")
public class MessageServlet extends HttpServlet{
	protected void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
		request.setCharacterEncoding("UTF-8");
		String nickname=request.getParameter("nickname");
		String title=request.getParameter("title");
		String content=request.getParameter("content");
		
		MessageBean message=new MessageBean();
		message.setNickname(nickname);
		message.setTitle(title);
		message.setContent(content);
		boolean result=message.addMessage(message);
		if(result)
			response.sendRedirect("addMessageSuccess.jsp");
		else
			response.sendRedirect("addMessage.jsp");
	}
	protected void doPost(HttpServletRequest request,HttpServletResponse)throws ServletException,IOException{
		doGet(request,response);
	}
}

用户登录：

1、jsp：

（1）login.jsp:


<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<html>
    <head>
        <title>网页左上角要写的标题</title>
    </head>
    <body>
        <h3>用户登录</h3>
        <form action="LoginServlet" method="post">
        用户名：<input type="text" name="name" /><br/><br/>
        密码：<input type="text" name="password" /><br/><br/>
        <input type="submit" value="登录"/>
        <input type="reset" value="重置"/>
        </form>
    </body>
</html>

（2）

loginSuccess.jsp:


<%@ page language="java" contentType="text/html;charset=UTF-8" pageEncoding="UTF-8" %>
<html>
    <head>
        <title>网页左上角要写的标题</title>
    </head>
    <body>
        <h3>登录成功<a href="login.jsp">再次注册</a></h3>
    </body>
</html>

2、javabean:


import java.sql.*;
public class UserBean{
    private Integer id;
    private String name;
    private String password;
    public Integer getId(){
        return id;
    }   
    public void setId(Integer 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 boolean loginUser(UserBean user){
 		Integer id=user.getId();
 		String name=user.getName();
 		String password=user.getPassword();
 		try{
 		Class.forName("com.mysql.jdbc.Driver");
 		String url="jdbc:mysql://localhost:3306/jdbc1";
 		Connection conn=DriverManager.getConnection(url,"root","123");
 		String sql="select*from user where name=? and password=?";
        //这个loginUser（）方法我写的有些问题，先别参考
 		PreparedStatement ps=conn.prepareStatement(sql);
 		ps.setString(1,name);
 		ps.setString(2,password);
 		int result=ps.executeUpdate();
 		if(result>0)
 			return true;
 		else
 			return false;
 		}catch(Exception e)
 			{e.printStackTrace();}
 		return false;		
 	}
}

3、servlet：


import java.io.IOException;
import javax.servlet.*;
import edu.tyut.bean.LoginServlet;
@WebServlet("/LoginServlet")
public class LoginServlet extends HttpServlet{
	protected void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException{
		request.setCharacterEncoding("UTF-8");
		String name=request.getParameter("name");
		String password=request.getParameter("password");
		
		UserBean user=new UserBean();
		user.setName(name);
		user.setPassword(password);
		boolean result=user.loginUser(user);
		if(result)
			response.sendRedirect("loginSuccess.jsp");
		else
			response.sendRedirect("login.jsp");
	}
	protected void doPost(HttpServletRequest request,HttpServletResponse)throws ServletException,IOException{
		doGet(request,response);
	}
}

整体看下来，其实MVC的题型大同小异，我们只需要根据题意，将几个必要的参数修改即可

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/知新_RL/article/detail/661537