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

用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. 条件查询图书信息: ");

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

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

System.out.println(" 3. 多表连接查询图书信息: ");

System.out.println(" 4. 嵌套查询图书信息: ");

System.out.println(" 5. 谓词演算查询");

int c12=scanner.nextInt();

switch(c12){

case 1:

System.out.println(" 1.单条件查询: ");

System.out.println(" 1.按图书名编码号查询图书信息: ");

int ddd=0;

while(ddd!=1){

System.out.println("请输入图书编码号:");

String A=scanner.next();

String sql1= "SELECT * FROM systembook WHERE bookID ='"+A+"' ";

rs= stmt.executeQuery(sql1);

int x=0;

while(rs.next())

{

String a2 =rs.getString(1);