generator-tablewrite

s= "tableWrite?"+
"db=erp&"+
"table=USER&"+
"fields=login_id,recordid, db, company_name,password,parent_recordid&"+
"values="+
"'"+s4+"'"+","+
"'"+s3+"'"+","+
"'"+s5+"'"+","+
"'"+s6+"'"+
","+"'"+s1+"'"+
","+"'"+s7+"'"+
"&callback=?";
$.getJSON(s, function(){document.write(s);});



table-write.java

// insert
// e.g. http://192.168.10.80:8080/hr/tableWrite?table=employee&fields=recordID,firstname&values=3,%22peter%22&callback=testsxss
// e.g. http://192.168.10.80:8080/hr/tableWrite?table=employee&fields=recordID,firstname&values=13,%22peter13%22&callback=testsxss
// update
// e.g. http://192.168.10.80:8080/hr/tableWrite?table=employee&fields=recordID,firstname&values=3,%22peter%22&callback=testsxss&key=recordID&value=1
// http://192.168.10.80:8080/hr/tableWrite?table=employee&fields=firstname&values=%22peter%22&callback=testsxss&key=recordID&value=1
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class tableWrite extends HttpServlet
{
static String key="";
static String values="";
static String value="";
static String result="";
static String table = "";
static String fields = "" ;
static String _r = "";
static String format="";
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
response.setContentType("text/html");
String sqlString = "";
PrintWriter out= response.getWriter();
table = request.getParameter("table");
fields = request.getParameter("fields");
values = request.getParameter("values");
String callback = request.getParameter("callback");
String value_2="0",value_3="0",value_4="0",value_5="0";
value = (request.getParameter("value") != null)?request.getParameter("value") : "";
format = (request.getParameter("format") != null)?request.getParameter("format") : "";
key = (request.getParameter("key") != null)?request.getParameter("key") : "";
int iValue=0,iValue2=0, iValue3=0,iValue4=0, iValue5=0;
int iSignificant=4; // 4 is default
if (key.trim().equals("")){
sqlString="insert ignore into  "+table+" ( "+fields+") value ("+values +" ) ;";
} else {
sqlString="update "+ table+ " set ";
String updateFields[]=fields.split(",");
String updateValues[]=values.split(",");
String delimiter="";
for (int rr = 0; rr< updateFields.length;rr++)
{sqlString=sqlString+delimiter+
updateFields[rr]+" = "+updateValues[rr];
delimiter=",";
}
sqlString=sqlString+ " where " +key +" = "+value+" ;" ;
}
out.println(sqlString);
String className= "com.mysql.jdbc.Driver";
String url= "jdbc:mysql://192.168.10.80/hr?useUnicode=true&characterEncoding=UTF8";
String user="root"; String password= "root";Connection con;
PreparedStatement ps;ResultSet rs;
try
{
Class.forName(className);
con= DriverManager.getConnection(url, user, password);
ps=con.prepareStatement(sqlString);
ps.executeUpdate();
}
catch(SQLException sx)
{
out.println(sx);
}
catch(ClassNotFoundException cx)
{
out.println(cx);
}
}
}