实验三-Struts2框架编程-实验报告纸.docVIP

实验三-Struts2框架编程-实验报告纸 实验三-Struts2框架编程-实验报告纸 /body 8.创建success.jsp与error.jsp 9.连接MYSQL Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.34-community MySQL Community Server (GPL) Type help; or \h for help. Type \c to clear the current input statement. mysql create database mydb; Query OK, 1 row affected (0.01 sec) mysql use mydb; Database changed mysql create table customer( - name char(20), - password char(20)); Query OK, 0 rows affected (0.08 sec) mysql insert into customer values(sa1,admin); Query OK, 1 row affected (0.03 sec) mysql insert into customer values(kate,123); Query OK, 1 row affected (0.02 sec) mysql 10.创建CustomerDAO public class CustomerDAO { public boolean check(String name,String password){ try{ Class.forName(com.mysql.jdbc.Driver); Connection con=DriverManager.getConnection(jdbc:mysql://localhost:3306/mydb,root,); Statement state=con.createStatement(); String sql=select * from customer where name=+name+ and password=+password+; ResultSet rs=state.executeQuery(sql); if(rs.next()){ return true; } }catch(Exception e){ e.printStackTrace(); } return false; } } 2） 实验内容 建立数据库 建立Web项目 加载Struts 2的基本类库 修改web.xml 建立stu.jsp文件 %@ page language=java pageEncoding=utf-8% %@ taglib uri=/struts-tags prefix=s% html head s:head / /head body h3添加学生信息/h3 s:form action=save.action method=post theme=simple table trtd学号：/td tds:textfield name=xs.xh/s:textfield/td /trtrtd姓名：/td tds:textfield name=xs.xm /s:textfield/td /trtrtd性别：/td tds:radio name=xs.xb list=#{1:男,2:女} value=1/s:radio/td /trtrtd专业：/td tds:textfield name=xs.zy label=专业/s:textfield/td /trtrtd width=70出生时间:/td tds:datetimepicker name=xs.cssj id=cssj displayFormat=yyyy-MM-dd /s:datetimepicker/td /trtrtd 备注：/td tds:textarea name=xs.bz label=备注/s:textarea/td /