java+sql实现图书管理系统

2011-06-26 07:49:06 801 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

a20309394 墨衍会员 · AI 创作全网分发关注 + 加入社区

java数据库课程设计图书管理系统_数据库课程设计：图书管理系统（JAVA源码+sql server数据库)... 【实例简介】开发工具：MyEclipse、SQL Server 2008，基本的图书管理系统，包含增删改查、java图形界面，数据库技术包含存储过程与触发器。【调试步骤】0. 执行数据库脚本或者附加数据库以达到让数据库可用的目的1. 修改源码中的数据库密码为您本地的密码2. 输入管理员账号密码admin1/admin1 即可看到如下界面【实例截图】读者登陆如下：【核心代码】package M... 阅读详情

由于刚学java跟数据库，所以了解并不多。自己弄了个图书管理系统，管理员登录界面可以与数据库连接，但到了借书跟还书功能的时候却连接不上，代码本身没提示出错，也没有抛出异常。求高手解决解决

...全文

java Swing实现图书管理系统 1.图书管理系统技术架构主要技术 Java Swing 开发工具和环境 Eclipse JDK 1.7 Mysql 5.6 Win10 操作系统 2.图书管理系统数据库设计 CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `passwor... 阅读详情

a20309394

Eclipse 58,439 成员 49,457 内容

+ 关注 + 加入社区

切换为时间正序

a20309394 2011-06-27

打赏
举报

没抛出异常，也没报错，所以找不到问题原因

zn85600301 2011-06-27

打赏
举报

贴异常信息

lxx19871013 2011-06-27

打赏
举报

分析分析源码

newsyz 2011-06-27

打赏
举报

同意楼上的

c2473360686 2011-06-26

打赏
举报

学习。

a20309394 2011-06-26

打赏
举报

这是连接读者的数据库的，至于连接图书信息的也就差不多，也是连接不上。还有因为我们是初学，所以是用eclipse完成的

a20309394 2011-06-26

打赏
举报

public boolean modifyReader(String id,String id1,String name,String sex,
String age,String school,String professional, String time,String total,String info){
boolean yn = false;
Connection conn = null;
PreparedStatement ps = null;

try {
conn = new dbconnect().getConnection();
String sql = "update t_reader set reader_id=?,reader_id1=?,reader_name=?,reader_age=?" +
"reader_sex=?,reader_school=?,reader_professional=? where reader_time=?,reader_total=?,reader_info=?";
ps = conn.prepareStatement(sql);
int index = 0;
ps.setString(++index, id);
ps.setString(++index, id1);
ps.setString(++index, name);
ps.setString(++index, age);
ps.setString(++index, sex);
ps.setString(++index, school);
ps.setString(++index, professional);
ps.setString(++index, time);
ps.setString(++index, total);
ps.setString(++index, info);
if(ps.executeUpdate()>0){
yn = true;
}

}
catch(Exception ex){
System.out.println("in Class ReaderDao-->modifyReader [error]:"+ex.getMessage());
}
finally{
try{
if(conn != null)
conn.close();
if(ps != null)
ps.close();
}
catch(Exception e){}
}
return yn;

}

public boolean deleteReader(String id){
boolean yn = false;
Connection conn = null;
PreparedStatement ps = null;

try {
conn = new dbconnect().getConnection();
String sql = "delete from t_reader where reader_id=? ";
ps = conn.prepareStatement(sql);
int index = 0;
ps.setString(++index, id);

if(ps.executeUpdate()>0){
yn = true;
}

}
catch(Exception ex){
System.out.println("in Class ReaderDao-->deleteReader [error]:"+ex.getMessage());
}
finally{
try{
if(conn != null)
conn.close();
if(ps != null)
ps.close();
}
catch(Exception e){}
}
return yn;

}

public String getReader_id() {
return reader_id;
}
public void setReader_id(String readerId) {
reader_id = readerId;
}
public String getReader_id1() {
return reader_id1;
}
public void setReader_id1(String readerId1) {
reader_id1 = readerId1;
}
public String getReader_name() {
return reader_name;
}
public void setReader_name(String readerName) {
reader_name = readerName;
}
public String getReader_age() {
return reader_age;
}
public void setReader_age(String readerAge) {
reader_age = readerAge;
}
public String getReader_sex() {
return reader_sex;
}
public void setReader_sex(String readerSex) {
reader_sex = readerSex;
}
public String getReader_school() {
return reader_school;
}
public void setReader_school(String readerSchool) {
reader_school = readerSchool;
}
public String getReader_professional() {
return reader_professional;
}
public void setReader_professional(String readerProfession) {
reader_professional = readerProfession;
}
public String getReader_time() {
return reader_time;
}
public void setReader_time(String readerTime) {
reader_time = readerTime;
}
public String getReader_total() {
return reader_total;
}
public void setReader_total(String readerTotal) {
reader_total = readerTotal;
}
public String getReader_info() {
return reader_info;
}
public void setReader_info(String readerInfo) {
reader_info = readerInfo;
}

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub

}

}

a20309394 2011-06-26

打赏
举报

比如借书部分的代码：（db连接数据库部分代码就省了，其中查询id=读者编号，id1=读者学号，professional=系别，time=借书日期，total=借书总量，info=简介；估计也就是这部分代码出问题了）
public class ReaderDao {
private String reader_id = "";
private String reader_id1 = "";
private String reader_name = "";
private String reader_age = "";
private String reader_sex = "";
private String reader_school = "";
private String reader_professional = "";
private String reader_time = "";
private String reader_total = "";
private String reader_info = "";

public ArrayList getReaders(){
return getReaders(null,null,null,null,null,null,null,null,null,null);
}

public ArrayList getReaders(String id,String id1,String name,String age,String sex,
String school,String professional,String time,String total,String info){
ArrayList al = new ArrayList();
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;

try {
conn = new dbconnect().getConnection();
String sql = "select * from t_reader where 1<2 ";
if(id!=null && !id.equals("")) sql += " and reader_id like ? ";
if(id1!=null && !id1.equals("")) sql += " and reader_id1 like ? ";
if(name!=null && !name.equals("")) sql += " and reader_name like ? ";
if(age!=null && !age.equals("")) sql += " and reader_age like ? ";
if(sex!=null && !sex.equals("")) sql += " and reader_sex like ? ";
if(school!=null && !school.equals("")) sql += " and reader_school like ? ";
if(professional!=null && !professional.equals("")) sql += " and reader_professional like ? ";
if(time!=null && !time.equals("")) sql += " and reader_time like ? ";
if(total!=null && !total.equals("")) sql += " and reader_total like ? ";
if(info!=null && !info.equals("")) sql += " and reader_info like ? ";
ps = conn.prepareStatement(sql);
int index = 0;
if(id!=null && !id.equals("")) ps.setString(++index, "%"+id+"%");
if(id1!=null && !id1.equals("")) ps.setString(++index, "%"+id1+"%");
if(name!=null && !name.equals("")) ps.setString(++index, "%"+name+"%");
if(age!=null && !age.equals("")) ps.setString(++index, "%"+age+"%");
if(sex!=null && !sex.equals("")) ps.setString(++index, "%"+sex+"%");
if(school!=null && !school.equals("")) ps.setString(++index, "%"+school+"%");
if(professional!=null && !professional.equals("")) ps.setString(++index, "%"+professional+"%");
if(time!=null && !time.equals("")) ps.setString(++index, "%"+time+"%");
if(total!=null && !total.equals("")) ps.setString(++index, "%"+total+"%");
if(info!=null && !info.equals("")) ps.setString(++index, "%"+info+"%");

rs = ps.executeQuery();
//System.out.println("in ynpass rs="+rs);
while (rs.next()) {
String sid = rs.getString("reader_id")==null?"":rs.getString("reader_id").trim();
String sid1 = rs.getString("reader_id1")==null?"":rs.getString("reader_id1").trim();
String sname = rs.getString("reader_name")==null?""
:rs.getString("reader_name").trim();
String sage = rs.getString("reader_age")==null?""
:rs.getString("reader_age").trim();
String ssex = rs.getString("reader_sex")==null?""
:rs.getString("reader_sex").trim();
String sschool = rs.getString("reader_school")==null?""
:rs.getString("reader_school").trim();
String sprofessional = rs.getString("reader_professional")==null?""
:rs.getString("reader_professional").trim();
String stime = rs.getString("reader_time")==null?""
:rs.getString("reader_time").trim();
String stotal = rs.getString("reader_total")==null?""
:rs.getString("reader_total").trim();
String sinfo = rs.getString("reader_info")==null?""
:rs.getString("reader_info").trim();
//System.out.println();
ReaderDao stu = new ReaderDao();
stu.setReader_id(sid);
stu.setReader_id1(sid1);
stu.setReader_name(sname);
stu.setReader_sex(ssex);
stu.setReader_age(sage);
stu.setReader_school(sschool);
stu.setReader_professional(sprofessional);
stu.setReader_time(stime);
stu.setReader_total(stotal);
stu.setReader_info(sinfo);
al.add(stu);
}

}
catch(Exception ex){
System.out.println("in Class ReaderDao-->getReaders [error]:"+ex.getMessage());
}
finally{
try{
if(conn != null)
conn.close();
if(ps != null)
ps.close();
if(rs != null)
rs.close();
}
catch(Exception e){}
}
return al;
}

public boolean addReader(String id,String name,String sex,
String school,String professional, String id1, String age, String time, String total, String info){
boolean yn = false;
Connection conn = null;
PreparedStatement ps = null;

try {
conn = new dbconnect().getConnection();
String sql = "insert into t_reader(reader_id,reader_id1,reader_name,reader_age" +
"reader_sex,reader_school,reader_professional" +
"reader_time,reader_total,reader_info) values(?,?,?,?,?,?) ";
ps = conn.prepareStatement(sql);
int index = 0;
ps.setString(++index, id);
ps.setString(++index, id1);
ps.setString(++index, name);
ps.setString(++index, age);
ps.setString(++index, sex);
ps.setString(++index, school);
ps.setString(++index, professional);
ps.setString(++index, time);
ps.setString(++index, total);
ps.setString(++index, info);
if(ps.executeUpdate()>0){
yn = true;
}

}
catch(Exception ex){
System.out.println("in Class ReaderDao-->addReader [error]:"+ex.getMessage());
}
finally{
try{
if(conn != null)
conn.close();
if(ps != null)
ps.close();
}
catch(Exception e){}
}
return yn;

}

qybao 2011-06-26

打赏
举报

连异常都没有？是不是象什么借书方法之类的根本都没调用

TKD03072010 2011-06-26

打赏
举报

这个....
不好猜出哪里出错
贴源码吧
楼主

java+sql实现图书管理系统

相关推荐