Java程序设计 简易银行系统

主函数

public class test123 {

/**

* @param args

*/

public static void main(String[] args) {

System.out.println("nissmr");

testbank1 bank=new testbank1();

}

}

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.Scanner;

/*银行账户管理系统主界面DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=Bank","sa","1234 56");*/

public class testbank1 {

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

public static String

driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动

public static String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=Bank"; //连接服务器和数据库

public static String userName = "sa"; //默认用户名

public static String userPwd = "123456"; //密码

public static Connection dbconn;

static boolean m=true;

static int N;

public testbank1() {

System.out.println("欢迎银行账户管理系统!");

while(true)

{

try{

do{

System.out.println("请输入登录名：");

userName=scanner.next();

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

userPwd=scanner.next();

if(("sa".equals(userName))&&("123456".equals(userPwd)))

{

while(m){

System.out.println("---------------银行账户管理系统---------------");

System.out.println("1:添加账户2：删除账户");

System.out.println("3:修改账户信息4:查询账户信息");

System.out.println("5:浏览6:存款");

System.out.println("9:退出");

System.out.println("-------------请输入您要进行的服务---------");

N=scanner.nextInt();

switch(N){

case 1:insert();//添加账户功能

break;

case 2:del();//删除账户

break;

case 3:update();//修改账户信息

break;

case 4:serch();//查询账户信息

break;

case 5:liulan();//浏览全部账户信息

break;

case 6:cunkuan();//存款

break;

case 9:System.out.println("系统已安全退出！");

m=false;

break;

default:

System.out.println("请在1--9之间选择");

}}

break;}

else

System.out.println("登录名或密码错误重新输入");

}

while(true);

}

catch(Exception e){

System.out.println("输入有误请重新输入");

continue;

}

}}

private void insert() {

try{Class.forName(driverName);//载入驱动

//dbconn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=Bank"," sa","123456");

dbconn=DriverManager.getConnection(dbURL,userName,userPwd);//连接数据库

String num=null,name=null;

int jine=0;

System.out.println("请输入您要添加的数据");

System.out.print("账号");

num=scanner.next();

System.out.print("姓名");

name=scanner.next();

System.out.print("金额");

jine=scanner.nextInt();

String sql="insert into Bank (num,name,jine) "

+"values('"+num+"','"+name+"','"+jine+"')";//向表中插入信息

System.out.println("信息已插入！");

Statement stmt=dbconn.createStatement();//用于查询与更新

stmt.executeUpdate(sql);//

stmt.close();}//关闭连接

catch(Exception e)

{

}

m=true;

}

// TODO Auto-generated method stub

private void del() {

try{String num=null,name=null;

int jine=0;

String a=null;

Class.forName(driverName);//载入驱动

dbconn=DriverManager.getConnection(dbURL,userName,userPwd);//连接数据库

System.out.println("---删除账户---");

String sql1="select*from Bank";