tring("账号");
if( num.equals(a))
{
System.out.print("请输入您更改的:");
name = scanner.next();
System.out.print("请输入您更改的金额");
jine = scanner.nextInt();
flag=1;
break;
}
}
if(flag==1)
break;
else
{
System.out.println("您输入的账号错误或者不存在,请重新输入:");
num = scanner.next();
rs = stmt1.executeQuery(sql1);
}
}
rs.close();
stmt1.close();
String sql2 = "update 账户信息 set = '"+ name +"' where 账号 = '"+ num +"'update 账户信息 set 金额 = '"+ jine +"' where 账号 = '"+ num +"'";
Statement stmt = dbconn.createStatement();
System.out.println("数据已更改");
stmt.executeUpdate(sql2);
stmt.close();
}
catch (Exception e)
{
}
m = true;
}
2.6查询账户信息
public static void serch()throws Exception
{
try
{
String num= null,name = null ;
int jine=0;
String a=null;
Class.forName(driverName);//载入驱动
dbconn = DriverManager.getConnection(dbURL,userName,userPwd);//连接数据库
System.out.println("---按账号查询---");
System.out.print("请输入账号");
String sql1 = "select * from 账户信息";
Statement stmt1 = dbconn.createStatement();
ResultSet rs1 = stmt1.executeQuery(sql1);
num = scanner.next();
int flag=0;
while(!num.equals("0"))
{
while(rs1.next())
{
a = null;
a = rs1.getString("账号");
if(num.equals(a))
{
flag = 1;
break;
}
}
if(flag == 1)
{
name = rs1.getString("");
jine = rs1.getInt("金额");
break;
}
else
{
System.out.println("您输入的账号错误或者不存在,请重新输入:");
num = scanner.next();
rs1 = stmt1.executeQuery(sql1);
}
}
System.out.println("账号 金额");
System.out.printf("%s %s %s %n",nu
上一篇:
银行信息管理系统论文
下一篇:
不放弃终有希望