Dao包 对数据库的操作
//添加
public static int add(Bean1 bean)
{
String sql = "insert into classtable(classname,teacher,address,time) values('" +bean.getClassname() + "','" + bean.getTeacher() + "','" + bean.getAddress() + "','" +bean.getTime()+"')";
//改表名,表内数据(就是values后面,bean是Bean类的一个对象,有一些属性和方法,bean.getClassname()就是取bean中的classname元素), 表的名称可以从数据库图形化软件中看,(因为有一些表要加类似单引号括起来,不太清除什么时候加和,搁数据库图形化界面看最靠谱,我的表名classtable)
Connection conn = Util1.getConn();
Statement state = null;
int count=0;
try {
state = conn.createStatement();
count = state.executeUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
//关闭连接
Util1.close(state, conn);
}
return count;
}
//修改
public static int update(Bean1 bean)
{
String sql = "update classtable set teacher='" + bean.getTeacher() + "', address='" + bean.getAddress() + "', time='" + bean.getTime()
+ "' where classname='" + bean.getClassname() + "'";
Connection conn = Util1.getConn();
Statement state = null;
int count=0;
try {
state = conn.createStatement();
count = state.executeUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
} finally {
//关闭连接
Util1.close(state, conn);
}
return count;
}//和上述一样
//查找
public static Bean1 Search(String classnamet)
{
String sql = "select * from classtable where classname ='" + classnamet + "'";
Connection conn = Util1.getConn();
Statement state = null;
ResultSet rs = null;
Bean1 tbean=null;
try {
state = conn.createStatement();
rs = state.executeQuery(sql);
while (rs.next()) {
String classname = rs.getString("classname");
String teacher = rs.getString("teacher");
String address = rs.getString("address");
String time = rs.getString("time");
tbean = new Bean1(classname,teacher,address,time);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
Util1.close(rs, state, conn);
}
return tbean;
}
最新文章
- Android 判断一个 View 是否可见 getLocalVisibleRect(rect) 与 getGlobalVisibleRect(rect)
- easyUI和bootstrap的混搭
- Windows平台Tomcat服务搭建
- Javascript下拉导航
- smb:unrecognized service
- -bash: /usr/local/bin/react-native: No such file or directory
- SQL 字段保留下划线后部分
- 两个实用的Python的装饰器
- Docker 1.13 管理命令
- 新版TP-Link无线路由器怎么设置
- Linux显示查看您拥有的仓库
- js备战春招の三
- SDK提交到CocoaPods
- JSP 基本语法
- intent flags标记
- 使用strace命令跟踪系统调用
- Flask、Celery、RabbitMQ学习计划
- 04 存储库之mongodb
- Android实现不同Active页面间的跳转
- maven 编译替换占位符
热门文章
- Ansible执⾏速度优化
- c++小练习——黑白棋
- codeforces补题计划
- Git同步操作
- typora使用CSDN图床
- 关于mysql数据库user表没有password字段
- OpenVINO计算机视觉模型加速
- Relational Learning with Gated and Attentive Neighbor Aggregator for Few-Shot Knowledge Graph Completion 小样本关系学习论文解读
- JavaScript入门⑩-ES6归纳总结
- [常用工具] Python视频解码库DeFFcode使用指北