//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