//创建数据库连接
Connection connection = null;
//设置
PreparedStatement ps=null;
PreparedStatement ps2=null;
//接收
ResultSet rs = null;
//sql语句
String sql1 = "insert into 表名 (字段1,字段2,字段3,字段4) values (?,?,?)";
//INSERT INTO table_name (column1,column2,column3,...)VALUES (value1,value2,value3,...);
// 在sql语句中插入变量,格式: "? ? ...? ? ‘ " + 变量 +" ‘? ? ...? ? "
?String sql2 = "select XX,XX from(select * from 表名 where XX= ‘ "+ip+" ‘? order by XX)where ROWNUM = 1";
?String sql3 = "select XXX,XXX from 表名? where? XX= ‘ "+ip+" ‘? ";
?String sql4 = "update?表名 set XXX=?,XXX=?,XXX=? WHERE XXX= ‘ "+ip+" ‘? ? ";
?SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");? //设置日期类型 包含日期和时间
try {
try {
?
//String sql1 = "insert into 表名 (字段1,?)";? ? ?其中字段4为 date类型数据
ps1 = connection.prepareStatement(sql1);
ps1.setDouble(1,字段1对应的值);
ps1.setDouble(2,字段2对应的值);
ps1.setString(3,字段3对应的值);
??//有日期和时间
java.util.Date ud = sdf.parse((String类型变量).getFactTime() );? //ud 为(java.util.date)的date类型
java.sql.Timestamp st = new java.sql.Timestamp(ud.getTime() ); //st为(java.sql.date)的date类型,与oracle数据库的Date数据类型一致? ? ? ??
? ? ? ? //只有日期
? //java.util.Date ud = sdf.parse( (String变量).getFactTime() );???//getFactTime()返回String类型
? ? ? ? //java.sql.Date sd= new java.sql.Date(ud.getTime());
ps1.setTimestamp(4,st);? ?
ps1.executeUpdate();? //刷新
?
...
?
//?String sql3 = "select XXX,XXX from 表名? where? XX=?‘ "+ip+" ‘??";
ps2 = connection.prepareStatement(sql3);
rs = ps2.executeQuery();? ? //保存从数据库拿到的值
while (rs.next()){
a?= rs.getDouble(1);
b = rs.getDouble(2);
}
?
...
?
} catch (ParseException e) {
e.printStackTrace();
? ? }
} catch (SQLException e) {
e.printStackTrace();
}