package tushuManagement;
import tushuManagement.reader;
public class readerManage {
private reader reader1=null;
java.sql.Connection cn1=null;
java.sql.Statement st=null;
java.sql.ResultSet rs=null;
String sql="";
public readerManage()
{
cn1=DBconnection.getConnection();
}
public boolean Insertreader(int readernum,String readername, String readersex, java.sql.Date birthday, String readertype)
{
boolean f=false;
sql="insert into reader values('"+readernum+"','"+readername+"','"+readersex+"','"+birthday+"','"+readertype+"')";
int n=0;
try
{
st=cn1.createStatement();
n=st.executeUpdate(sql);
if(n>0)
{
f=true;
}
else
{
f=false;
}
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
finally
{
try
{
st.close();
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
}
return f;
}
public boolean Searchreader(int readernum)
{
boolean f=false;
sql="select * from reader where readernum = "+readernum;
try
{
st=cn1.createStatement();
rs=st.executeQuery(sql);
if(rs.next())
{
reader1=new reader(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getDate(4),rs.getString(5));
f=true;
}
else
{
f=false;
}
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
finally
{
try
{
rs.close();
st.close();
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
}
return f;
}
public boolean deletereader(int readernum)
{
boolean f=false;
sql="delete from reader where readernum = "+readernum;
int n=0;
try
{
st=cn1.createStatement();
n=st.executeUpdate(sql);
if(n>0)
{
f=true;
}
else
{
f=false;
}
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
finally
{
try
{
st.close();
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
}
return f;
}
public boolean Updatereader(int readernum,String readername, String readersex, java.sql.Date birthday, String readertype)
{
boolean f=false;
sql="update reader set [readername]='"+readername+"',[readersex]='"+readersex+"',[birthday]='"+birthday+"',[readertype]='"+readertype+"' where readernum="+readernum;
int n=0;
try
{
st=cn1.createStatement();
n=st.executeUpdate(sql);
if(n>0)
{
f=true;
}
else
{
f=false;
}
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
finally
{
try
{
st.close();
}
catch(java.sql.SQLException cnfe)
{
System.out.println(cnfe.getMessage());
}
}
return f;
}
public void setreader1(reader reader1) {
this.reader1 = reader1;
}
public reader getreader1() {
return reader1;
}
}
图书馆管理系统（html+jsp+javabean代码）
5星 · 超过95%的资源 需积分: 19 189 浏览量
2011-01-07
09:38:32
上传
评论 17
收藏 58KB ZIP 举报 
tushu.zip （57个子文件） 
tushu .settings 
org.eclipse.wst.jsdt.ui.superType.name 6B org.eclipse.wst.jsdt.ui.superType.container 49B .jsdtscope 500B org.eclipse.jdt.core.prefs 330B src tushuManagement book.java 1KB DBconnection.java 695B user.java 783B reader.java 1KB userManage.java 1KB disk.java 1KB readerManage.java 4KB bookManage.java 4KB diskManage.java 4KB .project 1KB WebRoot addreader.jsp 1KB
deletebook.html 966B deletedisk.jsp 853B addbook.html 2KB searchreader.html 996B updatedisk.jsp 1KB deletereader.html 969B searchbooks.html 1KB META-INF MANIFEST.MF 36B searchdisk.html 991B WEB-INF web.xml 371B classes tushuManagement reader.class 2KB userManage.class 2KB bookManage.class 4KB diskManage.class 4KB disk.class 2KB readerManage.class 4KB user.class 1KB DBconnection.class 1KB book.class 1KB lib deletebook.jsp 851B updatebook.jsp 1KB searchdisks.html 1KB searchdisk.jsp 3KB addreader.html 2KB deletedisk.html 964B adddisk.jsp 1KB index.html 1KB deletereader.jsp 871B adddisk.html 2KB logon.jsp 1KB admin.html 2KB searchdisks.jsp 2KB addbook.jsp 1KB normal.html 723B searchbook.html 994B searchreader.jsp 3KB updatereader.jsp 1KB searchbooks.jsp 2KB searchbook.jsp 3KB .mymetadata 288B .classpath 362B .myeclipse tushu.mdb 420KB
评论14