while(rs.next()) {
ReUseNameValue = rs.getString("usename");
ReUseNameValue=new
String(ReUseNameValue.getBytes("ISO-8859-1"),"GB2312");
System.out.println(ReUseNameValue+" "+rs.getString("Keyid")+" "+rs.getString("urlinfor"));
}
rs.close();
break;
case 2:
System.out.println("请输入要查找的密码：");
Select_By_KeyID=EntryValue.next();
String SelectExecuteStateValue="select * from urlinformation where keyid='"+Select_By_KeyID+"'";
ResultSet rsk=statement.executeQuery(SelectExecuteStateValue); System.out.println("---------------------------------------------------------------------");
System.out.println("the result is:");
System.out.println("---------------------------------------------------------------------");
System.out.println("Name"+" "+"keyid"+" "+"urlinfor");
System.out.println("---------------------------------------------------------------------");
String ReKeyIDValue=null;
while(rsk.next()){
ReKeyIDValue=rsk.getString("keyid");
ReKeyIDValue=new
String(ReKeyIDValue.getBytes("ISO-8859-1"),"GB2312");
System.out.println(rsk.getString("usename")+" "+ReKeyIDValue+" "+ rsk.getString("urlinfor"));
}
rsk.close();
break;
case 3:
System.out.println("请输入要查找的网址：");
Select_By_Urlinfor=EntryValue.next();
本程序使用Java+Mysql进行编写,其中主要是对数据库进行数据的更新及维护工作,主要界面为DOS界面,如有兴趣的同仁,可修改成GUI界面的,方便进行操作及管理。
String SelectExecuteStateValueUrl="select * from urlinformation where urlinfor='"+Select_By_Urlinfor+"'";
ResultSet
rsu=statement.executeQuery(SelectExecuteStateValueUrl);
System.out.println("---------------------------------------------------------------------");
System.out.println("the result is:");
System.out.println("---------------------------------------------------------------------");
System.out.println("Name"+" "+"keyid"+" "+"urlinfor");
System.out.println("---------------------------------------------------------------------");
String ReUrlinforValue=null;
while(rsu.next()){
ReUrlinforValue=rsu.getString("urlinfor");
try {
ReUrlinforValue=new
String(ReUrlinforValue.getBytes("ISO-8859-1"),"GB2312");
} catch (UnsupportedEncodingException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
System.out.println(rsu.getString("usename")+" "+rsu.getString("keyid")+" "+ReUrlinforValue);
}
rsu.close();
break;
case 4:
String SelectAllRecord="select * from urlinformation"; ResultSet rsa=statement.executeQuery(SelectAllRecord);
System.out.println("---------------------------------------------------------------------");
System.out.println("the result is:");
System.out.println("---------------------------------------------------------------------");
System.out.println("Name"+" "+"keyid"+" "+"urlinfor");
System.out.println("---------------------------------------------------------------------");
String ReAllRecordValue=null;
while(rsa.next())
{
ReAllRecordValue=rsa.getString("usename");
本程序使用Java+Mysql进行编写,其中主要是对数据库进行数据的更新及维护工作,主要界面为DOS界面,如有兴趣的同仁,可修改成GUI界面的,方便进行操作及管理。
ReAllRecordValue=new
String(ReAllRecordValue.getBytes("ISO-8859-1"),"GB2312");
System.out.println(rsa.getString("usename")+" "+rsa.getString("keyid")+" "+rsa.getString("urlinfor")); }
break;
default:
System.out.println("你输入非法的字符！");
}
}
conn.close();
} catch (UnsupportedEncodingException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
/*
the Program is to Select the database!!!
*/
public void Mysql_ConnectExecute_Insert(String UseNameValue,String KeyIDValue,String UrlinforValue)