java连接MySql数据库

1.下载MySql数据库：

       网址：http://dev.mysql.com/downloads/mysql/

    选择 Windows (x86, 32-bit), MSI Installer下载

2.安装MySql数据库

3.下载Connector/J(MySql驱动)：

     网址：http://dev.mysql.com/downloads/connector/j/

     选择tar或zip都可以

4.将MySql驱动加到java程序的外部包中：   

     project -> properties ->java build path -> libraries -> add external jars -> 加入tar或zip解压后得到的其中的jar包

5.将这个jar包放到java项目的包中

6. 编写代码连接数据库：

   可以使用以下代码测试数据库是否连接正确：如果连接正确，在点击“检查”按钮时，会弹出“成功”标题框

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;


public class TestMysql extends JFrame implements ActionListener {
private Connection conn;
private Statement stmt;
private ResultSet rs;


// 创建操作按钮
private JButton jb = new JButton("查找");


public TestMysql() {
this.setBounds(50, 50, 200, 200);
jb.setBounds(40, 230, 100, 30);
this.add(jb);
this.addListener();
this.setVisible(true);
}


public void addListener() {
jb.addActionListener(this);
}


@Override
public void actionPerformed(ActionEvent e) {


if (e.getSource() == jb) { // 单击”查找“按钮
try {
// 得到数据库连接
this.initialConnection();
// SQL语句
String sql = "select tea_name from user_teacher where pwd='123'";
// 执行
boolean i = stmt.execute(sql);
stmt.getResultSet();
// 如果更新失败，弹出错误消息
if (i == false) {
JOptionPane.showMessageDialog(this, "查询失败", "错误",
JOptionPane.ERROR_MESSAGE);
} else if (i == true) {
JOptionPane.showMessageDialog(this, "查询成功", "提示",
JOptionPane.INFORMATION_MESSAGE);
}
this.closeConn();
} catch (Exception ea) {
ea.printStackTrace();
}
}
}


public void initialConnection() {
try {
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/smsdb",
"root", "123");
stmt = conn.createStatement();
System.out.println("成功！");
} catch (SQLException ea) {
ea.printStackTrace();
} catch (ClassNotFoundException ea) {
ea.printStackTrace();
}
}

public void closeConn() {
try {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException ea) {
ea.printStackTrace();
}
}

public static void main(String[] args) {
TestMysql cpt = new TestMysql();
}
}