dao.java

该系统采用B/S架构设计的一个小型的通讯录系统

package DAO;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import Bean.linkMan;
import Bean.users;

public class dao {
	Connection con ;
	PreparedStatement ps;
	Statement st;
	ResultSet rs;
	
	public int check(String userid ,String password){
		int n =0;
		String sql ="select count(*) from users where userid=? and password=?";
		DBConnection dbc = new DBConnection();
		con = dbc.getConnection();
		try {
			ps = con.prepareStatement(sql);
			ps.setString(1, userid);
			ps.setString(2, password);
			rs = ps.executeQuery();
			if(rs.next()){
				n = rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	}
	public int del(int id){
		int n =0;
		String sql="del users where id=?";
		try {
			DBConnection dbc = new DBConnection();
			con = dbc.getConnection();
			ps = con.prepareStatement(sql);
			ps.setInt(1, id);
			n = ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	}
	public int delconn(int id){
		int n=0;
		String sql="del conn where id=?";
		DBConnection dbc = new DBConnection();
		con = dbc.getConnection();
		try {
			ps = con.prepareStatement(sql);
			ps.setInt(1, id);
			n=ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	}
	public int register(users users){
		int n =0;
		String sql="insert into users values(?,?,?,?)";
		
		try {
			DBConnection dbc = new DBConnection();
			con = dbc.getConnection();
			ps = con.prepareStatement(sql);
			ps.setString(1, users.getUserid());
			ps.setString(2, users.getPassword());
			ps.setString(3, users.getSex());
			ps.setString(4, users.getJiaose());
			n = ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	}
	public int  update(users users){
		int n=0;
		String sql="update users set userid=?,password=?,sex=?,jiaose=?";
		try {
			DBConnection dbc = new DBConnection();
			con = dbc.getConnection();
			ps = con.prepareStatement(sql);
			ps.setString(1, users.getUserid());
			ps.setString(2, users.getPassword());
			ps.setString(3, users.getSex());
			ps.setString(4, users.getJiaose());
			n = ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	}
	public ArrayList card_list(){
		ArrayList arrayList = new ArrayList();
		String sql="select * from conn";
		DBConnection dbc = new DBConnection();
		con = dbc.getConnection();
		try {
			st=con.createStatement();
			rs = st.executeQuery(sql);
			while(rs.next()){
				linkMan link= new linkMan();
				link.setId(rs.getInt("id"));
				link.setName(rs.getString("name"));
				link.setSex(rs.getString("sex"));
				link.setAddress(rs.getString("address"));
				link.setAddressID(rs.getString("addressID"));
				link.setDWaddress(rs.getString("DWaddress"));
				link.setDWid(rs.getString("DWid"));
				link.setHomeTel(rs.getString("homeTel"));
				link.setMoveTel(rs.getString("moveTel"));
				link.setOffTel(rs.getString("offTel"));
				link.setEmail(rs.getString("email"));
				link.setImage(rs.getString("image"));
				link.setTeamid(rs.getInt("teamid"));
				link.setUserid(rs.getInt("userid"));
				arrayList.add(link);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return arrayList;
	}
	public  int  addlinkman(linkMan linkman){
		int n=0;
		String sql="insert into conn values(?,?,?,?,?,?,?,?,?,?,?,?,?)";
		DBConnection dbc = new DBConnection();
		con = dbc.getConnection();
		try {
			ps=con.prepareStatement(sql);
			ps.setString(1, linkman.getName());
			ps.setString(2, linkman.getSex());
			ps.setString(3, linkman.getAddress());
			ps.setString(4, linkman.getAddressID());
			ps.setString(5, linkman.getDWaddress());
			ps.setString(6, linkman.getDWid());
			ps.setString(7, linkman.getHomeTel());
			ps.setString(8, linkman.getMoveTel());
			ps.setString(9, linkman.getOffTel());
			ps.setString(10, linkman.getEmail());
			ps.setString(11, linkman.getImage());
			ps.setInt(12, linkman.getTeamid());
			ps.setInt(13, linkman.getUserid());
			 n =ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return n;
	}
	public ArrayList eidt(int id){
		ArrayList arrayList = new ArrayList();
		String sql="select * from conn where id=?";
		DBConnection dbc = new DBConnection();
		con = dbc.getConnection();
		try {
			ps = con.prepareStatement(sql);
			 ps.setInt(1, id);
			rs =  ps.executeQuery();
			while(rs.next()){
				linkMan link= new linkMan();
				link.setName(rs.getString("name"));
				link.setSex(rs.getString("sex"));
				link.setAddress(rs.getString("address"));
				link.setAddressID(rs.getString("addressID"));
				link.setDWaddress(rs.getString("DWaddress"));
				link.setDWid(rs.getString("DWid"));
				link.setHomeTel(rs.getString("homeTel"));
				link.setMoveTel(rs.getString("moveTel"));
				link.setOffTel(rs.getString("offTel"));
				link.setEmail(rs.getString("email"));
				link.setImage(rs.getString("image"));
				link.setTeamid(rs.getInt("teamid"));
				link.setUserid(rs.getInt("userid"));
				arrayList.add(link);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return arrayList;
		
	}
}