一个简单的JAVA和ACCESS数据库写的库户信息管理系统.docxVIP

//一个简单的JAVA和ACCESS写的用户信息管理程序。import java.sql.*;import java.util.Scanner;import java.util.Random;public class Customer {public static void main(String args[]) {Scanner input = new Scanner(System.in);Connection con;Statement sql;ResultSet rs = null;String username, chioce = y;int option = 0,i;try {Class.forName(sun.jdbc.odbc.jdbcOdbcDriver);} catch (ClassNotFoundException e) {System.out.println();}while (y.equals(chioce)) { System.out.println(*******欢迎使用大富翁客户抽奖系统*******);System.out.println(****************************************);System.out.println(************ 1 客户注册 **************);System.out.println(************ 2 客户信息 **************);System.out.println(************ 3 客户登录 **************);System.out.println(************ 4 参与抽奖 **************);System.out.println(****************************************);System.out.println(请输入所选操作序号：);int number = input.nextInt();switch (number) {case 1:for (;;) {System.out.println(请输入姓名：);username = input.next();try {con = DriverManager.getConnection(jdbc:odbc:test, ,);sql = con.createStatement();rs = sql.executeQuery(SELECT * FROM Customer where user=+ username + );if (rs.next())System.out.println(用户名已被注册，请重新输入！);elsebreak;con.close();} catch (SQLException e) {System.out.println(e);}}System.out.println(请输入密码：);int mima = input.nextInt();try {con = DriverManager.getConnection(jdbc:odbc:test, , );sql = con.createStatement();int indata = sql.executeUpdate(INSERT INTO Customer(user,password) VALUES(+ username + , + mima + ));con.close();} catch (SQLException e) {System.out.println(e);}System.out.println(注册成功！);System.out.println(是否继续 y（是）/n（否）：);chioce = input.next();break;case 2:System.out.println(此操作需要管理员权限，请登录管理员帐号：);System.out.print(帐号：);String admin = input.next();System.out.print(密码：);int adminnub = input.nextInt();if (admin.equals(admin) adminnub == 123456) {System.out.println(***************************************);System.out.println(1 查看指定用户信息);System.out.println(2 客户所有用户信息);System.out.print