用java做的一个图书管理系统的源代码

用java做的一个图书管理系统的源代码import java.sql.*;

import java.util.*;

public class T{

public static void main(String[] args) throws Exception{ Connection conn=null;

Statement stmt=null;

ResultSet rs=null;

while(true)

{Scanner scanner=new Scanner(System.in);

System.out.println("请输入用户名：");

String username2=scanner.next();

System.out.println("请输入密码：");

String password2=scanner.next();

if(!(username2.equals("")||password2.equals(""))){ try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

conn=DriverManager.getConnection("jdbc:odbc:book","","");

String sql="select * from ww where username='"+username2+"'"; stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

if(rs.next())

{

if(rs.getString("password").equals(password2))

{

System.out.println("*********欢迎来科技大学图书馆管理系统********");

while(true)

{

System.out.println(" 1.图书信息");

System.out.println(" 2.读者信息");

System.out.println(" 3.管理员信息");

System.out.println(" 4.借阅信息");

System.out.println(" 5.还书信息");

System.out.println(" 6.逾期罚款或损坏赔偿信息");

//System.out.println(" 7.退出");

System.out.println(" 请输入选择功能的序号:"); int a=scanner.nextInt();

switch(a){

case 1:

System.out.println(" 图书信息: ");

System.out.println(" 1. 查询图书信息: ");

System.out.println(" 2. 插入图书信息: ");

System.out.println(" 3. 删除图书信息: ");

System.out.println(" 4. 修改图书信息: ");

int a1=scanner.nextInt();

switch(a1)

{

case 1:

System.out.println(" 欢迎进入图书信息查询系统: ");

System.out.println(" 1. 无条件查询图书信息: ");

System.out.println(" 2. 条件查询图书信息: ");

int d=scanner.nextInt();

switch(d){

case 1:

int llll=0;

//int mm=0;

while(llll!=1){

System.out.println(" 1. 无条件查询图书信息: ");

String Sql0 = "SELECT * FROM systembook ";

rs= stmt.executeQuery(Sql0);

while(rs.next()){

String bookID =rs.getString(1);

String bookNo =rs.getString(2);

String bookName =rs.getString(3);

String bookWriter =rs.getString(4);

String bookPub =rs.getString(5);

System.out.println(bookID+","+bookNo+","+bookName+","+ bookWriter+","+bookPub);

}

System.out.println("是否继续插入？yes/no no返回主菜单");

String k=scanner.next();

if(k.startsWith("yes"))

{

System.out.println();

};

if(k.startsWith("no"))

{

llll=1;

System.out.println();

};

}

break;

//break;

case 2:

System.out.println(" 2. 条件查询图书信息: ");