package com.test.dao.impl;
/**
* ponit 表操作的实现类
*/
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 java.util.List;
import com.test.dao.PointDao;
import com.test.model.Point;
import com.test.model.Point;
import com.test.util.DbConn;
public class PointDaoImpl implements PointDao {
private Connection conn = DbConn.getConn();
/**
* 根据节点id获得节点对象
*/
public Point findPointByid(int id) {
Point p = null;
String sql = "select * from Point where id=?";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setInt(1, id);
ResultSet rs = psmt.executeQuery();
while (rs.next()) {
int id2 = rs.getInt("id");
int point_id =rs.getInt("point_id");
int lun_ci =rs.getInt("lun_ci");
String status = rs.getString("status");
int status_id =rs.getInt("status_id");
String function = rs.getString("function");
String electric = rs.getString("electric");
String power = rs.getString("power" );
int X = rs.getInt("X");
int Y = rs.getInt("Y");
p = new Point(id2,point_id,lun_ci, status_id,status, function, electric, power,
X, Y);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return p;
}
/**
* 添加节点
*/
public boolean addPoint(Point p) {
boolean flag = false;
String sql = "insert into point(point_id,lun_ci,status,status_id ,electric,function,power,x,y) values (?,?,?,?,?,?,?,?,?)";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setInt(1, p.getPoint_id());
psmt.setInt(2, p.getLun_ci());
psmt.setInt(4, p.getStatus_id());
psmt.setString(3, p.getStatus());
psmt.setString(5, p.getElectric());
psmt.setString(6, p.getFunction());
psmt.setString(7, p.getPower());
psmt.setInt(8, p.getX());
psmt.setInt(9, p.getY());
int i = psmt.executeUpdate();
if (i == 1) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
/**
* 根据id删除节点
*
*
*/
public boolean delPoint(int id) {
boolean flag = false;
String sql = "delete from Point where id=?";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setInt(1, id);
if (psmt.executeUpdate() > 0) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
/**
*
*
*
* 删除全部节点
*
*
* */
public boolean delAllPoint(){
boolean flag = false;
String sql = "TRUNCATE TABLE Point";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
if (psmt.executeUpdate() > 0) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
/**
* 更新节点对象
*/
public boolean updatePoint(Point p) {
boolean flag = false;
String sql = "update Point set status=?,function=?,power=?,x=?,y=?,point_id=? where id=? ";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setString(1, p.getStatus());
psmt.setString(2, p.getFunction());
psmt.setString(3, p.getPower());
psmt.setInt(4, p.getX());
psmt.setInt(5, p.getY());
psmt.setInt(6, p.getPoint_id());
psmt.setInt(7, p.getId());
int i = psmt.executeUpdate();
if (i == 1) {
flag = true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
}
/**
* 获得所有节点对象
*/
public List StSelect() {
List list = new ArrayList();
String sql = "select * from Point";
try {
Statement smt = conn.createStatement();
ResultSet rs = smt.executeQuery(sql);
while (rs.next()) {
int id = rs.getInt("id");
int point_id =rs.getInt("point_id");
int lun_ci =rs.getInt("lun_ci");
String status = rs.getString("status");
int status_id =rs.getInt("status_id");
String function = rs.getString("function");
String electric = rs.getString("electric");
String power = rs.getString("power" );
int X = rs.getInt("X");
int Y = rs.getInt("Y");
Point p = new Point(id,point_id,lun_ci, status_id,status, function, electric, power,
X, Y);
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public List StSelect2(int lunci) {
List list = new ArrayList();
String sql = "select * from Point where lun_ci=?";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setInt(1, lunci);
ResultSet rs = psmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
int point_id =rs.getInt("point_id");
int lun_ci =rs.getInt("lun_ci");
String status = rs.getString("status");
int status_id =rs.getInt("status_id");
String function = rs.getString("function");
String electric = rs.getString("electric");
String power = rs.getString("power" );
int X = rs.getInt("X");
int Y = rs.getInt("Y");
Point p = new Point(id,point_id,lun_ci, status_id,status, function, electric, power,
X, Y);
list.add(p);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public List SelectX(int lunci) {
List list = new ArrayList();
String sql = "select distinct X ,Y from Point where lun_ci=?";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setInt(1, lunci);
ResultSet rs = psmt.executeQuery();
while (rs.next()) {
int X = rs.getInt("X");
list.add(X);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public List SelectY(int lunci) {
List list = new ArrayList();
String sql = "select distinct X, Y from Point where lun_ci=?";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setInt(1, lunci);
ResultSet rs = psmt.executeQuery();
while (rs.next()) {
int Y = rs.getInt("Y");
list.add(Y);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public List Select_status_id(int lun_ci) {
List list = new ArrayList();
String sql = "select status_id from Point where lun_ci=?";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setInt(1, lun_ci);
ResultSet rs = psmt.executeQuery();
while (rs.next()) {
String status_id =rs.getString("status_id");
list.add(status_id);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
javaweb项目源码
共112个文件
java:18个
class:18个
tld:15个
3星 · 超过75%的资源 需积分: 49 36 下载量 191 浏览量
2017-12-21
17:23:21
上传
评论 2
收藏 2.61MB RAR 举报
温馨提示
水下传感网络平面部署系统,残废品,是一种新型的Javaweb项目开发
资源推荐
资源详情
资源评论
收起资源包目录
javaweb项目源码 (112个子文件)
PointDaoImpl.class 6KB
AddServlet.class 4KB
ImageServlet.class 4KB
Point.class 4KB
PageServlet.class 3KB
LoginFilter.class 3KB
DrawSerlet.class 3KB
ShowServlet.class 2KB
UpdateServlet.class 2KB
DbConn.class 2KB
ShowAllServlet.class 1KB
UserDaoImpl.class 1KB
EncodingFilter.class 1KB
LoginServlet.class 1KB
User.class 1KB
StringUtil.class 625B
PointDao.class 430B
UserDao.class 153B
.classpath 622B
org.eclipse.wst.common.component 453B
org.eclipse.wst.jsdt.ui.superType.container 49B
bootstrap.min.css 120KB
font-awesome.min.css 23KB
style.css 6KB
fontawesome-webfont.eot 59KB
glyphicons-halflings-regular.eot 20KB
mysql-connector-java-5.1.6-bin.jar 687KB
standard.jar 384KB
jstl.jar 20KB
PointDaoImpl.java 7KB
AddServlet.java 4KB
Point.java 3KB
ImageServlet.java 3KB
PageServlet.java 3KB
LoginServlet.java 2KB
DrawSerlet.java 2KB
LoginFilter.java 2KB
ShowServlet.java 2KB
DbConn.java 2KB
UpdateServlet.java 2KB
PointDao.java 1KB
ShowAllServlet.java 1KB
EncodingFilter.java 1022B
UserDaoImpl.java 935B
User.java 658B
StringUtil.java 378B
UserDao.java 256B
banner.jpeg 158KB
bg.jpg 226KB
404.jpg 70KB
jquery.min.js 94KB
bootstrap.min.js 36KB
.jsdtscope 500B
dgra.jsp 8KB
updanode.jsp 6KB
login.jsp 5KB
addnode.jsp 5KB
main.jsp 4KB
info2.jsp 4KB
info.jsp 3KB
left.jsp 2KB
error.jsp 1KB
index.jsp 1004B
top.jsp 963B
MANIFEST.MF 36B
.mymetadata 288B
org.eclipse.wst.jsdt.ui.superType.name 6B
FontAwesome.otf 92KB
3.png 189KB
1.png 185KB
2.png 176KB
checkup.png 7KB
wb.png 6KB
heartbeat.png 6KB
medicalcase.png 6KB
qq.png 5KB
bd.png 4KB
org.eclipse.jdt.core.prefs 364B
com.genuitec.eclipse.core.prefs 151B
org.eclipse.core.resources.prefs 93B
.project 2KB
db.properties 140B
db.properties 140B
point.sql 11KB
point.sql 11KB
user.sql 791B
user.sql 791B
fontawesome-webfont.svg 306KB
glyphicons-halflings-regular.svg 106KB
fmt.tld 19KB
c.tld 16KB
fmt-1_0.tld 12KB
x.tld 12KB
fmt-1_0-rt.tld 11KB
c-1_0.tld 11KB
c-1_0-rt.tld 11KB
sql.tld 8KB
x-1_0.tld 7KB
fn.tld 7KB
x-1_0-rt.tld 7KB
共 112 条
- 1
- 2
资源评论
- xixi_tan2018-02-26只有个登录界面,什么验证都没做。
wd153755199
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于双向 LSTM 中文微博情感分类项目功能实现
- PHP新闻管理系统设计与实现 毕业设计
- STM32单片机FPGA毕设电路原理论文报告汽车电动助力转向单片机控制系统设计与试验研究
- STM32单片机FPGA毕设电路原理论文报告气压传感器神经网络算法及单片机实现
- 西南交大-大学物理A作业-2019-带参考答案
- c++语言大作业,校区人员管理系统framework.zip
- 多目标优化算法集合,包含使用手册
- c语言程序设计大作业 课程设计 高分大作业98分.zip
- STM32单片机FPGA毕设电路原理论文报告频率的测量在单片机设计中的应用
- 音频转码工具(用于将微信语音 amr 格式转换为 mp3 格式以便在 html5 的 audio 标签中进行播放).zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功