Java连接mysql数据库源代码

Java连接mysql数据库源代码

/**

*@author mervyn

*@Development_time 2011.3.12

*welcome to /mervyn_hb

*/

package src;

import java.io.IOException;

import java.io.UnsupportedEncodingException;

import java.sql.*;

import java.util.*;

public class MysqlConnectSystem {

/**

* @param args

* @throws IOException

*/

public static void main(String[] args) throws SQLException, IOException {

String Usename,KeyID,UrlString;

//String DriverConnect;

char MenuExitValue;

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

Scanner EntryValue=new Scanner(System.in);

System.out.println("欢迎使用MysqlConnectSystem信息管理系统！");

MysqlConnectSystem mysqlconnect=new MysqlConnectSystem();

MysqlConnectSystem mysqlinsert=new MysqlConnectSystem();

MysqlConnectSystem mysqlupdate=new MysqlConnectSystem();

MysqlConnectSystem mysqldelete=new MysqlConnectSystem();

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

Usename=EntryValue.next();

System.out.println("请输入要登录的数据库的密码：");

KeyID=EntryValue.next();

System.out.println("请输入需要登录的数据库：");

UrlString="jdbc:mysql://127.0.0.1:3306/"+EntryValue.next();

do{

try {

Class.forName(driver);

Connection conn=DriverManager.getConnection(UrlString, Usename,

KeyID);

if(!conn.isClosed())

{

int MenuSelectValue;

System.out.println("Succeeded connectint to the database company!!");

System.out.println("请选择需要的操作：1、查询数据 2、插入数据 3、更新数据 4、删除数据 ");

MenuSelectValue=EntryValue.nextInt();

switch (MenuSelectValue){

case 1:

mysqlconnect.Mysql_ConnectExecute_Select(Usename,KeyID,UrlStrin g);

break;

case 2:

mysqlinsert.Mysql_ConnectExecute_Insert(Usename,KeyID,UrlString );

break;

case 3:

mysqlupdate.Mysql_ConnextExecute_Update(Usename,KeyID,UrlString );

break;

case 4:

mysqldelete.Mysql_ConnectExecute_Delete(Usename,KeyID,UrlString );

break;

default:

}

conn.close();

//Statement statement=conn.createStatement();

}

}catch (ClassNotFoundException e) {

// TODO 自动生成 catch 块

//e.printStackTrace();

System.out.println("找不到JDBC驱动模块！");

}catch (InputMismatchException e){

System.out.println("输入非法的字符！");

}

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("----------------------------------------