Java连接mysql数据库源代码(4)

本程序使用Java+Mysql进行编写,其中主要是对数据库进行数据的更新及维护工作,主要界面为DOS界面,如有兴趣的同仁,可修改成GUI界面的,方便进行操作及管理。

-----------------------------");

String ReUseNameValue=null;

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();