NewFile
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%><!DOCTYPE html><html><head><meta charset="utf-8"><title>Insert title here</title></head><body><form action='get' method="post"><input type="button" value="https://bbs.csdn.net/topics/資訊錄入" onclick="window.location.href('NewFile1.jsp')" ><input type="button" value="https://bbs.csdn.net/topics/資訊查詢" onclick="window.location.href('NewFile2.jsp')" ><input type="button" value="https://bbs.csdn.net/topics/資訊更新" onclick="window.location.href('NewFile3.jsp')" ><input type="button" value="https://bbs.csdn.net/topics/資訊洗掉" onclick="window.location.href('NewFile4.jsp')"><input type="button" value="https://bbs.csdn.net/topics/退出系統"><h1> 學生管理系統</h1></form></body></html>
NewFile1
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%><!DOCTYPE html><html><head><meta charset="utf-8"><title>Insert title here</title></head><body><form action='Infortion' method="post"></form><input type="button" value="https://bbs.csdn.net/topics/資訊錄入" onclick="window.location.href('NewFile1.jsp')" ><input type="button" value="https://bbs.csdn.net/topics/資訊查詢" onclick="window.location.href('NewFile2.jsp')"><input type="button" value="https://bbs.csdn.net/topics/資訊更新" onclick="window.location.href('NewFile3.jsp')"><input type="button" value="https://bbs.csdn.net/topics/資訊洗掉" onclick="window.location.href('NewFile4.jsp')"><input type="button" value="https://bbs.csdn.net/topics/退出系統"><br>學號 <input type=text name="sno"><br>姓名 <input type=text name="name"><br>性別 <input type=text name="sex"><br>地址 <input type=text name="address"><br>電話 <input type=text name="phone"><br>專業 <input type=text name="sdept"><br> <input type="submit" value="https://bbs.csdn.net/topics/錄入" name="sumbit"> <input type="submit" value="https://bbs.csdn.net/topics/重置" name="sumbit"></body></html>
web.xml
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" id="WebApp_ID" version="4.0"> <display-name>JDBC</display-name> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.htm</welcome-file> <welcome-file>index.jsp</welcome-file> <welcome-file>default.html</welcome-file> <welcome-file>default.htm</welcome-file> <welcome-file>default.jsp</welcome-file> </welcome-file-list><servlet><servlet-name>Infortion</servlet-name><servlet-class>JDBC.LURU</servlet-class></servlet><servlet-mapping><servlet-name>Infortion</servlet-name><url-pattern>/Infortion</url-pattern></servlet-mapping></web-app>
LURU.java
package JDBC;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import javax.servlet.RequestDispatcher;import javax.servlet.ServletConfig;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 student.student;/** * Servlet implementation class Insert */@WebServlet("/LURU")public class LURU extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public LURU() { super(); // TODO Auto-generated constructor stub } /** * @see Servlet#init(ServletConfig) */ public void init(ServletConfig config) throws ServletException { super.init(config); try { Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){} } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); student stu=new student(); request.setAttribute("student",stu); String sno=request.getParameter("sno"); String name=request.getParameter("name"); String sex=request.getParameter("sex"); String address=request.getParameter("address"); String phone=request.getParameter("phone"); String sdept=request.getParameter("sdept"); Connection con=null; PreparedStatement ps = null; String uri="jdbc:mysql://localhost/stu"; try{ con=DriverManager.getConnection(uri,"root","123456"); String sql = "insert into stud values(?, ? , ?, ?, ?, ?)"; ps = con.prepareStatement(sql); // ResultSet rs=ps.executeQuery(sql); ps.setString(1, sno); ps.setString(2, name); ps.setString(3, sex); ps.setString(4, address); ps.setString(5, phone); ps.setString(6, sdept); int result = ps.executeUpdate(); if(result>0){ System.out.println("插入成功"); }else{ System.out.println("插入失敗"); } con.close(); RequestDispatcher dispatcher=request.getRequestDispatcher("NewFile1.jsp"); dispatcher.forward(request, response); } catch(SQLException exp){ System.out.println("查無此人"); } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); }}
資料庫Navicat Premium中的stu資料庫表stud已建好，
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/84969.html
標籤：基礎類
上一篇：織物疵點檢測