以下是我的代码,求高手解答,为什么是乱码了、、、
DBOperator DB = new DBOperator();
ResultSet rs = null;
Connection conn = null;
PreparedStatement pstmt = null;
int result = 0;
String sql = "insert into rw(cphm,sjxm,rwid,wtr,mdd,yn) values(?,?,?,?,?,?)";
String sql1 = "select * from dingdan where id ="+Integer.parseInt(request.getParameter("rwid"));
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>增派任务</TITLE></HEAD>");
out.println(" <BODY>");
try {
conn = DB.createConnection();
rs = DB.executeQuery(sql1);
if(rs.next()){
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, request.getParameter("cphm").trim());
pstmt.setString(2, request.getParameter("sjxm").trim());
pstmt.setString(3, request.getParameter("rwid").trim());
pstmt.setString(4, request.getParameter("wtr").trim());
pstmt.setString(5, request.getParameter("mdd").trim());
pstmt.setString(6, "0");
result = pstmt.executeUpdate();
pstmt.close();
conn.close();
if(result==0){
out.println("对不起,增派失败!");
out.println("<a href='/wlxt/zprw.html'>重新输入</a>");
}else{
out.println("恭喜!输入成功!"+"<br>"+"<br>");
out.println("车牌号码:<br>"+request.getParameter("cphm")+"<br>"+"<br>");
out.println("司机姓名:<br>"+request.getParameter("sjxm").trim()+"<br>"+"<br>");
out.println("任务ID:<br>"+request.getParameter("rwid").trim()+"<br>"+"<br>");
out.println("委托人:<br>"+request.getParameter("wtr").trim()+"<br>"+"<br>");
out.println("目的地:<br>"+request.getParameter("mdd").trim()+"<br>"+"<br>");
out.println("<a href='/wlxt/ywgl.html'>返回主菜单</a>");
}
}else{
out.println("对不起,不存在此订单!");
out.println("<a href='/wlxt/zprw.html'>重新输入</a>");
}
} catch (SQLException e) {
System.out.println("连接数据库出错!");
e.printStackTrace();
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
DBOperator DB = new DBOperator();
ResultSet rs = null;
Connection conn = null;
PreparedStatement pstmt = null;
int result = 0;
String sql = "insert into rw(cphm,sjxm,rwid,wtr,mdd,yn) values(?,?,?,?,?,?)";
String sql1 = "select * from dingdan where id ="+Integer.parseInt(request.getParameter("rwid"));
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>增派任务</TITLE></HEAD>");
out.println(" <BODY>");
try {
conn = DB.createConnection();
rs = DB.executeQuery(sql1);
if(rs.next()){
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, request.getParameter("cphm").trim());
pstmt.setString(2, request.getParameter("sjxm").trim());
pstmt.setString(3, request.getParameter("rwid").trim());
pstmt.setString(4, request.getParameter("wtr").trim());
pstmt.setString(5, request.getParameter("mdd").trim());
pstmt.setString(6, "0");
result = pstmt.executeUpdate();
pstmt.close();
conn.close();
if(result==0){
out.println("对不起,增派失败!");
out.println("<a href='/wlxt/zprw.html'>重新输入</a>");
}else{
out.println("恭喜!输入成功!"+"<br>"+"<br>");
out.println("车牌号码:<br>"+request.getParameter("cphm")+"<br>"+"<br>");
out.println("司机姓名:<br>"+request.getParameter("sjxm").trim()+"<br>"+"<br>");
out.println("任务ID:<br>"+request.getParameter("rwid").trim()+"<br>"+"<br>");
out.println("委托人:<br>"+request.getParameter("wtr").trim()+"<br>"+"<br>");
out.println("目的地:<br>"+request.getParameter("mdd").trim()+"<br>"+"<br>");
out.println("<a href='/wlxt/ywgl.html'>返回主菜单</a>");
}
}else{
out.println("对不起,不存在此订单!");
out.println("<a href='/wlxt/zprw.html'>重新输入</a>");
}
} catch (SQLException e) {
System.out.println("连接数据库出错!");
e.printStackTrace();
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
解决方案 »
- Axis调用,返回结果"Failure of the loading"
- 求解为什么我总是连接不上数据库?
- 数字类型转换BigDecimal类型 变成NULL值,请求帮忙
- 今天是平安夜,我男朋友却没有陪我过
- java中的文件上传进度条原理是什么哈
- struts框架中怎么做报表呢,action中总报错
- validate的问题
- JSP线程安全
- 请问jsp如何在tomcat发布?
- Vector vSubInsureType=(Vector)hBaseInfo.get("vSubInsureType");(很简单的)
- 做项目遇到一个棘手的问题,求高手解答,在线等解答......急急
- 哪里有j2ee视频的下载啊 最好是尚学堂马士兵的
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE2 {
font-size: 24px;
font-weight: bold;
}
-->
</style>
</head>
你上面的HTML都是out.println输出的啊。输出HEAD的时候加一句。
改之前:conn = DB.createConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, request.getParameter("cphm").trim());
pstmt.setString(2, request.getParameter("sjxm").trim());
pstmt.setString(3, request.getParameter("rwid").trim());
pstmt.setString(4, request.getParameter("wtr").trim());
pstmt.setString(5, request.getParameter("mdd").trim());
pstmt.setString(6, "0");
result = pstmt.executeUpdate();
pstmt.close();
conn.close();
if(result==0){
out.println("对不起,增派失败!");
out.println("<a href='/wlxt/zprw.html'>重新输入</a>");
}else{
out.println("恭喜!输入成功!"+"<br>"+"<br>");
out.println("车牌号码:<br>"+request.getParameter("cphm").trim()+"<br>"+"<br>");
out.println("司机姓名:<br>"+request.getParameter("sjxm").trim()+"<br>"+"<br>");
out.println("任务ID:<br>"+request.getParameter("rwid").trim()+"<br>"+"<br>");
out.println("委托人:<br>"+request.getParameter("wtr").trim()+"<br>"+"<br>");
out.println("目的地:<br>"+request.getParameter("mdd").trim()+"<br>"+"<br>");
out.println("<a href='/wlxt/ywgl.html'>返回主菜单</a>");
}
改之后:
conn = DB.createConnection();
rs = DB.executeQuery(sql1);
if(rs.next()){
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, request.getParameter("cphm").trim());
pstmt.setString(2, request.getParameter("sjxm").trim());
pstmt.setString(3, request.getParameter("rwid").trim());
pstmt.setString(4, request.getParameter("wtr").trim());
pstmt.setString(5, request.getParameter("mdd").trim());
pstmt.setString(6, "0");
result = pstmt.executeUpdate();
pstmt.close();
conn.close();
if(result==0){
out.println("对不起,增派失败!");
out.println("<a href='/wlxt/zprw.html'>重新输入</a>");
}else{
out.println("恭喜!输入成功!"+"<br>"+"<br>");
out.println("车牌号码:<br>"+request.getParameter("cphm")+"<br>"+"<br>");
out.println("司机姓名:<br>"+request.getParameter("sjxm").trim()+"<br>"+"<br>");
out.println("任务ID:<br>"+request.getParameter("rwid").trim()+"<br>"+"<br>");
out.println("委托人:<br>"+request.getParameter("wtr").trim()+"<br>"+"<br>");
out.println("目的地:<br>"+request.getParameter("mdd").trim()+"<br>"+"<br>");
out.println("<a href='/wlxt/ywgl.html'>返回主菜单</a>");
}
}else{
out.println("对不起,不存在此订单!");
out.println("<a href='/wlxt/zprw.html'>重新输入</a>");
}
以后多多交流,可以关注我的微博:http://t.qq.com/zhuzhu5023
response.setContentType("text/html;charset=utf-8");