给个用户登录给你看看 public WebUser authUser(String user,String pass){
Statement stmt =null;
Connection useCon =null;
WebUser us = new WebUser();
try{
Vector reRes = new Vector();
useCon = dbConn.getConn() ;
stmt = useCon.createStatement();
ResultSet res = stmt.executeQuery("select user_id,password,level,"+
"status from SYSTEM_USER where user_id ='"+user+"' and password='"+pass+"' and status=0");
if(res.next()){
int status = res.getInt("status");
if(status!=0){
return null;
} else{
String id = res.getString("user_id").trim();
String pa = res.getString("password").trim();
String le = res.getString("level");
us.setLevel(le);
us.setPassword(pa);
us.setUserName(id);
return us;
}
}
return null;
}catch(Exception f){
f.printStackTrace();
return null;
}finally{
try{
stmt.close();
useCon.close();
}catch(Exception f){}
}
}
Statement stmt =null;
Connection useCon =null;
WebUser us = new WebUser();
try{
Vector reRes = new Vector();
useCon = dbConn.getConn() ;
stmt = useCon.createStatement();
ResultSet res = stmt.executeQuery("select user_id,password,level,"+
"status from SYSTEM_USER where user_id ='"+user+"' and password='"+pass+"' and status=0");
if(res.next()){
int status = res.getInt("status");
if(status!=0){
return null;
} else{
String id = res.getString("user_id").trim();
String pa = res.getString("password").trim();
String le = res.getString("level");
us.setLevel(le);
us.setPassword(pa);
us.setUserName(id);
return us;
}
}
return null;
}catch(Exception f){
f.printStackTrace();
return null;
}finally{
try{
stmt.close();
useCon.close();
}catch(Exception f){}
}
}
主要是数据库中的name字段进行对比 使他不出现相同用户名
跳出
}
else{
添加
}
如果有记录则跳过,没有记录则添加