Java MySQL Database Data Retrieval

Class. forname ("com. MySQL. JDBC. Driver"); // load the driver string url = "JDBC: mysql: // localhost/BBS? User = root & Password = root "; connection conn = drivermanager. getconnection (URL); // establish the connection statement stmt = Conn. createstatement (); // create an SQL speech resultset rs = stmt.exe cutequery ("select * from article"); // run the SQL statement to obtain the result set.

Extract data from the result user for various presentations. This is basically the standard step for connecting to the database, but there is a little difference between different database data types and SQL statements.