<%
request.setCharacterEncoding("GBK");
Connection con=null;
Statement stmt = null;
ResultSet rs = null;
String name=request.getParameter("xingm");
String email=request.getParameter("email");
String telepho=request.getParameter("telepho");
String content=request.getParameter("content");
Date date=new Date();
java.text.SimpleDateFormat formater = new java.text.SimpleDateFormat("yyyy-MM-dd");
String strDateTime = "";
if(date!=null){
strDateTime = formater.format(date);
}
try {
//加载 Oracle jdbc thin 驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//Oracle thin jdbc URL
String url="jdbc:oracle:thin:@192.168.10.2:1521:ora10";
con = DriverManager.getConnection(url,"TRSPORTALV6","TRSPORTALV6");
stmt=con.createStatement();
if(content!=null){
String sql="insert into lyb values(lybseq.nextval,'"+name+"','"+email+"','"+telepho+"','"+content+"',to_date('"+strDateTime+"','yyyy-mm-dd'))";
int bflag=stmt.executeUpdate(sql);
if(bflag>0){
System.out.println(bflag);
%>
<script type="text/javascript"> alert('发表留言成功'); </script>
<%
}else{
%>
<script type="text/javascript"> alert('发表留言失败'); </script>
<%
}
}
rs=stmt.executeQuery("select t.content cont,to_char(t.curdate,'yyyy.mm.dd') curd from lyb t order by t.curdate desc,t.id desc ");
%>我想在留言发送成功以后(bflag>0)弹出一个js对话框 发表留言成功,否则弹出发表留言失败对话框。
但发表留言以后始终没有弹出,但代码是执行了,而且生产的servlet也执行了,请各位赐教。
request.setCharacterEncoding("GBK");
Connection con=null;
Statement stmt = null;
ResultSet rs = null;
String name=request.getParameter("xingm");
String email=request.getParameter("email");
String telepho=request.getParameter("telepho");
String content=request.getParameter("content");
Date date=new Date();
java.text.SimpleDateFormat formater = new java.text.SimpleDateFormat("yyyy-MM-dd");
String strDateTime = "";
if(date!=null){
strDateTime = formater.format(date);
}
try {
//加载 Oracle jdbc thin 驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//Oracle thin jdbc URL
String url="jdbc:oracle:thin:@192.168.10.2:1521:ora10";
con = DriverManager.getConnection(url,"TRSPORTALV6","TRSPORTALV6");
stmt=con.createStatement();
if(content!=null){
String sql="insert into lyb values(lybseq.nextval,'"+name+"','"+email+"','"+telepho+"','"+content+"',to_date('"+strDateTime+"','yyyy-mm-dd'))";
int bflag=stmt.executeUpdate(sql);
if(bflag>0){
System.out.println(bflag);
%>
<script type="text/javascript"> alert('发表留言成功'); </script>
<%
}else{
%>
<script type="text/javascript"> alert('发表留言失败'); </script>
<%
}
}
rs=stmt.executeQuery("select t.content cont,to_char(t.curdate,'yyyy.mm.dd') curd from lyb t order by t.curdate desc,t.id desc ");
%>我想在留言发送成功以后(bflag>0)弹出一个js对话框 发表留言成功,否则弹出发表留言失败对话框。
但发表留言以后始终没有弹出,但代码是执行了,而且生产的servlet也执行了,请各位赐教。
<%
}else{
%>
<script type="text/javascript"> alert('发表留言失败'); </script>
<%
}
在留言发送成功以后(bflag>0)弹出一个js对话框条件没写吧?
if(bflag>0){
System.out.println(bflag);
%>
<script type="text/javascript"> alert('发表留言成功'); </script>
<%
}else{
%>
<script type="text/javascript"> alert('发表留言失败'); </script>
<%
}
}
rs=stmt.executeQuery("select t.content cont,to_char(t.curdate,'yyyy.mm.dd') curd from lyb t order by t.curdate desc,t.id desc ");
%>
if(bflag>0)就是条件啊?
谢谢
加个language="javaScript"试一下.
<script type="javascript" language="javaScript"> alert('发表留言成功'); </script>
<%
request.setCharacterEncoding("GBK");
Connection con=null;
Statement stmt = null;
ResultSet rs = null;
String name=request.getParameter("xingm");
String email=request.getParameter("email");
String telepho=request.getParameter("telepho");
String content=request.getParameter("content");
Date date=new Date();
java.text.SimpleDateFormat formater = new java.text.SimpleDateFormat("yyyy-MM-dd");
String strDateTime = "";
if(date!=null){
strDateTime = formater.format(date);
}
try {
//加载 Oracle jdbc thin 驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//Oracle thin jdbc URL
String url="jdbc:oracle:thin:@192.168.10.2:1521:ora10";
con = DriverManager.getConnection(url,"TRSPORTALV6","TRSPORTALV6");
stmt=con.createStatement();
if(content!=null){
String sql="insert into lyb values(lybseq.nextval,'"+name+"','"+email+"','"+telepho+"','"+content+"',to_date('"+strDateTime+"','yyyy-mm-dd'))";
int bflag=stmt.executeUpdate(sql);
if(bflag>0){
System.out.println(bflag);
%>
<script language="javaScript" type="text/javascript"> alert('发表留言成功'); </script>
<%
}else{
%>
<script language="javaScript" type="text/javascript"> alert('发表留言失败'); </script>
<%
}
}
rs=stmt.executeQuery("select t.content cont,to_char(t.curdate,'yyyy.mm.dd') curd from lyb t order by t.curdate desc,t.id desc ");
%>
<%
request.setCharacterEncoding("GBK");
Connection con=null;
Statement stmt = null;
ResultSet rs = null;
String name=request.getParameter("xingm");
String email=request.getParameter("email");
String telepho=request.getParameter("telepho");
String content=request.getParameter("content");
Date date=new Date();
java.text.SimpleDateFormat formater = new java.text.SimpleDateFormat("yyyy-MM-dd");
String strDateTime = "";
if(date!=null){
strDateTime = formater.format(date);
}
try {
//加载 Oracle jdbc thin 驱动程序
Class.forName("oracle.jdbc.driver.OracleDriver");
//Oracle thin jdbc URL
String url="jdbc:oracle:thin:@192.168.10.2:1521:ora10";
con = DriverManager.getConnection(url,"TRSPORTALV6","TRSPORTALV6");
stmt=con.createStatement();
if(content!=null){
String sql="insert into lyb values(lybseq.nextval,'"+name+"','"+email+"','"+telepho+"','"+content+"',to_date('"+strDateTime+"','yyyy-mm-dd'))";
int bflag=stmt.executeUpdate(sql);
//修改了这段
if(bflag>0){
out.print("<script>alert('发表留言成功');<script>");
}else{
out.print("<script>alert('发表留言成功');<script>");
}
//修改了上面这点 试试
rs=stmt.executeQuery("select t.content cont,to_char(t.curdate,'yyyy.mm.dd') curd from lyb t order by t.curdate desc,t.id desc ");
%>