admindao.java

图书商城系统

package com.tang.admin.foruse;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class AdminDAO {
	Connection conn = null;

	PreparedStatement pstm = null;

	ResultSet rs = null;

	public void open() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager
					.getConnection("jdbc:mysql://localhost/mydata?user=root&password=124853047");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public ArrayList select(String sqlurl) {
		ArrayList al = new ArrayList();
		try {
			pstm = conn.prepareStatement(sqlurl);
			rs = pstm.executeQuery();
			while (rs.next()) {
				AdminBean userbean = new AdminBean();
				userbean.setId(rs.getInt(1));
				userbean.setUsername(rs.getString(2));
				userbean.setPassword(rs.getString(3));
				al.add(userbean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			this.close();
		}
		return al;
	}

	public boolean delete(String sqlurl) {
		boolean b = false;
		try {
			pstm = conn.prepareStatement(sqlurl);
			int i = pstm.executeUpdate();
			if (i != 0) {
				b = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			this.close();
		}
		return b;
	}

	public boolean insert(String sqlurl) {
		boolean b = false;
		try {
			pstm = conn.prepareStatement(sqlurl);
			int i = pstm.executeUpdate();
			if (i != 0) {
				b = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			this.close();
		}
		return b;
	}

	public boolean jdbcUpdate(String sqlurl) {
		boolean b = false;
		try {
			pstm = conn.prepareStatement(sqlurl);
			int i = pstm.executeUpdate();
			if (i != 0) {
				b = true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			this.close();
		}
		return b;
	}

	public void close() {
		try {
			if (rs != null) {
				rs.close();
			}
			if (pstm != null) {
				pstm.close();
			}
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}