ImportJava.sql.*; Public classJdbctest { Public Static voidMain (string[] args) {//driver nameString Driver = "Com.mysql.jdbc.Driver"; //the URL points to the database name you want to access ScutcsString url = "Jdbc:mysql://127.0.0.1:3306/scutcs"; //user name when MySQL is configuredString user = "root"; //password for MySQL configurationString password = "root"; Try { //Load DriverClass.forName (driver); //Continuous DatabaseConnection conn =drivermanager.getconnection (URL, user, password); if(!conn.isclosed ()) System.out.println ("Succeeded connecting to the database!"); //statement used to execute SQL statementsStatement Statement =conn.createstatement (); //the SQL statement to executeString sql = "SELECT * FROM Student"; //result setResultSet rs =statement.executequery (SQL); System.out.println ("-----------------"); System.out.println (The results of the execution are as follows:); System.out.println ("-----------------"); System.out.println ("School Number" + "\ T" + "name"); System.out.println ("-----------------"); String name=NULL; while(Rs.next ()) {//Select sname This column of dataName = Rs.getstring ("sname"); //first, use the iso-8859-1 character set to decode name into a sequence of bytes and store the result in a new byte array. //the specified byte array is then decoded using the GB2312 character setName =NewString (Name.getbytes ("iso-8859-1"), "GB2312"); //Output ResultsSystem.out.println (rs.getstring ("sno") + "\ T" +name); } rs.close (); Conn.close (); } Catch(ClassNotFoundException e) {System.out.println ("Sorry,can ' t find the driver!"); E.printstacktrace (); } Catch(SQLException e) {e.printstacktrace (); } Catch(Exception e) {e.printstacktrace (); } } }
Java link MySQL database (go)