package StudentOper;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.http.HttpSession;
import util.MyDate;
import dao.Student;
import dateBase.DBManager;
public class sOperate
{
HttpSession session=null;
DBManager dbm=new DBManager();
Connection con=null;
boolean boo=false;
PreparedStatement ps=null;
Statement st=null;
ResultSet rs=null;
static int id=0;
//注冊
public boolean SRegister(Student stu)
{
con=dbm.getCon();
String sql="INSERT INTO student (username,pwd,realname,age,sex,birthday," +
"university,email,major,xueli,jianli)VALUES('"
+stu.getName()+"','"+stu.getPwd()+"','"+stu.getRealname()+"',"
+stu.getAge()+",'"+stu.getSex()+"','"+stu.getBirthday()+"','"
+stu.getUniversity()+"','"+stu.getMajor()+"','"
+stu.getEmail()+"','"+stu.getMajor()+"','"+stu.getJianli()+"')";
System.out.println("学生注册---------"+sql);
try {
ps = con.prepareStatement(sql);
int a = ps.executeUpdate();
if(a>0)
{
doLogin(stu.getName(),stu.getPwd(),"student");
boo = true;
}
} catch (SQLException e) {
System.out.println("学生注册失败");
e.printStackTrace();
}finally{
dbm.Close(null, null, con, ps);
}
return boo;
}
//登录
public int doLogin(String name,String pwd,String status)
{
String sql="select * from "+status+" where username='"+name+"'and pwd='"+pwd+"'";
System.out.println("登录-------"+sql);
try {
st=dbm.getCon().createStatement();
rs=st.executeQuery(sql);
if(rs.next())
{
id=rs.getInt("id");
return id;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
dbm.Close(null,null, con, ps);
}
return id;
}
//修改学生信息
public boolean findStu(Student stu)
{
System.out.println("-------id-------"+id);
String sql="UPDATE student SET pwd='"+stu.getPwd()+"',realname='"+stu.getRealname()
+"',age='"+stu.getAge()+"',sex='"+stu.getSex()
+"',birthday='"+stu.getBirthday()+"',university='"+stu.getUniversity()
+"',email='"+stu.getEmail()+"',major='"+stu.getMajor()
+"',xueli='"+stu.getXueli()+"',jianli='"+stu.getJianli()+
"' WHERE username='"+stu.getName()+"';";
System.out.println("修改学生信息------------"+sql);
try {
ps=dbm.getCon().prepareStatement(sql);
int i=ps.executeUpdate();
if(i>0)
{
boo=true;
}
} catch (SQLException e) {
System.out.println("修改学生信息失败------------");
e.printStackTrace();
}
return boo;
}
//发布求职信息
public boolean Announce(Student stu){
System.out.println("---Announce----id-------"+id);
MyDate date=new MyDate();
String sql="INSERT INTO stuannounce(userid,posi,salary,indate,remark,specialty,mydate)" +
"VALUES ("+id+",'"+stu.getPosition()+"','"+stu.getSalary()+"','"+stu.getDate()+"','"
+stu.getRemark()+"','"+stu.getSpecialty()+"','"+date.getDate()+"')";
System.out.println("--发布求职信息-------"+sql);
try {
ps=dbm.getCon().prepareStatement(sql);
int i=ps.executeUpdate();
if(i>0)
{
boo=true;
}
} catch (SQLException e) {
System.out.println("--发布求职信息失败-----");
e.printStackTrace();
}
return boo;
}
//查询求职信息
public ResultSet findInfo()
{
Student student = null;
String sql="select * FROM stuannounce WHERE userid="+id+";";
try {
st=dbm.getCon().createStatement();
rs=st.executeQuery(sql);
} catch (SQLException e) {
System.out.println("--删除求职信息失败-------");
e.printStackTrace();
}finally{
dbm.Close(rs, st, con, ps);
}
return rs;
}
//删除求职信息
public boolean DeleteInfo(int id)
{
String sql="DELETE FROM stuannounce WHERE id="+id+";";
System.out.println("---删除求职信息----------"+sql);
try {
ps=dbm.getCon().prepareStatement(sql);
int i=ps.executeUpdate();
if(i>0)
{
boo=true;
}
} catch (SQLException e) {
System.out.println("--删除求职信息失败-------");
e.printStackTrace();
}finally
{
dbm.Close(rs, st, con, ps);
}
return boo;
}
//查询学生求职信息
public ResultSet findResume()
{
String sql="SELECT * FROM stuannounce ORDER BY mydate desc";
try {
st=dbm.getCon().createStatement();
rs=st.executeQuery(sql);
} catch (SQLException e) {
System.out.println("----查询学生求职信息--------");
e.printStackTrace();
}
return rs;
}
//查询学生求职详细信息
public Student findDetailInfo(int id)
{
Student stu=new Student();
String sql="select * from student where id="+id;
try {
st=dbm.getCon().createStatement();
rs=st.executeQuery(sql);
if(rs.next())
{
stu.setRealname(rs.getString("realname"));
stu.setSex(rs.getString("sex"));
stu.setEmail(rs.getString("email"));
stu.setMajor(rs.getString("major"));
stu.setUniversity(rs.getString("university"));
stu.setXueli(rs.getString("xueli"));
stu.setBirthday(rs.getString("birthday"));
String sql1="select * from stuannounce where userid="+id;
System.out.println("查询学生求职详细信息--------"+sql1);
ResultSet rs1=st.executeQuery(sql1);
if(rs1.next())
{
stu.setSpecialty(rs1.getString("specialty"));
stu.setPosition(rs1.getString("posi"));
stu.setSalary(rs1.getString("salary"));
stu.setTime(rs1.getString("mydate"));
stu.setDate(rs1.getInt("indate"));
}
}
} catch (SQLException e) {
System.out.println("查询学生求职详细信息失敗--------");
e.printStackTrace();
}finally
{
dbm.Close(rs, st, con, ps);
}
return stu;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
jsp.rar_jsp 管理员功能
共130个文件
jsp:46个
java:14个
class:14个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 178 浏览量
2022-09-21
18:34:46
上传
评论
收藏 2.77MB RAR 举报
温馨提示
用Jsp编写的能对数据库进行增删改查的管理系统,分一般用户功能和管理员功能
资源推荐
资源详情
资源评论
收起资源包目录
jsp.rar_jsp 管理员功能 (130个子文件)
sOperate.class 7KB
Student.class 4KB
StuRegis.class 3KB
StuModify.class 2KB
StuSendInfo.class 2KB
StuLogin.class 2KB
StuDetailInfo.class 2KB
sendMail.class 2KB
Cregister.class 2KB
Company.class 2KB
COper.class 2KB
StuDelete.class 2KB
DBManager.class 2KB
MyDate.class 1KB
.classpath 463B
.classpath 449B
left.css 647B
default.css 525B
Thumbs.db 57KB
HO.gif 308KB
70020490354946ada977a40b.gif 209KB
noname3.gif 149KB
hocc12.gif 148KB
HOCCC.gif 130KB
HOCCC2.gif 128KB
OH.gif 71KB
HHO.gif 58KB
0099CC.gif 30KB
top.gif 3KB
gbnavl.gif 580B
gbnavr.gif 578B
gbnavm.gif 309B
index.htm 4KB
index.htm 2KB
ajobinfo.htm 2KB
ajobinfo.htm 2KB
left.htm 2KB
left.htm 2KB
index.htm 1KB
top.htm 1KB
top.htm 721B
top.htm 721B
login.htm 617B
login.htm 561B
login.htm 549B
index.htm 397B
Noname2.html 9KB
index.html 834B
mysql-connector-java-5.1.5-bin.jar 661KB
sOperate.java 6KB
Student.java 2KB
StuRegis.java 2KB
StuModify.java 2KB
StuSendInfo.java 2KB
Cregister.java 2KB
StuLogin.java 1KB
sendMail.java 1KB
DBManager.java 1KB
StuDetailInfo.java 1KB
Company.java 1KB
StuDelete.java 1010B
COper.java 844B
MyDate.java 602B
0ed42e381d7fe3d1b211c78c.jpg 242KB
ho2.jpg 180KB
ho6.jpg 149KB
taohua.jpg 104KB
ho.jpg 54KB
ho3.jpg 41KB
BG.jpg 7KB
bg.jpg 2KB
tdbg.jpg 380B
default.js 678B
index.jsp 5KB
detailInfo.jsp 5KB
edit1.jsp 4KB
register.jsp 4KB
logon.jsp 4KB
reginfo.jsp 3KB
registerok.jsp 3KB
datas.jsp 3KB
view.jsp 3KB
index.jsp 3KB
reginfo.jsp 3KB
login.jsp 3KB
datas2.jsp 2KB
adedit.jsp 2KB
reg.jsp 2KB
student.jsp 2KB
sjob.jsp 2KB
edit2.jsp 2KB
edit3.jsp 2KB
mreginfo.jsp 2KB
cjob.jsp 1KB
vjobinfo.jsp 1KB
Left-guard.jsp 1KB
company.jsp 1KB
aflink.jsp 1KB
logoff.jsp 1KB
vjobinfo.jsp 1KB
共 130 条
- 1
- 2
资源评论
寒泊
- 粉丝: 76
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功