该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
public List findAll() {
List list = new ArrayList<>();
PreparedStatement stmt = null;
ResultSet rs = null;
try{
String sql = "select customer_id,customer_name,customer_account,sex,customer_password,email,phone,credits from customer order by customer_id desc";
stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();
while(rs.next()){
int customerId = rs.getInt("customer_id");
String customerName = rs.getString("customer_name");
String customerAccount = rs.getString("customer_account");
String sex = rs.getString("sex");
String customerPassword = rs.getString("customer_password");
String email = rs.getString("email");
String phone = rs.getString("phone");
Double credits = rs.getDouble("credits");
list.add(new Customer(customerId,customerName,customerAccount,sex,customerPassword,email,phone,credits));
}
}catch(SQLException e){
e.printStackTrace();
throw new QXcmsException("查询客户信息失败");
}finally{
DBUtil.closeAll(null, stmt, rs);
}
return list;
}
然后怎么在就是测试类里面写获得这个新增的序列值,就是customerId.....大神写一句来助我，我是菜鸟~

java实体Bean中
import java.util.Date;
private Date ReleaseDate;
struts.xml应射文件中的
如果将黄色部分写成Date就不能将时间插入到数据库中.
type="date"                结果：  2009-10-27
type="java.util.Date"    结果：  2009-10-27 18:58:42
=============================================
在java中获取当前时间
先导包:
import java.util.Calendar;
import java.util.Date;
java.util.Date now = new java.util.Date();
方法1.  DateFormat nowDate=DateFormat.getDateTimeInstance(DateFormat.FULL,DateFormat.FULL);
String strNowDate = nowDate.format(now);
System.out.println("时间   "+ new java.util.Date());
方法2.   Calendar calendar=Calendar.getInstance();
Date dt=calendar.getTime();
System.out.println("时间ssssssss   "+ dt);
方法3.    System.out.println(new java.util.Date());

转：
原创 编码小王子 发布于2018-10-11 18:07:52 阅读数 2722 收藏
展开
java大型项目中都会很多系统常量,比如说数据库的账号和密码,以及各种token值等,都需要统一的管理,如果零落的散布到各个类等具体的代码中的话,在后期管理上将是一场灾难,所有需要对这些变量进行统一的管理,一般都会放到web-service.properties文件中,该文件在项目中的位置如下:
web-service.properties文件里的内容大概如下:
那么如何获取web-service.properties文件里的值呢?
1,需要在配置文件里配置Spring的PropertyPlaceholderConfigurer,具体格式如下:
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
classpath:conf/web-service.properties
2,编写通用类
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class PropUtils {
private static Logger logger = LoggerFactory.getLogger(PropUtils.class);
private static Properties properties;
static {
InputStream in = null;
try {
properties = new Properties();
in = PropUtils.class.getResourceAsStream("/conf/web-service.properties");
properties.load(in);
} catch (IOException e) {
e.printStackTrace();
}
}
public static  String  getProp(String key){
return properties.getProperty(key);
}
}
3,调用通用类
String maxWait = PropUtils.getProp("maxWait_2");
————————————————
版权声明：本文为CSDN博主「编码小王子」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/u011900448/article/details/83016579

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
public List findAll() {
List list = new ArrayList<>();
PreparedStatement stmt = null;
ResultSet rs = null;
try{
String sql = "select customer_id,customer_name,customer_account,sex,customer_password,email,phone,credits from customer order by customer_id desc";
stmt = conn.prepareStatement(sql);
rs = stmt.executeQuery();
while(rs.next()){
int customerId = rs.getInt("customer_id");
String customerName = rs.getString("customer_name");
String customerAccount = rs.getString("customer_account");
String sex = rs.getString("sex");
String customerPassword = rs.getString("customer_password");
String email = rs.getString("email");
String phone = rs.getString("phone");
Double credits = rs.getDouble("credits");
list.add(new Customer(customerId,customerName,customerAccount,sex,customerPassword,email,phone,credits));
}
}catch(SQLException e){
e.printStackTrace();
throw new QXcmsException("查询客户信息失败");
}finally{
DBUtil.closeAll(null, stmt, rs);
}
return list;
}
然后怎么在就是测试类里面写获得这个新增的序列值,就是customerId.....大神写一句来助我，我是菜鸟~