Posts

  JavaScript : Pass parameters/variables values between jsp/Html Files as  Global variables using localStorage,setitem / localStorage,getitem  write function as below in one jsp/html file  function passvalues() { var fname=document.getElementById("txt").value; localStorage.setItem("textvalue",fname); var fyear = document.getElementById("txt1").value; localStorage.setItem("text_value",fyear); var valdisp = fname +'       '+fyear; localStorage.setItem("txtval",valdisp);; return false } </script> txt & txt1 are input type text fields whose values are passed,next call href tag to pass functions and file name as follows <a onclick="passvalues();" href="student_fee.jsp">Fee Process</a> <td><h3><span id = "result"></span></h3>;</td> <td><h3>Year :<span id = "result1"></span></h3></td> ...
 In order to develop online application one needs to configure/install following software 1.) Frontend Designer/tools like Java swing,Html,css,JSP,React js(Javascript library) etc.. 2.) Backend Database like Mysql,Oracle or any sql based database. 3.) Webserver for testing application like Tomcat,Glassfish & its configurations setting.. 4.) Reporting Tools like Jasper Report(Jaspersoft studio),Crystal Reportwirter etc.. 5.) Integrated Development Environment (IDE) like Eclipse,Visual Studio code,Netbeans.IntelliJ etc.. A lot more libraries needed while developing application.. A few online resources can be very helpful to sort out problems like w3schools, Javatutorial, Youtube videos,stackoverflow forum and many more... Online educational videos from Edureka,courses from Udemy In my previous post I share useful code & tips to overcome problems while developing applications. In my next post I share jsp code,jasper reports code and Tomcat settings to develop online applicatio...
  How to Pass/Print Parameter values in JSP To print parameter values in input text field (value property) first write sql to extract database values and pass to another JSP , following code will be helpful... String RNO = request.getParameter("ReceNo"); receipt no. is database values and store its values RNO string variable. To print its value in JSP form input text field <td><label for="ReceiptNo">Receipt No.:</label></td>        <td><input type="text"  id = "ReceiptNo" name="ReceiptNo"  value="<%=request.getParameter("ReceNo")%>" size="5"  /></td> here <td>,<tr> tags in Table defined in jsp. if any difficulty mail me at psanjayy@yahoo.com 

To display data other than JTable in Java Swing

First Import sql.Dbutils(download from Internet) in java program as below import net.proteanit.sql.DbUtils; When user clicks Load Data button ,sql query executes sql statement which fetch data as per user needs or search criteria as below...  JButton btnNewButton = new JButton("Load Data"); btnNewButton.setFont(new Font("Verdana", Font.PLAIN, 12)); btnNewButton.addMouseListener(new MouseAdapter() { public void mouseClicked(MouseEvent e) { try { Connection conn = getConnection(); String query="select cast(staff_code as unsigned)Id,F_name Name,case sex when 'M' Then 'Male' when 'F' then 'Female'  end Gender,Post,grade_code Grade from sch_db.staff_master order by id"; PreparedStatement stat = conn.prepareStatement(query); ResultSet res=stat.executeQuery(); table.setModel(DbUtils.resultSetToTableModel(res)); }  catch (Exception e1) { e1.printStackTrace(); } ...
Image
  How to Create Java Menu in swing code Description: //Create Menu Bar first (first line) and create Menu item Master(3rd line) and add menu item to menu //bar(4th.line).when user clicks on Student Add item add under Master Menu item, Student Add form //opens up for record addition, here two parameters are passed from login form to Student Add form //and Displayed.   JMenuBar menuBar = new JMenuBar(); setJMenuBar(menuBar); JMenu mnMaster = new JMenu("Master"); menuBar.add(mnMaster); JMenuItem mntmStudent = new JMenuItem("Student Add"); mntmStudent.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { String Sch_name = school_name.getText(); String School_year = Sch_year.getText(); new st_master(Sch_name,School_year).setVisible(true); } }); mnMaster.add(mntmStudent); Below is Menu attached and Student Add item is highlighted ...

jasper report from java program

  How to run Jasper report from Java Program Pass Parameters from Java Program to Jasper Report, user enters three Parameters in order to run report. First make Connection to connect Mysql database from Java form(described eariler), then pass parameters using Hashmap .First parameter is report parameter , second parameter is user entered parameter such as in this case a.put("sclass",dispclass.getText()); First parameter is sclass(defined in report) , second is dispclass(defined in Java form). Call jrxml file with full path to run the report.. remaining code is easy to follow.. public void load_report() throws Exception { try {     Connection conn=getConnection();     HashMap a = new HashMap();     a.put("sclass",dispclass.getText());     a.put("stud_sec",dispsec.getText());     a.put("user_year",dispyear.getText());       String report = "C:\\mps\\fee\\mps_fee\\nominal_roll.jrxml"; ...
Image
Design Simple Report in Jasper Report GUI. As in most GUI based Report writer and Form Designer, user select various Designer objects  such as Textboxes, Radio buttons , Dropdown List item. etc.. Report writer generates source code and its properties for user.Below is such sample source code taken from Jasper report writer in which three  parameters are passed(user input) to run the query(in sql).Pay close attention how to pass parameters in Sql query(in jasper report $ sign placed before Parameters and Fields like $P{} denotes Parameters and $F{} denotes reports fields. As user design report further ,report writer automatically generates code for that. There are many predefined functions both text and numeric functions such as to convert string into numeric or Dates into String etc, and numeric functions like sum(),max(),min(),avg() and many more...    <parameter name="sclass" class="java.lang.String"> <defaultValueExpression><![CDATA[$P{sclass}]]...