userinfo.java

网上购物源代码

package com.chinaaccpDao;

 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.chinaaccpbean.UserInfobeen;
 
public class UserInfo {
	public ArrayList<UserInfobeen> getAllUserInfo(){
		ArrayList<UserInfobeen> list=new ArrayList<UserInfobeen>();
	 try {
		 String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
			Class.forName(sDBDriver);
			String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
			String name = "sa";
			Connection connshop=DriverManager.getConnection(sConnStr,name,"");
			Statement stmt=connshop.createStatement();
			String sql="select ID,Logname,Password,Name,IDNum,Postcode,Address,Email,Tel from UserInfo";
			ResultSet rs=stmt.executeQuery(sql);
			while(rs.next()){
				UserInfobeen user = new UserInfobeen();
				user.setID(rs.getString(1));
				user.setLogname(rs.getString(2));
				user.setPassword(rs.getString(3));
				user.setName(rs.getString(4));
				user.setIDNum(rs.getString(5));
				user.setPostcode(rs.getString(6));
				user.setAddress(rs.getString(7));
				user.setEmail(rs.getString(8));
				user.setTel(rs.getString(9));
				list.add(user);
				
			}
			rs.close();
			stmt.close();
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
		
	}
	
public boolean setDelete(int ID){
		
		try {
			String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
			Class.forName(sDBDriver);
			String sConnStr="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=shopping";
			String name = "sa";
			Connection connshop=DriverManager.getConnection(sConnStr,name,"");
			Statement stmt=connshop.createStatement();
			String sql1="delete from OrderList where UserInfoId='"+ID+"'";
			String sql2="delete from UserInfo where ID ='"+ID+"'";
	
			int rs1=stmt.executeUpdate(sql1);
			int rs2=stmt.executeUpdate(sql2);
			
		
			stmt.close();
			if(rs1==1&&rs2==1)
				return true;
			else
				return false;
			
			
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}

}