java mysql 实例_java连接mysql实例

java连接mysql实例

1.转的：

import java.sql.*;

public class JDBCTest {

public static void main(String[] args) {

// 1. 注册驱动

try {

Class.forName(“com.mysql.jdbc.Driver”);

} catch(ClassNotFoundException ex) {

ex.printStackTrace();

}

// 声明变量，使用，而后关闭

Connection conn = null;        //数据库连接

Statement stmt = null;         //数据库表达式

ResultSet rs = null;             //结果集

try {

//2. 获取数据库的连接

conn = DriverManager.getConnection

(“jdbc:mysql://localhost:3306/databasename,”root”,”password”);

//3. 获取表达式

stmt = conn.createStatement();

// 插入数据

stmt.executeUpdate(“insert into Student (username, password, age) values (‘张三’,’1234′,20)”);

//4. 执行SQL

rs = stmt.executeQuery(“select * from Student”);

//5. 现实结果集里面的数据

while(rs.next()) {

System.out.println(“编号=” + rs.getInt(1));

System.out.println(“姓名=” + rs.getString(“username”));

System.out.println(“密码=” + rs.getString(“password”));

System.out.println(“年龄=” + rs.getString(“age”));

System.out.println(“—————”);

}

}

catch (Exception ex) {

ex.printStackTrace();

}

finally {

try {

if(rs != null) {

rs.close();

}

if(sm != null) {

sm.close();

}

if(conn != null) {

conn.close();

}

} catch(Exception ex) {

ex.printStackTrace();

}

}

}

}

2.自己写的

package com.ru.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class MySqlHelper {

public Connection ct = null;

public Statement st = null;

private ResultSet rs = null;

//数据操作返回rs

public  ResultSet executeQuery(String sql) {

// 创建数据库变量

try {

// 加载驱动

Class.forName(“com.mysql.jdbc.Driver”);

// 连接数据库

ct = DriverManager.getConnection(“jdbc:mysql://localhost:3306/ru”,

“root”, “123456″);

// 创建表达式

st = ct.createStatement();

// 执行sql语句

rs = st.executeQuery(sql);

} catch (Exception e) {

e.printStackTrace();

}

return rs;

}

//关闭资源

public void close(ResultSet rs,Statement st,Connection ct){

if (rs != null) {

try {

rs.close();

} catch (Exception e) {

// TODO: handle exception

}

} else if (st != null) {

try {

st.close();

} catch (Exception e) {

// TODO: handle exception

}

} else if (ct != null) {

try {

ct.close();

} catch (Exception e) {

// TODO: handle exception

}

}

}

}