Connection steps for Java connection MySQL database

This article mainly takes MySQL as an example of how Java connects to a database.

Of course, the first thing to install is the JDK (typically jdk1.5.x). Then install MySQL, these are relatively simple, the specific process will not say. After configuring these two environments, download the JDBC driver Mysql-connector-java-5.0.5.zip (This is the latest version). Then unzip it to either directory.           I extracted to the D drive, and then added the Mysql-connector-java-5.0.5-bin.jar in its directory to Classpath, as follows: "My Computer", "Properties", "Advanced" "Environment variable", edit classpath in the system variable, add D:\mysql-connector-java-5.0.5\mysql-connector-java-5.0.5-bin.jar to the last, add ";" before adding the string. To separate from the previous Classpath area. And then determine.

The environment is well configured, very simple. Now, configure MySQL with the username "root" and the password "root". Create database on the command line or with a SQL front-end software.

I use SQLyog's front-end software to create database.

Create the database First:

CREATE DATABASE Scutcs;

Next, create the table:

CREATE TABLE STUDENT

(

SNO CHAR (7) Not NULL,

SNAME VARCHAR (8) Not NULL,

SEX CHAR (2) Not NULL,

Bdate DATE not NULL,

HEIGHT DEC (5,2) DEFAULT 000.00,

PRIMARY KEY (SNO)

);

Then insert the data with the SQL statement insert into < table name > values (value1, value2, ...);

You can also use SQLyog to manipulate

All right, I've created it.

Next, let's write a. java file to demonstrate how to access the MySQL database.

Import java.sql.*;

public class Jdbctest {

public static void Main (string[] args) {

Driver name
String Driver = "Com.mysql.jdbc.Driver";

The URL points to the database name you want to access Scutcs
String url = "Jdbc:mysql://127.0.0.1:3306/scutcs";

User name when MySQL is configured
String user = "root";

Password for MySQL configuration
String password = "root";

try {
Load Driver
Class.forName (driver);

Continuous database
Connection conn = drivermanager.getconnection (URL, user, password);

if (!conn.isclosed ())
SYSTEM.OUT.PRINTLN ("Succeeded connecting to the database!");

statement used to execute SQL statements
Statement Statement = Conn.createstatement ();

The SQL statement to execute
String sql = "SELECT * from student";

Result set
ResultSet rs = statement.executequery (SQL);

System.out.println ("-----------------");
System.out.println ("Execution results 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 data
              name = rs.getstring ("sname");
    /* asked hovertree.com */
             //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.
            //Then decodes the specified byte array using the GB2312 character set
              name = new String (name.getbytes ("iso-8859-1"), " GB2312 ");

Output results
System.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 ();

}
}
}

Now let's run a look at the effect:

D:\testjdbc>javac Jdbctest.java

D:\testjdbc>java Jdbctest
Succeeded connecting to the database!
-----------------------
The execution results are as follows:
-----------------------
Name of the study number
-----------------------
0104421 weeks Excursion
0208123 Wang Yiping
0209120 How to ask
0309119 Levi
0309203 Ouyang Merrill
0309226 Collayi

Haha, success.

Recommendation: http://www.cnblogs.com/roucheng/p/javatimu.html

Connection steps for Java connection MySQL database