eclipse里
在jsp页面输入的数据 插入数据库 public Tstock getStockMN(String MerNumber)
{
Tstock tstock;
String sql;
PreparedStatement pstat;
ResultSet rs;
Connection conn;
tstock = new Tstock();
sql = "SELECT * FROM Stock WHERE MerNumber=?";
pstat = null;
rs = null;
conn = (new DBHelper()).getConn();
try
{
pstat = conn.prepareStatement(sql);
pstat.setString(1, MerNumber);
for(rs = pstat.executeQuery(); rs.next(); tstock.setOrderDate(rs.getDate(9)))
{
tstock.setOrderNumber(rs.getString(1));
tstock.setAdminNumber(rs.getString(2));
tstock.setMerNumber(rs.getString(3));
tstock.setMerName(rs.getString(4));
}
... ...
}这里是插入的varchar类型的数据 如果我要 插入整型数据 浮点型数据rs.getString(4) 应该改为什么呢。谢了
在jsp页面输入的数据 插入数据库 public Tstock getStockMN(String MerNumber)
{
Tstock tstock;
String sql;
PreparedStatement pstat;
ResultSet rs;
Connection conn;
tstock = new Tstock();
sql = "SELECT * FROM Stock WHERE MerNumber=?";
pstat = null;
rs = null;
conn = (new DBHelper()).getConn();
try
{
pstat = conn.prepareStatement(sql);
pstat.setString(1, MerNumber);
for(rs = pstat.executeQuery(); rs.next(); tstock.setOrderDate(rs.getDate(9)))
{
tstock.setOrderNumber(rs.getString(1));
tstock.setAdminNumber(rs.getString(2));
tstock.setMerNumber(rs.getString(3));
tstock.setMerName(rs.getString(4));
}
... ...
}这里是插入的varchar类型的数据 如果我要 插入整型数据 浮点型数据rs.getString(4) 应该改为什么呢。谢了
rs.getString(4)此类型由你数据库字段决定,所以只能通过程序转化类型来达到你的要求。两种方法:
1,tstock.setMerName(String merName)
保持参数为STRING类型,然后在使用时再转换Float.valueOf(tstock.getMerName())2,tstock.setMerName(Float merName)
保持参数为Float类型,
tstock.setMerName(Float.valueOf(rs.getString(4)));
然后在使用时无须再转换tstock.getMerName()
欢迎加入