基于JSP的登录界面
系别:计算机科学与技术
专业:计算机科学与技术
班级:专升本1502班
学号: 2015104222
姓名:申彦栋
目录
MVC模式 (2)
1> 增加一条记录 (2)
2> 修改一条记录 (2)
3> 删除一条记录 (3)
4> 简单的登录界面及jsp对数据库的操作 (3)
5>数据库Test (3)
M层:模型层 (5)
V层:试图层 (11)
C层:控制层—Servlet (17)
MVC模式
M:Model,即模型,对于JavaBean
V:View,即试图,对应JSP页面
C:Controller,即控制器,对应Servlet 1.以下为MVC实现一个简单的增删改查功能1>显示记录
2>增加一条记录
3>修改一条记录
4>删除一条记录
在显示界面即可删除
5>简单的登录界面及jsp对数据库的操作 1>登录界面
2>注册界面
6>数据库Test
1、login设计表- - ->
login表内容- - - >
2、stu表设计- - - >
stu表内容- - - >
M层:模型层
封装一条信息的所有属性JavaBean.java ,即VO
package MVC;
public class JavaBean {
private int id;
private String name;
private String password;
private String sex;
private int age;
public JavaBean() {
super();
// TODO Auto-generated constructor stub
}
public JavaBean(int id, String name, String password, String sex, int age) {
this.id = id;
https://www.wendangku.net/doc/c018518608.html, = name;
this.password = password;
this.sex = sex;
this.age = age;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
https://www.wendangku.net/doc/c018518608.html, = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
封装数据库连接以及操作JavaBean所用到的方法,
SqlBean.java文件即DAO
package MVC;
//封装数据库连接以及操作JavaBean所用到的方法,即DAO
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
//import java.util.List;
public class SqlBean {
/**
*操作数据库的方法
*/
// 定义数据库驱动程序
String DBDRIVER = "com.mysql.jdbc.Driver" ;
// 定义数据库连接对象,属于java.sql包中的接口
Connection con=null;
//定义PreapredStatement对象,用于操作数据库
PreparedStatement pre=null;
// 查询返回的结果集对象
ResultSet rs=null;
public SqlBean()
{
try {
// 1、加载驱动程序
Class.forName(DBDRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
// 2、数据库连接地址
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/z xdstudent","root","");
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* @author help
*
*插入新的一条记录
* @return
*/
public int getInsert(String sql,JavaBean jBean)
{
int count =0;
try {
pre = con.prepareStatement(sql);
pre.setString(1,jBean.getName());
pre.setString(2,jBean.getPassword());
pre.setString(3,jBean.getSex());
pre.setInt(4,jBean.getAge());
count=pre.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
finally
{
try {
//关闭数据库
pre.close();//关闭操作
con.close();//关闭连接
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return count;
}
/**
* @author help
*
*删除一条记录
* @return
*/
public int getDelete(String sql,int id)
{
int count =0;
try {
pre = con.prepareStatement(sql);
pre.setInt(1, id);
count=pre.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
finally
{
try {
pre.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return count;
}
/**
* @author help
*
*根据ID查询某一条记录
* @return
*/
public JavaBean getSearchById(String sql,int id) {
JavaBean jBean = new JavaBean();
try {
pre = con.prepareStatement(sql);
pre.setInt(1, id);
rs=pre.executeQuery();
while(rs.next())
{
jBean.setId(rs.getInt("id"));
jBean.setName(rs.getString("name"));
jBean.setPassword(rs.getString("password"));
jBean.setSex(rs.getString("sex"));
jBean.setAge(rs.getInt("age"));
}
} catch (SQLException e)
{
e.printStackTrace();
}
return jBean;
}
/**
* @author help
*
*更新某一条记录
* @return
*/
public int getUpdate(String sql,JavaBean jBean)
{
int count =0;
try {
pre = con.prepareStatement(sql);
pre.setInt(5,jBean.getId());
pre.setString(1,jBean.getName());
pre.setString(2,jBean.getPassword());
pre.setString(3,jBean.getSex());
pre.setInt(4,jBean.getAge());
count = pre.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
try {
pre.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return count;
}
/**
* @author help
*
*显示所有记录
* @return
*/
public ArrayList
{
ArrayList
try {
pre = con.prepareStatement(sql);
rs =pre.executeQuery();
while(rs.next())
{
JavaBean jBean =new JavaBean();
jBean.setId(rs.getInt("id"));
jBean.setName(rs.getString("name"));
jBean.setPassword(rs.getString("password"));
jBean.setSex(rs.getString("sex"));
jBean.setAge(rs.getInt("age"));
list.add(jBean);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
try {
pre.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}
}
V层:试图层
显示记录集的页面 SearchList.jsp
<%@page language="java"import="java.util.*"pageEncoding="UTF-8"%> <%@page import="MVC.SqlBean"%>
<%@page import="MVC.JavaBean"%>
<%@page import="java.util.Iterator;"%>
<%
String path = request.getContextPath();
String basePath =
request.getScheme()+"://"+request.getServerName()+":"+request.getServ erPort()+path+"/";
%>
插入页面Insert.jsp
<%@page language="java"import="java.util.*"
pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath =
request.getScheme()+"://"+request.getServerName()+":"+request.get ServerPort()+path+"/";
%>
学生管理页面
更新页面Update.jsp
<%@page language="java"import="java.util.*"pageEncoding="UTF-8"%> <%
String path = request.getContextPath();
String basePath =
request.getScheme()+"://"+request.getServerName()+":"+request.getServ erPort()+path+"/";
%>
学生管理页面
查询页面Search.jsp
<%@page language="java"import="java.util.*"pageEncoding="UTF-8"%> <%@page import="MVC.SqlBean"%>
<%@page import="MVC.JavaBean"%>
<%@page import="java.util.Iterator;"%>
<%
String path = request.getContextPath();
String basePath =
request.getScheme()+"://"+request.getServerName()+":"+request.getServ erPort()+path+"/";
%>