dbconnect.java

success 突发奇想随便写的一个。。。。。。为了能下载东西

package bookDB;

import java.sql.*;
public class DBConnect {
	private PreparedStatement ps = null;

	private ResultSet rs = null;

	private Connection conn = null;

	public DBConnect() throws Exception {
		
		Class.forName("com.mysql.jdbc.Driver");
		conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bookshopping", "root", "123456");
		//conn = DriverManager.getConnection("jdbc:mysql://192.168.26.61:3306/bookshopping", "root", "123456");
	
	}

	public ResultSet executeQuery(String sql, String[] values) throws Exception {
		ps = conn.prepareStatement(sql);
		if (values != null) {
			for (int i = 0; i < values.length; i++) {
				ps.setString(i + 1, values[i]);
			}
		}
		rs = ps.executeQuery();
		return rs;
	}

	public int executeUpdate(String sql, String[] values) throws Exception {
		ps = conn.prepareStatement(sql);
		if (values != null) {
			for (int i = 0; i < values.length; i++) {
				ps.setString(i + 1, values[i]);
			}
		}
		return ps.executeUpdate();
	}

	public void close() throws SQLException {
		if (rs != null)
			rs.close();
		if (ps != null)
			ps.close();
	}
}