1.下载mysql包
2.项目中引入mysql包
3.连接数据库，查询结果
看jdbc数据库连接类
package Facade;
import java.sql.*;
/**
* Created by Jiqing on 2016/10/18.
*/
public class JDBCFacade {
private Connection conn=null;
private Statement statement=null;
public void open(String driver,String jdbcUrl,String userName,String userPwd) {
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(jdbcUrl,userName,userPwd);
statement = conn.createStatement();
}
catch (Exception e) {
e.printStackTrace();
}
}
public int executeUpdate(String sql) {
try {
return statement.executeUpdate(sql);
}
catch (SQLException e) {
e.printStackTrace();
return -1;
}
}
public ResultSet executeQuery(String sql) {
try {
return statement.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
public void close() {
try {
conn.close();
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
客户端执行
package Facade;
import java.sql.ResultSet;
/**
* Created by Jiqing on 2016/10/18.
*/
public class Client {
public static void main(String args[])
{
try {
JDBCFacade jdbc= new JDBCFacade();
jdbc.open("com.mysql.jdbc.Driver","jdbc:mysql://localhost:3306/tpshop","root","123456");
ResultSet rs = jdbc.executeQuery("select * from tp_admin");
while(rs.next()){
String email = rs.getString("email") ;
System.out.println(email);
}
}
catch (Exception e)
{
e.printStackTrace();
}
}
}