学生信息管理系统
来源:互联网 发布:昵图网软件下载 编辑:程序博客网 时间:2024/05/14 19:45
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//数据库的连接
public class DBO {private static String driver="org.gjt.mm.mysql.Driver";
private static String url="jdbc:mysql://localhost:3306/数据库名";
static{
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn=null;
try {
conn=DriverManager.getConnection(url, "mysql用户名", "密码");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void close(ResultSet rs,Connection conn,Statement stmt){
try {
if(rs!=null){
rs.close();
}
if(conn!=null){
conn.close();
}
if(stmt!=null){
stmt.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(Connection conn,Statement st){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
实体类学生
package com.cn.Dao;
public class Student {
private String username;
private String password;
private String grade;
private String sex;
private String tel;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getGrade() {
return grade;
}
public void setGrade(String grade) {
this.grade = grade;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
}
package com.cn.Dao;
public class Teacher {
private String email;
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
private String username;
private String password;
private String address;
private String tel;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
}
老师权限和学生得登陆注册
package com.cn.service;import com.cn.Dao.Student;
import com.cn.Dao.Teacher;
public interface StudentManager {
//登录
public boolean denglu(String username,String password);
//注册
public boolean zhuce(Student Student);
//添加
public boolean tianjia(Student student);
//删除按userid
public boolean delByName(String username);
//查找 按照username
public Student selectByName(String username);
//更新
public boolean update(String username,Student student);
//登录
public boolean deng(String username, String password);
//注册
public boolean zhu(Teacher teacher);
}
老师权限和登陆注册方法的实现
package com.cn.service;import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.cn.Connect.DBO;
import com.cn.Dao.Student;
import com.cn.Dao.Teacher;
import com.mysql.jdbc.PreparedStatement;
public class StudentManagerImpl implements StudentManager {
//添加
public boolean tianjia(Student student) {
boolean flag=false;
//Student stu=new Student();
Connection conn=null;
PreparedStatement st=null;
try {
conn=DBO.getConnection();
String sql="insert into student(username,password,sex,grade,tel) values(?,?,?,?,?)";
st=(PreparedStatement) conn.prepareStatement(sql);
st.setString(1,student.getUsername());
st.setString(2,student.getPassword());
st.setString(3,student.getSex());
st.setString(4,student.getGrade());
st.setString(5,student.getTel());
st.executeUpdate();
flag=true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBO.close(conn, st);
}
return flag;
}
//按照学生姓名进行删除
public boolean delByName(String username) {
boolean flag=false;
Connection conn=null;
PreparedStatement st=null;
try {
conn=DBO.getConnection();
String sql="delete from student where username=?";
st=(PreparedStatement) conn.prepareStatement(sql);
st.setString(1,username);
st.executeUpdate();
flag=true;
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBO.close(conn, st);
}
return flag;
}
//查找
public Student selectByName(String username) {
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
//查询数据需要连接数据库
conn=DBO.getConnection();
//创建执行sql语句的preparedment对象
Student student=new Student();
String sql="select*from student where username=?";
try {
stmt=(PreparedStatement) conn.prepareStatement(sql);
stmt.setString(1,username);//设置条件id
rs=stmt.executeQuery();//执行sql语句的对象在结果集里进行查询,并把查询的结果放在结果集中
while(rs.next()){//如果结果集存在就进行遍历,并把便利得到的放入UserVo对象中
//创建对象
student.setUsername(rs.getString("username"));//查询得到的数据给数据表
student.setPassword(rs.getString("password"));
student.setSex(rs.getString("sex"));
student.setTel(rs.getString("tel"));
student.setGrade(rs.getString("grade"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//执行sql语句的prepareStement对象
return student;
}
//更新
public boolean update(String username,Student student) {
boolean flag=false;
Connection conn=null;
PreparedStatement std=null;
try {
conn=DBO.getConnection();
String sql="update student set username=?,password=?,sex=?,grade=?,tel=? where username='"+username+"'";
std=(PreparedStatement) conn.prepareStatement(sql);
std.setString(1,student.getUsername());
std.setString(2,student.getPassword());
std.setString(3,student.getSex());
std.setString(4,student.getGrade());
std.setString(5,student.getTel());
System.out.println(sql);
System.out.println(student.getPassword());
std.executeUpdate();
flag=true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBO.close(conn, std);
}
return flag;
}
//登录
public boolean deng(String username, String password) {
boolean flag=false;
Connection conn=null;
PreparedStatement st=null;
ResultSet rs=null;
try {
conn=DBO.getConnection();
String sql="select * from student where username=? and password=?";
st=(PreparedStatement) conn.prepareStatement(sql);
st.setString(1,username);
st.setString(2,password);
rs=st.executeQuery();
if(rs.next()){//条件判断
flag=true;
}
//while(rs)
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBO.close(conn, st);
}
return flag;
}
//注册
public boolean zhu(Teacher teacher) {
boolean flag=false;
Connection conn=null;
conn=DBO.getConnection();
String sql="insert into student(username,password) values(?,?)";
try {
PreparedStatement stmt=(PreparedStatement) conn.prepareStatement(sql);
stmt.setString(1,teacher.getUsername());
stmt.setString(2,teacher.getPassword());
stmt.executeUpdate();
flag=true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
//登录
public boolean denglu(String username, String password)
{
boolean flag=false;
Connection conn=null;
PreparedStatement st=null;
ResultSet rs=null;
try {
conn=DBO.getConnection();
String sql="select * from student where username=? and password=?";
st=(PreparedStatement) conn.prepareStatement(sql);
st.setString(1,username);
st.setString(2,password);
rs=st.executeQuery();
if(rs.next()){//条件判断
flag=true;
}
//while(rs)
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBO.close(conn, st);
}
return flag;
}
//注册
public boolean zhuce(Student student)
{
boolean flag=false;
Connection conn=null;
conn=DBO.getConnection();
String sql="insert into student(username,password) values(?,?)";
try {
PreparedStatement stmt=(PreparedStatement) conn.prepareStatement(sql);
stmt.setString(1,student.getUsername());
stmt.setString(2,student.getPassword());
stmt.executeUpdate();
flag=true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
}
package com.cn.service;
import com.cn.Dao.Teacher;
public interface TeacherManager {
//登录
public boolean deng(String username,String password);
//注册
public boolean zhu(Teacher teacher);
//查找 按照username
public Teacher selectByName(String username);
}
学生登录注册的实现
package com.cn.service;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.cn.Connect.DBO;
import com.cn.Dao.Teacher;
public class TeacherManagerImpl implements TeacherManager {
//登录
public boolean deng(String username, String password) {
boolean flag=false;
java.sql.Connection conn=null;
PreparedStatement st=null;
java.sql.ResultSet rs=null;
try {
conn=DBO.getConnection();
String sql="select * from teacher where username=? and password=?";
st=(PreparedStatement) conn.prepareStatement(sql);
st.setString(1,username);
st.setString(2,password);
rs=st.executeQuery();
if(rs.next()){//条件判断
flag=true;
}
//while(rs)
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
DBO.close(conn, st);
}
return flag;
}
//注册
public boolean zhu(Teacher teacher) {
boolean flag=false;
Connection conn=null;
conn=DBO.getConnection();
String sql="insert into teacher(username,password) values(?,?)";
try {
PreparedStatement stmt=(PreparedStatement) conn.prepareStatement(sql);
stmt.setString(1,teacher.getUsername());
stmt.setString(2,teacher.getPassword());
stmt.executeUpdate();
flag=true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
@Override
public Teacher selectByName(String username) {
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
//查询数据需要连接数据库
conn=DBO.getConnection();
//创建执行sql语句的preparedment对象
Teacher teacher=new Teacher();
String sql="select*from teacher where username=?";
try {
stmt=(PreparedStatement) conn.prepareStatement(sql);
stmt.setString(1,username);//设置条件id
rs=stmt.executeQuery();//执行sql语句的对象在结果集里进行查询,并把查询的结果放在结果集中
while(rs.next()){//如果结果集存在就进行遍历,并把便利得到的放入UserVo对象中
//创建对象
teacher.setUsername(rs.getString("username"));//查询得到的数据给数据表
teacher.setPassword(rs.getString("password"));
teacher.setAddress(rs.getString("address"));
teacher.setTel(rs.getString("tel"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//执行sql语句的prepareStement对象
return teacher;
}
}
分页的方法
package com.cn.service;
import com.cn.Dao.PageBean;
import com.cn.Dao.Student;
public interface StudentDao {
public PageBean <Student> findByPage(int pc);//按当前页查找,返回的是pageBean
}//pageBean包括,跳转页面,当前页的记录数,当前页数,要跳转页面的地址
分页的实现
package com.cn.service;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import com.cn.Connect.DBO;
import com.cn.Dao.PageBean;
import com.cn.Dao.Student;
public class StudentDaoImpl implements StudentDao {
public PageBean<Student> findByPage(int pc) {
//当前页记录数
int ps=5;
//总记录数,连接数据库进行查询
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
int tr=0;
try {
conn=DBO.getConnection();
String sql="select count(*) from student";
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
tr= rs.getInt("count(*)");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ArrayList<Student> list=new ArrayList<Student>();//装查询到的记录
int begin=(pc-1)*ps;//得到当前页面的记录,从第几个记录开始到第几个记录结束,,,
String sql="select * from student limit "+begin+","+ps;
try {
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next()){
Student student =new Student();
student.setUsername(rs.getString("username"));
student.setPassword(rs.getString("password"));
student.setGrade(rs.getString("grade"));
student.setSex(rs.getString("sex"));
student.setTel(rs.getString("tel"));
list.add(student);
}
PageBean<Student> pageBean=new PageBean<Student>();
pageBean.setPs(ps);
pageBean.setPc(pc);
pageBean.setTr(tr);
pageBean.setBeanlist(list);
return pageBean;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
}
分页和servlet连接得servrice
package com.cn.service;
import com.cn.Dao.PageBean;
import com.cn.Dao.Student;
//StudentService的目的就是为了得到当前的页数
public class StudentService {
private StudentDao studentDao=new StudentDaoImpl();
public PageBean <Student> findByPage(int pc){
PageBean<Student> pageBean=studentDao.findByPage(pc);
return pageBean;
}
}
- 学生信息管理系统
- 学生学籍信息管理系统
- 学生信息管理系统
- 学生信息管理系统
- 学生成绩信息管理系统
- 学生信息管理系统
- 【学生信息管理系统 总结】
- 学生信息管理系统--毕业论文
- 学生信息管理系统
- 学生信息管理系统
- 学生信息管理系统~~~~~
- 学生信息管理系统
- 学生信息管理系统总结
- 学生信息管理系统
- 学生信息管理系统
- 学生信息管理系统
- netbeans 学生信息管理系统
- 学生信息管理系统
- jQuery each的简单使用
- 语言动态规划(12)___跑跑卡丁车(HDU 1494)
- Opencv中HSV通道的图像的颜色判定
- 作者的话
- H. Happy Reversal
- 学生信息管理系统
- 正则表达式基本用法
- bzoj 1717: [Usaco2006 Dec]Milk Patterns 产奶的模式(后缀数组)
- Caffe研究实践 二 ------准备数据 训练 测试
- XML Schema
- js之事件冒泡和事件捕获详细介绍
- css样式选择器
- MediaWiki基本设置
- iOS开发之基础视图——UIScrollView