import java.sql.*;
public class DB {
public static Connection getConn() {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/drpuser=root&password=root&useUnicode=true&characterEncoding=GB2312");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeConn(Connection conn) {
try {
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closeStmt(Statement stmt) {
try {
if(stmt != null) {
stmt.close();
stmt = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closeRs(ResultSet rs) {
try {
if(rs != null) {
rs.close();
rs = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
-------------------------------------------------------
import java.sql.*;
public class TestMysqlConnection {
/**
* @param args
*/
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?"
+ "user=root&password=root");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from dept");
//
while (rs.next()) {
System.out.println(rs.getString("deptno"));
}
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch (SQLException sex) {
// handle any errors
System.out.println("SQLException: " + sex.getMessage());
System.out.println("SQLState: " + sex.getSQLState());
System.out.println("VendorError: " + sex.getErrorCode());
} finally {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt= null;
}
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException sex) {
sex.printStackTrace();
}
}
}
}
--------------------------------------------------------------------------------
在工作台中查看数据库中的数据(建立连接)
在Database Explorer
点击Connections-->New Connections-->会弹出一个对话框
Database:bbs(数据库名)
JDBC driver class:com.mysql.jdbc.Driver//这是驱动的类包
Class location:jdbc:mysql://localhost/bbs?user=root&password=root
User ID:root
password:root