Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String mmobile = mobile;
- //Prepare Url
- URLConnection myURLConnection=null;
- URL myURL=null;
- BufferedReader reader=null;
- String mainUrl="http://localhost:8080/Portal/example.jsp?";
- //Prepare parameter string
- StringBuilder sbPostData= new StringBuilder(mainUrl);
- sbPostData.append("mobile=").append(mmobile);
- //final string
- mainUrl = sbPostData.toString();
- try
- {
- //prepare connection
- myURL = new URL(mainUrl);
- myURLConnection = myURL.openConnection();
- myURLConnection.connect();
- }
- catch (IOException e)
- <%@page import="java.sql.*"
- %>
- <%@ page import="myclass.SAMPLE" %>
- <%
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection conn = null;
- String mphone = request.getParameter("mobile");
- int mcompregkeyid=0;
- try {
- conn = DriverManager.getConnection("jdbc:mysql://localhost/myschema","myuser","mypass");
- Statement stmt = conn.createStatement();
- ResultSet rset = stmt.executeQuery("Select max(keyid) from mytable");
- rset.next();
- mcompregkeyid=rset.getInt(1);
- } finally {
- if (conn != null) try { conn.close(); } catch (SQLException e) {
- out.println("("Could not connect to local server.nPlease try after some time.!!!")");
- }
- }
- SAMPLE.getValue(String.valueOf(mcompregkeyid));
- %>
Add Comment
Please, Sign In to add comment