<%@ 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>