Question

JAVA增删改查的接口怎么写

编写一个jsp+javabean的小程序
怎么写增删改查的接口

Answer 1

public void insert(Object obj);
public void delete(Object obj);
public void update(Object obj);
public List select(Object obj);
你问的太粗了。。也只能回答得这么粗了。。。

Answer 2

一个完整的数据库2000的连接，加增删改查的方法实现，
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import Bean.Bean;

public class shixian implements DAO {

public void delete(Bean bean) throws Exception {
// 删除数据
String sql = "delete from person where name=?";
Conn conn = new Conn();
PreparedStatement pre;
try {
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, bean.getName());
pre.executeUpdate();
pre.close();

} catch (Exception e) {
e.printStackTrace();
}

}

public void insert(Bean bean) throws Exception {
// 增加数据
String sql = "insert into person values(?,?)";
Conn conn = new Conn();
PreparedStatement pre = null;
try {
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, bean.getName());
pre.setString(2, bean.getPassword());
pre.executeUpdate();
pre.close();
}

catch (Exception e) {
e.printStackTrace();
}

}

public Bean select(String name) throws Exception {
// 查询数据

String sql = "select name,password from person where name=?";
Conn conn=new Conn();
Bean bean = new Bean();
PreparedStatement pre = null;
try{
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, name);
ResultSet rs = pre.executeQuery();
if (rs.next()) {
bean.setName(rs.getString(1));
bean.setPassword(rs.getString(2));

}
rs.close();
pre.close();

} catch (Exception e) {
e.printStackTrace();
}

return bean;
}

public void update(Bean bean) throws Exception {
// 修改数据
String sql = "insert into person values(?,?)";
Conn conn = new Conn();
PreparedStatement pre = null;
try {
pre = conn.getConn().prepareStatement(sql);
pre.setString(1, bean.getName());
pre.setString(1, bean.getPassword());
pre.executeUpdate();
pre.close();
}

catch (Exception e) {
e.printStackTrace();
}

}

}

Answer 3

你看看jdbc