JavaEE-数据传递 - 黑马程序员技术交流社区

package servlet;
import java.sql.Connection;
import java.sql.DriverManager;
public class MyDataBase {
private Connection Conn;
public Connection dbConnection(){
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=BankCreditLoanDB", "sa","123456");
} catch (Exception e) {
}
return Conn;
}
}

复制代码

package servlet;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import model.T_bail_info;
public class MyService {
private Connection conn;
private MyDataBase dBase;
private PreparedStatement pstmt;
public List<T_bail_info> list(){
List<T_bail_info> list = new ArrayList<T_bail_info>();
dBase = new MyDataBase();
conn = dBase.dbConnection();
String sql = "select * from T_bail_info";
try {
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while(rs.next()){
T_bail_info cat = new T_bail_info();
cat.setBail_account(rs.getString("Bail_account"));
cat.setBail_status(rs.getString("Bail_account"));
cat.setBail_total_amount(rs.getInt("Bail_total_amount"));
cat.setContract_id(rs.getString("Contract_id"));
cat.setCust_id(rs.getString("Cust_id"));
cat.setFreezeFlag(rs.getString("FreezeFlag"));
list.add(cat);
}
} catch (SQLException e) {
}
return list;
}
}

复制代码

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<link href="css/Content.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="div_top">客户保证金款管理 > 添加保证金信息</div>
<div class="div_con">
<table width="100%" cellspacing="1" cellpadding="0" border="0" bgcolor="#ccc">
<tr align="center">
<td width="20%">客户名称<font color="#f00">*</font></td>
<td width="30%"><select name="Cust_id">
<option value="2011070101" selected="selected">长沙创新科技有限公司</option>
<option value="2011070102">长沙奔流信息有限公司</option>
<option value="2011070103">长沙蓝海科技有限公司</option>
</select></td>
<td width="20%"></td>
<td width="30%"></td>
</tr>
<tr align="center">
<td>保证金帐号<font color="#FF0000">*</font></td>
<td><input type="text" name="Bail_account"/></td>
<td>冻结标志<font color="#FF0000">*</font></td>
<td>
<select name="FreezeFlag">
<option value="Y" selected="selected">是</option>
<option value="N">否</option>
</select>
</td>
</tr>
<tr align="center">
<td>保证金金额<font color="#FF0000">*</font></td>
<td><input type="text" name="Bail_total_amount" /></td>
<td>保证金状态<font color="#FF0000">*</font></td>
<td>
<select name="Bail_status">
<option value="缴付" selected="selected">缴付</option>
<option value="退还">退还</option>
</select></td>
</tr>
</table>
</div>
<div class="div_down">
<input id="btn_submit" type="button" value="保存信息" style="cursor:hand;" />
<input id="btn_reset" type="reset" value="重新输入" style="cursor:hand;" />
</div>
</body>
</html>

复制代码