Connection steps for Java connection MySQL database

Http://www.cnblogs.com/soplayer/archive/2007/06/26/796565.html

This article mainly describes the Java connection MySQL database (take MySQL as an example) of the actual operation steps, we are related to the case of the Java connection to the MySQL database of the actual operation process, the following is the main content of the article description.

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 it to D and then added the Mysql-connector-java-5.0.5-bin.jar in its catalogue to Classpath,

as follows: "My Computer", "Properties", "Advanced", "Environment variables", in the system variables to edit classpath, will D:\mysql-connector-java-5.0.5\ Mysql-connector-java-5.0.5-bin.jar to the end, add ";" before adding the string to separate from the previous Classpath area. And then determine.

The environment is well configured, very simple. Now, configure Java to connect to MySQL, set its user name "root", the password is "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:

1. CREATE DATABASE Scutcs;

Next, create the table:

2. CREATE TABLE STUDENT
4. (
6. SNO CHAR (7) Not NULL,
8. SNAME VARCHAR (8) Not NULL,
10. SEX CHAR (2) Not NULL,
12. Bdate DATE not NULL,
14. HEIGHT DEC (5,2) DEFAULT 000.00,
16. PRIMARY KEY (SNO)
18. );

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 Java connection MySQL database.

2. Import java.sql.*;
4. public class Jdbctest {
6. 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";

Java password when connecting to 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

2. ResultSet rs = statement.executequery (SQL);
4. System.out.println ("-----------------");
6. System.out.println ("Execution results are as follows:");
8. System.out.println ("-----------------");
10. System.out.println ("School number" + "\ T" + "name");
12. System.out.println ("-----------------");
14. String name = null;
16. while (Rs.next ()) {

Select sname This column of data

Name = 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 set

name = new String (name.getbytes ("iso-8859-1"), "GB2312");

Output results

2. System.out.println (rs.getstring ("sno") + "\ T" + name);
4. }
6. Rs.close ();
8. Conn.close ();
10. } catch (ClassNotFoundException e) {
12. System.out.println ("Sorry,can ' t find the driver!");
14. E.printstacktrace ();
16. } catch (SQLException e) {
18. E.printstacktrace ();
20. } catch (Exception e) {
22. E.printstacktrace ();
24. }
26. }
28. }

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 Wang vigorously

0309119 Levi

0309203 Ouyang Merrill

Connection steps for Java connection MySQL database