要做一个简单的保存网页界面&＃xff0c;首先用jsp写出保存界面&＃xff0c;本次界面比较简单&＃xff0c;首先是三个提示语&＃xff0c;后面是三个输入框&＃xff0c;然后是保存按钮。
后台我写了两个java文件&＃xff0c;第一个Bean.java是用来连接数据库以及更新的&＃xff0c;第二个Update.java文件是用来更新表&＃xff0c;记录界面输入的结果&＃xff0c;所以在这个文件里需要判断输入的格式是否正确&＃xff0c;比如任课教师只能输入王建民&＃xff0c;刘力嘉&＃xff0c;刘丹等等&＃xff0c;所以这个文件里需要加入判断语句&＃xff0c;最后我又加了一个jsp文件&＃xff0c;提示输入正确与否&＃xff0c;如果输入格式不正确&＃xff0c;会有提示&＃xff0c;如果输入正确&＃xff0c;会提示保存成功 。
源代码&＃xff1a;
Bean.java:
import java.sql.*;
public class Bean {String userName &＃61; "root";String userPwd &＃61; "24365426";String connStr &＃61; "jdbc:mysql://localhost:3306/ClassTest";String driverStr&＃61; "com.mysql.jdbc.Driver";private Connection conn&＃61;null;private Statement stmt&＃61;null;//Statement 可以执行数据库查询 更新语句
public Bean()
{try{Class.forName(driverStr);conn &＃61; DriverManager.getConnection(connStr,userName, userPwd);//conn是 数据库链接地址stmt &＃61; conn.createStatement();}catch(Exception ex){System.out.println("数据库连接失败");}
}public int executeUpdate(String s){int result&＃61;0;try{result&＃61;stmt.executeUpdate(s);//更新固定返回0和1}catch(Exception ex){System.out.println("更新失败"&＃43;ex.getMessage());}return result;}public ResultSet executeQuery(ResultSet rs, String s){try{rs&＃61;stmt.executeQuery(s);}catch(Exception ex){System.out.println("查询失败"&＃43;ex);}return rs;}public void close(){try{stmt.close();conn.close();}catch(Exception e){}}
}
Update.java:
import java.io.IOException;
import java.io.PrintWriter;import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;&＃64;WebServlet("/Login")
public class Update extends HttpServlet {private static final long serialVersionUID &＃61; 1L;/*** &＃64;see HttpServlet#HttpServlet()*/public Update() {super();// TODO Auto-generated constructor stub}/*** &＃64;see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubresponse.getWriter().append("Served at: ").append(request.getContextPath());}/*** &＃64;see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubrequest.setCharacterEncoding("utf-8"); response.setHeader("Content-type", "text/html;charset&＃61;UTF-8"); response.setCharacterEncoding("UTF-8");PrintWriter out &＃61; response.getWriter();String username &＃61; request.getParameter("username");String homeaddress&＃61;request.getParameter("address");if(!homeaddress.equals("王建民")||!homeaddress.equals("刘力嘉")||!homeaddress.equals("刘丹")||!homeaddress.equals("王辉")||!homeaddress.equals("杨子光")){out.print("");}String Pname &＃61;request.getParameter("Pname");String miaoshu&＃61;request.getParameter("miaoshu");if(homeaddress.equals("王建民")||homeaddress.equals("刘力嘉")||homeaddress.equals("刘丹")||homeaddress.equals("王辉")||homeaddress.equals("杨子光")) {String s &＃61; "insert into classtest(username,homeaddress,Pname,miaoshu) values (&＃39;"&＃43;username&＃43;"&＃39;,&＃39;"&＃43;homeaddress&＃43;"&＃39;,&＃39;"&＃43;Pname&＃43;"&＃39;,&＃39;"&＃43;miaoshu&＃43;"&＃39;)";Bean db&＃61; new Bean();int i &＃61; db.executeUpdate(s);if(!homeaddress.equals("王建民")||!homeaddress.equals("刘力嘉")||!homeaddress.equals("刘丹")||!homeaddress.equals("王辉")||!homeaddress.equals("杨子光")){out.print("错误");}if(i&＃61;&＃61;1){out.print("");//脚本语言}else{out.println("");} }}
}
Login.jsp:
<%&＃64; page language&＃61;"java" contentType&＃61;"text/html; charset&＃61;utf-8"pageEncoding&＃61;"utf-8"%> 课程名称 上课教师 上课地点
LoginSuccess.jsp:
<%&＃64; page language&＃61;"java" contentType&＃61;"text/html; charset&＃61;utf-8"pageEncoding&＃61;"utf-8"%> 保存成功
运行截图&＃xff1a;
![如何从python读取sql[mysql基础教程]](https://img1.php1.cn/3cd4a/24de0/3b4/77028e3ebbb95f60.jpeg)
京公网安备 11010802041100号