【文件属性】：
文件名称：MVC模式的实现的增删改查
文件大小：376KB
文件格式：RAR
更新时间：2014-08-18 03:44:00
MVC 增删改查
用MVC模式的实现对数据库的增删改查
部分代码：
package dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import common.DBConnection;
import bean.Contact;
public class ContactDAO {
public List getAllContact() throws Exception{
Connection conn=DBConnection.getConntion();
PreparedStatement ps=conn.prepareStatement("select * from Contact");
ResultSet rs=ps.executeQuery();
List list = new ArrayList();
while(rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
String phone = rs.getString("phone");
String address = rs.getString("address");
Contact c = new Contact();
c.setId(id);
c.setName(name);
c.setPhone(phone);
c.setAddress(address);
list.add(c);
}
rs.close();
ps.close();
conn.close();
return list;
}
public void addContact(String name,String phone,String address) throws Exception{
String sql = "insert into contact(id,name,phone,address) values(seq_contact.nextval,?,?,?)";
Connection con = DBConnection.getConntion();
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, phone);
pstmt.setString(3, address);
pstmt.executeUpdate();
}
public void delContact(int id) throws Exception{
String sql = "delete from contact where id=?";
Connection con = DBConnection.getConntion();
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setInt(1, id);
pstmt.executeUpdate();
}
public Contact getContactById(int id) throws Exception{
String sql = "select * from Contact where id=?";
Connection con = DBConnection.getConntion();
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setInt(1, id);
ResultSet rs = pstmt.executeQuery();
Contact c = null;
while(rs.next()){
// int id = rs.getInt("id");
String name=rs.getString("name");
String phone=rs.getString("phone");
String address = rs.getString("address");
c = new Contact();
c.setId(id);
c.setName(name);
c.setPhone(phone);
c.setAddress(address);
}
return c;
}
public void updateContact(int id,String name,String phone,String address) throws Exception{
String sql = "update contact set name=?,phone=?,address=? where id=?";
Connection con = DBConnection.getConntion();
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, phone);
pstmt.setString(3,address);
pstmt.setInt(4, id);
pstmt.executeUpdate();
}
}
【文件预览】：
MyWebProject
----.project(1KB)
----.settings()
--------.jsdtscope(500B)
--------org.eclipse.wst.jsdt.ui.superType.container(49B)
--------org.hibernate.eclipse.console.prefs(112B)
--------org.eclipse.wst.jsdt.ui.superType.name(6B)
----.mymetadata(309B)
----WebRoot()
--------css()
--------WEB-INF()
--------index.jsp(834B)
--------META-INF()
--------html()
--------js()
--------jsp()
----.myeclipse()
----src()
--------bean()
--------dao()
--------action()
--------controller()
--------common()
----.classpath(583B)
