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

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

System.out.println("是否退出系统？ 返回主菜单（m） 退出（e)"); MenuExitValue=(char)System.in.read();

}while(MenuExitValue!='e');

System.out.println("程序已结束！");

}

/*

the Program is to Select the database!!!

*/

public void Mysql_ConnectExecute_Select(String UseNameValue,String KeyIDValue,String UrlinforValue)

{

String SelectDriver="com.mysql.jdbc.Driver";

String Select_By_Usename,Select_By_KeyID,Select_By_Urlinfor; int SelectStyleValue;

Scanner EntryValue=new Scanner(System.in);

try {

Class.forName(SelectDriver);

Connection conn=DriverManager.getConnection(UrlinforValue, UseNameValue, KeyIDValue);

if(!conn.isClosed())

{

Statement statement=conn.createStatement();

System.out.println("请选择查询的方式：1、按姓名查询 2、按密码查询 3、按网址查询 4、全部显示");

SelectStyleValue=EntryValue.nextInt();

switch (SelectStyleValue){

case 1:

System.out.println("请输入要查找的用户名：");

Select_By_Usename=EntryValue.next();

String SelectExecuteState="select * from urlinformation where usename='"+Select_By_Usename+"'";

ResultSet rs=statement.executeQuery(SelectExecuteState);

System.out.println("---------------------------------------------------------------------");

System.out.println("the result is:");

System.out.println("---------------------------------------------------------------------");

System.out.println("Name"+" "+"keyid"+" "+"urlinfor");

System.out.println("----------------------------------------