<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*" %>
<HTML>
<HEAD>
<TITLE>
</TITLE>
</HEAD>
<BODY><%
String message=request.getParameter("Message");if(message==null)
{
%>
<form method="POST" action="Send.jsp">
<div align="center">
<table border="0" width="600" id="table1" cellspacing="0" cellpadding="0">
<tr>
<td width="137" height="30"><font face="Verdana" size="1">Phone Number</font></td>
<td width="463" height="30">
<font face="Verdana" size="1">
<input type="text" name="Number" size="20"></font></td>
</tr>
<tr>
<td width="137" height="30"><font face="Verdana" size="1">SMS Message</font></td>
<td width="463" height="30">
<font face="Verdana" size="1">
<input type="text" name="Message" size="51" value="SMS Server"></font></td>
</tr>
</table>
</div>
<p align="center"><font face="Verdana" size="1"><input type="submit" value="Send SMS" name="SendSMS"></font></p>
</form><%
}
else
{
%>
<p align="center"><font face="Verdana" size="1">
<%
String number =request.getParameter("Number");
if (number==null) number ="";
if( number.equals(""))
out.println( "Please input phone number.");
else if( message.equals(""))
out.println("Please input message.");
else
{
Connection con;
Statement stm;
ResultSet rs;
try{
//MSSQL com.microsoft.jdbc.sqlserver.SQLServerDriver
//mysql com.mysql.jdbc.Driver
String dbDriver="com.mysql.jdbc.Driver";
Class.forName(dbDriver);
//MSSQL jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=test
//Mysql jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=GBK
String dburl="jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=GBK";
con=DriverManager.getConnection(dburl,"root","");
stm=con.createStatement();
String sql="insert into SMSOut(Phone, MsgBody, Status) values ('"
+number+"','"+message+"',0)";
stm.executeUpdate(sql);
stm.close();
con.close();
out.println("Successful.");
}
catch(Exception e){
out.println("Failed. <br>");
out.println(e.getMessage());
}
}
}
%>
</font></p>
</BODY>
</HTML>
<%@ page import="java.sql.*" %>
<HTML>
<HEAD>
<TITLE>
</TITLE>
</HEAD>
<BODY><%
String message=request.getParameter("Message");if(message==null)
{
%>
<form method="POST" action="Send.jsp">
<div align="center">
<table border="0" width="600" id="table1" cellspacing="0" cellpadding="0">
<tr>
<td width="137" height="30"><font face="Verdana" size="1">Phone Number</font></td>
<td width="463" height="30">
<font face="Verdana" size="1">
<input type="text" name="Number" size="20"></font></td>
</tr>
<tr>
<td width="137" height="30"><font face="Verdana" size="1">SMS Message</font></td>
<td width="463" height="30">
<font face="Verdana" size="1">
<input type="text" name="Message" size="51" value="SMS Server"></font></td>
</tr>
</table>
</div>
<p align="center"><font face="Verdana" size="1"><input type="submit" value="Send SMS" name="SendSMS"></font></p>
</form><%
}
else
{
%>
<p align="center"><font face="Verdana" size="1">
<%
String number =request.getParameter("Number");
if (number==null) number ="";
if( number.equals(""))
out.println( "Please input phone number.");
else if( message.equals(""))
out.println("Please input message.");
else
{
Connection con;
Statement stm;
ResultSet rs;
try{
//MSSQL com.microsoft.jdbc.sqlserver.SQLServerDriver
//mysql com.mysql.jdbc.Driver
String dbDriver="com.mysql.jdbc.Driver";
Class.forName(dbDriver);
//MSSQL jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=test
//Mysql jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=GBK
String dburl="jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=GBK";
con=DriverManager.getConnection(dburl,"root","");
stm=con.createStatement();
String sql="insert into SMSOut(Phone, MsgBody, Status) values ('"
+number+"','"+message+"',0)";
stm.executeUpdate(sql);
stm.close();
con.close();
out.println("Successful.");
}
catch(Exception e){
out.println("Failed. <br>");
out.println(e.getMessage());
}
}
}
%>
</font></p>
</BODY>
</HTML>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货