java语言连接Mysql数据库

import java.sql.*;
public class ConnectDb {
	
	Connection con;
	public Connection getConnection()
	{
		String driver = "com.mysql.jdbc.Driver";
		String url="jdbc:mysql://127.0.0.1:3306/csm";
		try {
			Class.forName(driver);
			System.out.println("数据库驱动加载成功");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			con=DriverManager.getConnection(url,"root","root");
			System.out.println("数据库连接成功");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		/*
		try {
			Statement statement = con.createStatement();
			String sql = "select * from contacts";
			ResultSet rs = statement.executeQuery(sql); 
			String name = null;  
			while(rs.next()) {  
				name = rs.getString("sname");
				name = new String(name.getBytes("ISO-8859-1"),"GB2312");
				System.out.println(rs.getString("sno") + "\t" + name);  
			rs.close();  con.close();    

			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		*/
		return con;
		
		
	}
	
	public static void main(String[] args)
	{
		ConnectDb c = new ConnectDb();
		c.getConnection();
	}

}