初级struts2应用-学生信息管理系统
标签:
•
文件类型: .zip
•
文件大小: 4.83MB
•
下载次数: 1
•
初学struts2做的简单应用,页面copy网上大神的,超初级,大神勿入,初学者可参照,交个课程设计还是可以的
代码片段和文件信息
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
目录 0 2017-03-05 17:17 student_3
文件 838 2017-02-10 23:56 student_3.classpath
文件 909 2017-02-10 23:56 student_3.project
目录 0 2017-03-05 17:17 student_3.settings
文件 567 2017-02-10 23:56 student_3.settings.jsdtscope
文件 364 2017-02-10 23:56 student_3.settingsorg.eclipse.jdt.core.prefs
文件 479 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.common.component
文件 349 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.common.project.facet.core.xml
文件 49 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.jsdt.ui.superType.container
文件 6 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.jsdt.ui.superType.name
目录 0 2017-02-10 23:56 student_3uild
目录 0 2017-03-05 17:17 student_3uildclasses
目录 0 2017-03-05 17:13 student_3uildclassescom
目录 0 2017-03-05 17:17 student_3uildclassescomstudent
文件 8194 2017-03-05 15:13 student_3uildclassescomstudentDBUser.class
文件 2002 2017-03-05 16:11 student_3uildclassescomstudentSetCharacterEncodingFilter.class
文件 2257 2017-03-05 15:13 student_3uildclassescomstudentStudent.class
文件 1788 2017-03-05 15:13 student_3uildclassescomstudentStudentDeleteAction.class
文件 1765 2017-03-05 15:13 student_3uildclassescomstudentStudentListAction.class
文件 1844 2017-03-05 15:13 student_3uildclassescomstudentStudentListByNameAction.class
文件 2052 2017-03-05 16:07 student_3uildclassescomstudentStudentSaveAction.class
文件 1870 2017-03-05 15:53 student_3uildclassesstruts.xml
目录 0 2017-03-05 17:17 student_3src
目录 0 2017-03-05 17:13 student_3srccom
目录 0 2017-03-05 17:17 student_3srccomstudent
文件 8551 2017-03-04 15:57 student_3srccomstudentDBUser.java
文件 1889 2017-02-11 00:22 student_3srccomstudentSetCharacterEncodingFilter.java
文件 1656 2017-03-05 15:11 student_3srccomstudentStudent.java
文件 1007 2017-03-05 10:52 student_3srccomstudentStudentDeleteAction.java
文件 1452 2017-03-04 15:26 student_3srccomstudentStudentListAction.java
文件 1049 2017-03-04 15:55 student_3srccomstudentStudentListByNameAction.java
............此处省略32个文件信息
package com.student;
//代表学生的实体类
import javax.servlet.ServletContext;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class DBUser {
private ServletContext application;
//定义构造方法,加载驱动程序,接收全局应用对象
public DBUser(){
try {
Class.forName(“com.mysql.jdbc.Driver“);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}catch (Exception e) {
e.printStackTrace();
}
}
//添加getStudent()方法取出所有学生数据,每个学生的数据放在Student类型的一个对象中,所有学生存放一个list类型的对象中
public List getStudent(){
List sStudent=new ArrayList();
Connection con=null;
try{
String url=“jdbc:mysql://localhost:3306/studenttb“;
con=DriverManager.getConnection(url “root““root“);
Statement stmt=con.createStatement();
ResultSet result=stmt.executeQuery(“select * from studenttb order by (ssno+0) ASC“);
while(result.next())
{
Student student=new Student();
student.setSsno(result.getString(“ssno“));
student.setSsname(result.getString(“ssname“));
student.setSssex(result.getString(“sssex“));
student.setSsage(result.getInt(“ssage“));
student.setSsmajor(result.getString(“ssmajor“));
student.setSsfav(result.getString(“ssfav“));
student.setSsaddress(result.getString(“ssaddress“));
sStudent.add(student);
}
}catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}finally {
if(con!=null){
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return sStudent;
}
//根据名字查询信息
public List getStudentByName(String ssname){
List sStudent=new ArrayList();
Connection con=null;
Student student=null;
try{
String url=“jdbc:mysql://localhost:3306/studenttb“;
con=DriverManager.getConnection(url “root““root“);
Statement stmt=con.createStatement();
String sql;
if(ssname==null||ssname.equals(““))
{
sql=“select * from studenttb order by (ssno+0) ASC“;
}
else
{
sql=“select * from studenttb where ssname like‘%“+ssname+“%‘ order by (ssno+0) ASC“;
}
ResultSet result=stmt.executeQuery(sql);
while(result.next())
{
student=new Student(sql sql sql 0 sql sql sql);
student.setSsno(result.getString(“ssno“));
student.setSsname(result.getString(“ssname“));
student.setSssex(result.getString(“sssex“));
student.setSsage(result.getInt(“ssage“));
student.setSsmajor(result.getString(“ssmajor“));
student.setSsfav(result.getString(“ssfav“));
student.setSsaddress(result.getString(“ssaddress“));
sStudent.add(student);
}
}catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}finally {
if(con!=
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
目录 0 2017-03-05 17:17 student_3
文件 838 2017-02-10 23:56 student_3.classpath
文件 909 2017-02-10 23:56 student_3.project
目录 0 2017-03-05 17:17 student_3.settings
文件 567 2017-02-10 23:56 student_3.settings.jsdtscope
文件 364 2017-02-10 23:56 student_3.settingsorg.eclipse.jdt.core.prefs
文件 479 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.common.component
文件 349 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.common.project.facet.core.xm
文件 49 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.jsdt.ui.superType.container
文件 6 2017-02-10 23:56 student_3.settingsorg.eclipse.wst.jsdt.ui.superType.name
目录 0 2017-02-10 23:56 student_3uild
目录 0 2017-03-05 17:17 student_3uildclasses
目录 0 2017-03-05 17:13 student_3uildclassescom
目录 0 2017-03-05 17:17 student_3uildclassescomstudent
文件 8194 2017-03-05 15:13 student_3uildclassescomstudentDBUser.class
文件 2002 2017-03-05 16:11 student_3uildclassescomstudentSetCharacterEncodingFilter.class
文件 2257 2017-03-05 15:13 student_3uildclassescomstudentStudent.class
文件 1788 2017-03-05 15:13 student_3uildclassescomstudentStudentDeleteAction.class
文件 1765 2017-03-05 15:13 student_3uildclassescomstudentStudentListAction.class
文件 1844 2017-03-05 15:13 student_3uildclassescomstudentStudentListByNameAction.class
文件 2052 2017-03-05 16:07 student_3uildclassescomstudentStudentSaveAction.class
文件 1870 2017-03-05 15:53 student_3uildclassesstruts.xm
目录 0 2017-03-05 17:17 student_3src
目录 0 2017-03-05 17:13 student_3srccom
目录 0 2017-03-05 17:17 student_3srccomstudent
文件 8551 2017-03-04 15:57 student_3srccomstudentDBUser.java
文件 1889 2017-02-11 00:22 student_3srccomstudentSetCharacterEncodingFilter.java
文件 1656 2017-03-05 15:11 student_3srccomstudentStudent.java
文件 1007 2017-03-05 10:52 student_3srccomstudentStudentDeleteAction.java
文件 1452 2017-03-04 15:26 student_3srccomstudentStudentListAction.java
文件 1049 2017-03-04 15:55 student_3srccomstudentStudentListByNameAction.java
............此处省略32个文件信息
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件举报,一经查实,本站将立刻删除。
评论列表(条)