【JSP】课堂重点回顾

最新推荐文章于 2025-10-06 13:45:00 发布

原创最新推荐文章于 2025-10-06 13:45:00 发布 · 412 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sqlserver #数据库 #microsoft

【复习】专栏收录该内容

12 篇文章

订阅专栏

考试题型

单选题20道（1分）

多选题10道（2分），多选题选到部分答案得一半分，

填空题十个空（2分）

编程题或者程序填空题40分

连接数据库

import java.sql.*;
public class MIKA{
//连接数据库
private final static String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";//数据库驱动Driver
private finalstatic String Url="jdbc:sqlserver://localhost:1433;DatabaseName=mika";
//登录数据库的账号
private final static String userid="sa";
//登录数据库的密码
private final static String pwd="123456";
public Connection getConn(){
Connection conn=null;
try{
Class.forName("Driver");//加载数据库驱动
conn=DriverManager.getConnection(Url,userid,pwd);//建立连接
}catch(Exception e){
System.out.println("驱动加载失败!");
e.printStackTrace();
}
Return conn;
}
public void closeAll(Connection conn){
try{
if(conn!=null){
Conn.close();
}catch(Exception e){
System.out.println("conn关闭失败");
e.printStackTrace();
}
}
}

servlet编写计算圆面积和圆周长

public class request extends HttpServlet{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
{
response.setContentType("text/html;charset=GBK");
String title="计算圆面积和周长";
PrintWriter out=response.getWriter();
out.println("<html>");//HTML格式
out.println("<body>");
out.println("<head>");
out.println("<title>"+title+"<title>");
out.println("</head>");
out.println("</body>");
out.println("<h3>"+title+"</h3>");
String radius=request.getParameter("radius");
//从页面获取数据
if(radius!=null)
{
float r=(new Float(radius)).floatValue();
double s=2*3.14*r;
double area=3.14*r*r;
out.println("圆的周长:"+s+"<br>");
out.println("圆的面积:"+area);
}//如果获取的数据不为空值
else{
out.println("您还未提交!");
}
}
}

使用Servlet登录

NewFile.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="../loginServlet" method="get">
  <label>
   用户名:<input type="text" placeholder="用户名" name="username"><br>
   密码:<input type="text" placeholder="密码" name="password"><br>
  </label>
  <button type="submit">提交</button>
</form>
</body>
</html>

package servlet;

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 java.io.IOException;

@WebServlet("/failServlet")
public class FailServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        resp.setContentType("text/html;charset=utf-8");
        resp.getWriter().write("登录失败!");
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req,resp);
    }
}

package servlet;

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 org.apache.catalina.User;

@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet{
	protected void doGet(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException{
		req.setCharacterEncoding("utf-8");//设定字符编码格式为utf-8
		String username=req.getParameter("username");//获取表单提交的username数据
		String password=req.getParameter("password");//获取密码
		User user=new User();
		user.setUsername(username);
		user.setPassword(password);
		UserLogin ul=new UserLogin();
		User login=ul.login(user);
		if(login==null) {
			req.getRequestDispatcher("/failServlet").forward(req, resp);
		}else {
			req.setAttribute("user", user);
			req.getRequestDispatcher("/successServlet").forward(req, resp);
		}
		
	}
	protected void doPost(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException{
		this.doGet(req, resp);
	}
	

}

package servlet;

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("/successServlet")
public class SuccessServlet extends HttpServlet{
	protected void doGet(HttpServletRequest req,HttpServletResponse resp)throws ServletException,IOException{
		User user=(User)req.getAttribute("user");
		if(user!=null) {
			resp.setContentType("text/html;charset=utf-8");
			resp.getWriter().write(user.getUsername()+"登陆成功");
		}
	}
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req,resp);
    }

}

package servlet;

public class User {
	private int id;
	private String username;
	private String password;
	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 getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	

}

package servlet;

public class UserLogin {
	public User login(User loginUser) {
		if(loginUser.getUsername().equals("mika")&&loginUser.getPassword().equals("123"))
			return loginUser;
		else return null;
		//如果提交的数据符合账号为mika密码为123 则判断正确登录
	}

}