DatabaseManager.java

package com.cn.dao;

import java.sql.Connection;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DatabaseManager {
private Connection conn = null;
private Statement st = null;
private ResultSet rs = null;
public ResultSet getRs() {
return rs;
}

public void setRs(ResultSet rs) {
this.rs = rs;
}

public DatabaseManager() {
final String driverName = "com.mysql.jdbc.Driver";
final String dbURL = "jdbc:mysql://localhost:3306/news121?characterEncoding=gb2312";
final String userName = "root";
final String userPassWord = "124911";
try {
Class.forName(driverName);
conn = DriverManager.getConnection(dbURL, userName, "124911");
st = conn.createStatement();
} catch (Exception e) {
System.out.println("");
e.printStackTrace();
}
}

public ResultSet executeQuery(String sql) {
try {
rs = st.executeQuery(sql);
} catch (Exception e) {
System.out.println("");
e.printStackTrace();
}
return rs;
}

public int executeUpdate(String sql) {
int ret = 0;
try {
ret = st.executeUpdate(sql);
} catch (SQLException e) {
System.out.println("");
e.printStackTrace();
}
return ret;
}

public void close() {
try {
if (rs != null) {
rs.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
System.out.println("");
e.printStackTrace();
}
}
}