JAVA课程设计-银行存取管理系统(所有代码)

//1.注册驱动

String driverClassName = \;

Class.forName(\); //2.连接数据库 Connection conn =

DriverManager.getConnection(\,\,\);

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(\UserID='\+Integer.parseInt(a.Kahao.getText())+\);

if(rs.next()) {

stmt.executeUpdate(\

Usersex='\+sex+\+name+\+phone+\UserID='\+Integer.parseInt(a.Kahao.getText())+\); rs.close(); stmt.close(); conn.close(); return 1; }

}

catch(Exception sqle){

System.err.println(sqle); return 3; } }

public static int gaimi(String y,String x) {

long p; if(p==1) { try{ return 2;

p=checkUser(a.Kahao.getText(),y);

//1.注册驱动

String driverClassName = \;

Class.forName(\); //2.连接数据库 Connection conn =

DriverManager.getConnection(\,\,\);

Statement stmt=conn.createStatement();

13

ResultSet rs=stmt.executeQuery(\UserID='\+Integer.parseInt(a.Kahao.getText())+\); if(rs.next()) {

stmt.executeUpdate(\+x+\UserID='\+Integer.parseInt(a.Kahao.getText())+\); rs.close(); stmt.close(); conn.close(); return 1; }

}

catch(Exception sqle){

System.err.println(sqle); return 3; } }

public static long chaxun() {

long j; try{ }

return 2;

//1.注册驱动

String driverClassName = \;

Class.forName(\); //2.连接数据库 Connection conn =

DriverManager.getConnection(\,\,\);

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(\UserID='\+Integer.parseInt(a.Kahao.getText())+\);

if(rs.next()) {

j=rs.getInt(\); rs.close(); stmt.close(); conn.close(); return j;

14

}

}

catch(Exception sqle){

System.err.println(sqle); return -2; } }

public static int qukuan(long k,long j) {

try{

//1.注册驱动

String driverClassName = \;

return -2;

Class.forName(\); //2.连接数据库 Connection conn =

DriverManager.getConnection(\,\,\);

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(\UserID='\+k+\);

if(rs.next())

{ j=rs.getInt(\)-j; if(j<0) return 2;

stmt.executeUpdate(\+j+\UserID='\+k+\); rs.close(); stmt.close(); conn.close(); return 1; }

}

catch(Exception sqle){

System.err.println(sqle); return 3; }

return 0;

15

}

public static int cunkuan(long k,long j) {

try{

//1.注册驱动

String driverClassName = \;

Class.forName(\); //2.连接数据库 Connection conn =

DriverManager.getConnection(\,\,\);

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(\UserID='\+k+\);

if(rs.next())

{ j=rs.getInt(\)+j;

stmt.executeUpdate(\+j+\UserID='\+k+\); rs.close(); stmt.close(); conn.close(); return 1; }

}

catch(Exception sqle){

System.err.println(sqle); return 2; } }

public static int zhuanzhang(long k,long j) {

long i = 0; long p = 0;

i=Denlu.cunkuan(k, 0); if(i==1) {

p=Denlu.qukuan(Integer.parseInt(a.Kahao.getText()), j); if(p==1) { return 0;

16