dao.java

来自「java做的个人通讯录 仅供初学者参考！」· Java 代码 · 共 76 行

package Exam;

import java.util.ArrayList;
import Exam.Bean;
import Exam.DBUtil;
public class DAO {
	/**
	 * 插入数据的方法
	 * @return
	 */
	public boolean addBalance(String name,String mobile,String phone,String email) {
		
		DBUtil db=new DBUtil();
		try {
			java.sql.Connection con=db.getConnection();
		    String sql="insert into Linkman values(?,?,?,?)";
		    java.sql.PreparedStatement ps=con.prepareStatement(sql);
		   
		    ps.setString(1, name);
		    ps.setString(2, mobile);
		    ps.setString(3, phone);
		    ps.setString(4, email);
		    
		   
		    int sult=ps.executeUpdate();
		    if(sult>0) {
		    	return true;
		    }
		    db.close(ps, con);
		}
		catch(java.sql.SQLException sqle) {
			 sqle.printStackTrace();
		}
		return false;
		
	}
	/**
	 * 查询数据的方法
	 * @param name
	 * @return
	 */
	public Exam.Bean queryBalance(String name) {
		
		DBUtil db=new DBUtil();
		 Bean gb=null;
		 
		try {
			java.sql.Connection con=db.getConnection();
		    String sql="select * from Linkman where name=?";
		    java.sql.PreparedStatement ps=con.prepareStatement(sql);
		    ps.setString(1, name);
		    
		    java.sql.ResultSet rs=ps.executeQuery();
		   
		   
		    while(rs.next()) {
		    	gb=new Bean();
		    	gb.setMName(rs.getString("name"));
		    	gb.setMMobile(rs.getString(2));
		    	gb.setMPhone(rs.getString(3));
		    	gb.setMEmail(rs.getString(4));
		    	
		    }
		    db.close(ps, rs, con);
		   
		}
		
		catch(java.sql.SQLException sqle) {
			 sqle.printStackTrace();
		}
		
		return gb;
	}

}