java连接Mysql数据库

 

首先安装好mysql数据库，然后建了个数据库以及相应的表。

创建数据库的sql语句如下：

create database mytest;
create table user_table(
 id varchar(20) primary key,
 password varchar(20),
 other varchar(20)
)
insert into user_table(id, password, other)values('001','123','');
insert into user_table(id, password, other)values('002','123','');
insert into user_table(id, password, other)values('003','123','');
insert into user_table(id, password, other)values('004','123','');
insert into user_table(id, password, other)values('005','123','');

创建好数据库后在eclipse中创建一个java项目，然后加载数据库驱动，我用的是：mysql-connector-java-5.0.4-bin.jar。

然后就开始编写连接数据库代码。具体如下：

package cn.server.database;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;

public class ConnectMysql {

	private String Dr = "com.mysql.jdbc.Driver";
	private String url = "jdbc:mysql://localhost:3306/mytest";
	private String userName = "root";
	private String password = "liuwu";
	private String sql = null;
	
	Connection conn = null;
	Statement sm = null;
	ResultSet rs = null;
	
	public ConnectMysql(String sql)
	{
		this.sql = sql;
		InitDb();
//		ExecuteSql();
	}
	public void InitDb()
	{
		try {
			Class.forName(Dr);
			
		} catch (ClassNotFoundException e) {
			System.out.println("无法加载驱动程序");
		}
		try {
			conn = DriverManager.getConnection(url, userName, password);
			sm = conn.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	public void ExecuteSql()
	{
		String id = null;
		String pwd = null;
		try {
			rs = sm.executeQuery(sql);
			while(rs.next())
			{
				id = rs.getString("id");
				pwd = rs.getString("password");
				System.out.println("id="+id+"  pwd="+pwd);
				
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}
	
	public static void main(String[] agrs)
	{
		String sql = "select id,password from user_table";
		ConnectMysql cm = new ConnectMysql(sql);
		cm.ExecuteSql();
	}
}

运行下连接成功~