|
|
|
| |
.jdbcodbcdriver");//连接数据库
connection c=drivermanager.getconnection("jdbc:odbc:javaicq"," "," ");
string sql="select nickname,password from icq where icqno=?";
//准备从数据库选择呢称和密码
preparedstatement prepare=c.preparecall(sql);//设定数据库查寻条件
string icqno=in.readline();
int g=integer.parseint(icqno);//取得输入的jicq号码
system.out.println(icqno);
string passwd=in.readline().trim();//取得输入的密码
system.out.println(passwd);
prepare.clearparameters();
prepare.setint(1,g);//设定参数
resultset r=prepare.executequery();//执行数据库查寻
if(r.next()){//以下比较输入的号码于密码是否相同
string pass=r.getstring("password").trim();
system.out.println(pass);
if(passwd.regionmatches(0,pass,0,pass.length()))
{ out.println("ok");
//如果相同就告诉客户ok
//并且更新数据库用户为在线
//以及注册用户的ip 地址
//*************register ipaddress
string setip="update icq set ip=? where icqno=?";
preparedstatement prest=c.preparecall(setip);
prest.clearparameters();
prest.setstring(1,socket.getinetaddress().gethostaddress());
prest.setint(2,g);
int set=prest.executeupdate();
system.out.println(set);
//*************ipaddress
//set status online
string status="update icq set status=1 where icqno=?";
preparedstatement prest2=c.preparecall(status);
prest2.clearparameters();
prest2.setint(1,g);
int set2=prest2.executeupdate();
system.out.println(set2);
//set online
}
//否者告诉客户失败
else out.println("false");r.close();c.close();}
else{ out.println("false");
system.out.println("false");
r.close();
c.close();}
}catch (exception e){e.printstacktrace();}
socket.close();
}//end login
//登录结束
//以下为处理客户的新建请求
else if(str.equals("new")){
try{ class.forname("sun.jdbc.odbc.jdbcodbcdriver");//连接数据库
connection c2=drivermanager.getconnection("jdbc:odbc:javaicq"," "," ");
string newsql="insert into icq(nickname,password,email,info,place,pic) values(?,?,?,?,?,?)";
//准备接受用户的呢称，密码，email，个人资料，籍贯，头像等信息
preparedstatement prepare2=c2.preparecall(newsql);
string nickname=in.readline().trim();
string password=in.readline().trim();
string email=in.readline().trim();
string info=in.readline().trim();
strin上一页 [1] [2] [3] [4] [5] [6] [7] [8] 下一页 |
|
|
|
|
|