Java连接Mysql数据库

1. 下载mysql-connector-java，将mysql-connector-java-5.1.24-bin.jar导入Eclipse。

 

2.  在Eclipse中编程如下：

public class JDBCTest {

	public static void main(String[] args) {
		// TODO 自动生成的方法存根
		String driver = "com.mysql.jdbc.Driver";
		//1.连接字符串
		//String url = "jdbc:mysql://:3306/cookbook?useUnicode=true&characterEncoding=UTF-8"; (可行)
		//String url = "jdbc:mysql://localhost:3306/cookbook?useUnicode=true&characterEncoding=UTF-8"; (可行)
		String url = "jdbc:mysql://127.0.0.1:3306/cookbook?useUnicode=true&characterEncoding=UTF-8";
		String user = "root";
		String pass = "123";
		try {
			Class.forName(driver);
			Connection conn = DriverManager.getConnection(url, user, pass);
			if(!conn.isClosed()){
				System.out.println("Connected");
				//2.创建声明
				java.sql.Statement statement = conn.createStatement();
				String sql = "select * from dish";
				//3.定义结果集并执行SQL语句
				ResultSet rs = statement.executeQuery(sql);
				System.out.println("-----------执行结果：-----------");
				System.out.println("\t\tname\t\tpass\t\tfood\t\t");				
				while(rs.next()){
					name = rs.getString("uname");
					pwd = rs.getString("upass");
					food = rs.getString("food");
					System.out.println("\t\t"+name+"\t\t"+pwd+"\t\t");					
				}
				//4.先关结果集，再关连接
				rs.close();
				conn.close();
			}
		} catch (Exception e) {
			// TODO 自动生成的 catch 块
			e.printStackTrace();
		}

		
	}

}