src/com/accp/myShopping/util/DataBaseUtil.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.accp.myShopping.util;
import java.sql.*;
import java.util.*;
public class DataBaseUtil {

	 private Connection conn;
	 private PreparedStatement ps;
	 static{
		 try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			 System.out.println("������");
		} catch (ClassNotFoundException e) {
			 System.out.println("��������ʧ��");
			 
		}
	 }
	
	 /**
	  * ��ɾ��
	  * 
	  * */
	 public int update(String sql,Object...objects)
	 {   
		
		 int result =-1;
		 try
		 {
			 this.getConnection();
			 ps=conn.prepareStatement(sql);
			 this.setParams(ps, objects);
			 result=ps.executeUpdate();
		 }
		 catch(SQLException e)
		 {
			 System.out.println("update����������");
			  e.printStackTrace();
		 }
		 finally
		 {
			 this.release(null);
		 }
		 return result;
	 }
	 
	 /**
	  * ִ�в�ѯ
	  * */
	 public ResultSet getResultSet(String sql,Object...objects)throws SQLException 
	 {
		 
		 this.getConnection();
		 ps=conn.prepareStatement(sql);
		 this.setParams(ps, objects);
		 return ps.executeQuery();
		 
	 }
	 
	 //��ѯCOUNT(*)
	 public int rowcount(String sql,Object...objects)
	 {   ResultSet set=null;