JDBC连接数据库的基本格式

package sc.itcsat.demo;

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

import javax.naming.spi.DirStateFactory.Result;

import com.mysql.jdbc.Driver;
import com.mysql.jdbc.Statement;

public class JDBCDemo {

	/**
	 * @param args 
	 * @throws SQLException 
	 * @throws ClassNotFoundException 
	 */
	public static void main(String[] args) throws SQLException, ClassNotFoundException {
		//DriverManager.registerDriver(new Driver()); //注册驱动
		Class.forName("com.mysql.jdbc.Driver");       //
		String url = "jdbc:mysql://localhost:3306/firstmysql";//
		String username = "root";//
		String password = "root";//
		Connection con = DriverManager.getConnection(url, username, password);//
		/*Statement stat = (Statement) con.createStatement();
		int rows = stat.executeUpdate("INSERT INTO sort(sname,sprice,sdesc) VALUES('汽车',342000,'疯狂涨价')");
	    //System.out.println(rows);
	    */
		Statement stat =  (Statement) con.createStatement();//
		String sql =  "SELECT * FROM sort";
		ResultSet rs = stat.executeQuery(sql);
		
		while(rs.next()) {
			System.out.println(rs.getInt("sid") + "  " + rs.getString("sname") + "  " 
		                       + rs.getDouble("sprice") + "  " + rs.getString("sdesc"));
		 
		}
		rs.close();
        stat.close();
	    con.close();
	}

}