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

本程序使用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");