java 链接 数据库

Mysql:

先获得jar包。 点击下载http://download.csdn.net/detail/qbz2004/4153895

jar放倒 D:\Java\jre6\lib\ext 中

package com.cho;

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

public class Mysqlcon {

	public static void main(String[] args) {
		
		try {
			Class.forName("com.mysql.jdbc.Driver");
			
			//jdbc:mysql://数据库地址/数据库名?user=用户名&password=密码
			Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123456");
			Statement stmt = conn.createStatement();
			
			//插入数据
			//stmt.execute("INSERT INTO XXX VALUES()");
			
			//获得结果集
			ResultSet rs = stmt.executeQuery("select * from ttt");
			
			//循环打印
			while(rs.next()) {
				System.out.print("ID:"+rs.getInt("id"));
				System.out.println("Mobile:"+rs.getString("mobile"));
			}
			
			//关闭
			rs.close();
			conn.close();
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}