java学习笔记1-Eclipse和Mysql连接,中文不显示问题 (二)

2014-11-24 10:53:14 · 作者: · 浏览: 1
ace();
}
}
//增删改
public boolean update(String sql){
Statement st;
try {
st = conn.createStatement();
int n=0;
n=st.executeUpdate(sql);
if(n>0)
return true;
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
//查询
public ResultSet query(String sql){
Statement st=null;
ResultSet rs=null;
try {
st = conn.createStatement();
rs=st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
//关闭数据库
public void close(){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

//负责完成数据库的连接及操作
public class Database {
//建立连接
private final String DRIVER_STR="com.mysql.jdbc.Driver";
//加载驱动
private final String CONN_STR="jdbc:mysql://127.0.0.1:3306/zjw useUnicode=true&characterEncoding=utf-8";
private final String USER="root";
private final String PASSWORD="123456";
private Connection conn=null;

public Database(){
try {
Class.forName(DRIVER_STR);
conn=DriverManager.getConnection(CONN_STR, USER, PASSWORD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
//增删改
public boolean update(String sql){
Statement st;
try {
st = conn.createStatement();
int n=0;
n=st.executeUpdate(sql);
if(n>0)
return true;
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
//查询
public ResultSet query(String sql){
Statement st=null;
ResultSet rs=null;
try {
st = conn.createStatement();
rs=st.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
//关闭数据库
public void close(){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}