R Sugan

Hi


Thanks for your response.The code snippet in "Sms_GUI.java" is as follows:

public Sms_GUI(String[] args) { super("Serial SMS Client"); // Set up the GUI for the program addWindowListener(new CloseHandler(this)); mb = new MenuBar(); fileMenu = new Menu("File"); openItem = new MenuItem("Load Settings"); openItem.addActionListener(this); fileMenu.add(openItem); saveItem = new MenuItem("Save Settings"); saveItem.addActionListener(this); fileMenu.add(saveItem); exitItem = new MenuItem("Exit"); exitItem.addActionListener(this); fileMenu.add(exitItem); mb.add(fileMenu); settingsMenu = new Menu("Settings"); serialItem = new MenuItem("Serial Port Settings"); serialItem.addActionListener(this); settingsMenu.add(serialItem); mb.add(settingsMenu); aboutMenu = new Menu("Info"); aboutItem = new MenuItem("About"); aboutItem.addActionListener(this); aboutMenu.add(aboutItem); mb.add(aboutMenu); setMenuBar(mb); messagePanel = new Panel(); messagePanel.setLayout(new GridLayout(2, 1)); OutTextArea = new TextArea(); OutTextArea.setEditable(false); OutTextArea.setFont(new Font("Monospaced",0,12)); messagePanel.add(OutTextArea); InTextArea = new TextArea(); InTextArea.setEditable(false); InTextArea.setFont(new Font("Monospaced",0,12)); messagePanel.add(InTextArea); add(messagePanel, "Center"); // Create a new KeyHandler to respond to key strokes in the // messageAreaOut. Add the KeyHandler as a keyListener to the // messageAreaOut. keyHandler = new KeyHandler(); OutTextArea.addKeyListener(keyHandler); buttonPanel = new Panel(); openButton = new Button("Open Port"); openButton.addActionListener(this); buttonPanel.add(openButton); closeButton = new Button("Stop"); closeButton.addActionListener(this); closeButton.setEnabled(false); buttonPanel.add(closeButton); Panel southPanel = new Panel(); GridBagLayout gridBag = new GridBagLayout(); GridBagConstraints cons = new GridBagConstraints(); cons.gridwidth = GridBagConstraints.REMAINDER; gridBag.setConstraints(buttonPanel, cons); cons.weightx = 1.0; gridBag.setConstraints(buttonPanel, cons); southPanel.add(buttonPanel); add(southPanel, "South"); parseArgs(args); SerialSettings = new SerialPanel(this); SerialSettings.setParameters(); info = new InfoDialog(); term = new SmsTerminal (this, SerialSettings.parameters, OutTextArea, InTextArea); Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); setLocation(screenSize.width/2 - WIDTH/2, screenSize.height/2 - HEIGHT/2); setSize(WIDTH, HEIGHT); setResizable(false); phoneno= new List(5,true); add(phoneno); phoneno.addActionListener(this); [b]//DB connection[/b] try { Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/smsgateway", "user", "user"); st = conn.createStatement(); rs=st.executeQuery("select * from sample"); while(rs.next()) { name=rs.getString("name"); System.out.println("Name:"+name); address=rs.getString("address"); System.out.println("Address:"+address); mobileno=rs.getString("phoneno"); System.out.println("MobileNo:"+mobileno); phoneno.add(mobileno); } } catch(Exception e) { e.printStackTrace(); } }


I have tried this above code and am getting values from database successfully at the same time but i can't able to type
at commands.That is not a exe.Am trying readymade interface.Please assist me to solve this issue.



Regards,
Suganya.

Hi,

Am not getting any error message.But i can't send the message to mobile(can't open serial connection) when am using the DB code.Actually
i tried to send the message to phone number through GSM modem without DB code.I can able to type at commands(GSM modem commands)
and send the messages successfully.But am also tried to send the message to phone number through GSM modem with DB code i can't able to
type at commands(GSM modem commands) but i get the values from DB.Already attached my code to you.I am trying the same code.
Then i tried to attach my output screen but am getting error message.

Files with the extension .doc are not allowed as attachment in the message.

How to attach my output screen.Please guide me to solve this issue.



Regards,
Suganya.

Hi,

Yes.Solved all DB connection problems.I can able to get the values from DB through applet java.
That is not issue.Now i need to send the message through GSM modem successfully without DB connection.
I tried to send the message through GSM modem with DB connection code and i get the values from DB
successfully but i can't able to open serial port connection the same code.How to solve this problem.
Please assist me to solve this problem.





Regards,
Suganya.

Hi,
Thanks.Actually am trying to send sms through GSM modem using the above applet java code.I have
send message to a single person successfully through this above code.Now i need to send more number
of person at a time so i am using database.So i get the values from database successfully.At the same
time i can't able to open the serial port.This is my problem.Am implementing the code for get the
database value.I need to get the values(Phonenumber) from database and also send the message to
corresponding number through this above code(Gsm modem).This is my need.Please assist me to solve this
problem.



Regards,
Suganya.

Hi,
Thanks.I need to get the values from database.I will explain you in detail.I tried to send sms through
GSM modem.I will send message using at commands through GSM modem to single number one by one successfully.
But if i need to send a message to more numbers at a time.so i tried to get numbers from database and i will click send button
the message will be send to the corresponding number.Now am trying code for getting the values from database and get the
values successfully but i am unable to open a serial port at the same time.How to solve this problem.

The following code is
public class Sms_GUI extends Frame implements ActionListener { final int HEIGHT = 450; final int WIDTH = 410; private MenuBar mb; private Menu fileMenu; private Menu settingsMenu; private Menu aboutMenu; private MenuItem openItem; private MenuItem saveItem; private MenuItem exitItem; private MenuItem serialItem; private MenuItem aboutItem; public Button openButton; public Button closeButton; private Panel buttonPanel; public static List phoneno; String msg=""; public Button send; private Panel messagePanel; private String at_command = ""; public TextArea OutTextArea; public TextArea InTextArea; private KeyHandler keyHandler; private SerialPanel SerialSettings; private InfoDialog info; private SmsTerminal term; private Properties props = null; String address; String name; Statement st; ResultSet rs=null; Connection conn = null; String mobileno; /** Main method. Checks to see if the command line agrument is requesting usage informaition (-h, -help), if it is, display a usage message and exit, otherwise create a new <code>SerialDemo</code> and set it visible. */ public static void main(String[] args) { if ((args.length > 0) && (args[0].equals("-h") || args[0].equals("-help"))) { System.out.println("usage: java AccessSystemGUI [configuration File]"); System.exit(1); } Sms_GUI GUI = new Sms_GUI(args); GUI.setVisible(true); GUI.repaint(); } public Sms_GUI(String[] args) { super("Serial SMS Client"); // Set up the GUI for the program addWindowListener(new CloseHandler(this)); mb = new MenuBar(); fileMenu = new Menu("File"); openItem = new MenuItem("Load Settings"); openItem.addActionListener(this); fileMenu.add(openItem); saveItem = new MenuItem("Save Settings"); saveItem.addActionListener(this); fileMenu.add(saveItem); exitItem = new MenuItem("Exit"); exitItem.addActionListener(this); fileMenu.add(exitItem); mb.add(fileMenu); settingsMenu = new Menu("Settings"); serialItem = new MenuItem("Serial Port Settings"); serialItem.addActionListener(this); settingsMenu.add(serialItem); mb.add(settingsMenu); aboutMenu = new Menu("Info"); aboutItem = new MenuItem("About"); aboutItem.addActionListener(this); aboutMenu.add(aboutItem); mb.add(aboutMenu); setMenuBar(mb); messagePanel = new Panel(); messagePanel.setLayout(new GridLayout(2, 1)); OutTextArea = new TextArea(); OutTextArea.setEditable(false); OutTextArea.setFont(new Font("Monospaced",0,12)); messagePanel.add(OutTextArea); InTextArea = new TextArea(); InTextArea.setEditable(false); InTextArea.setFont(new Font("Monospaced",0,12)); messagePanel.add(InTextArea); add(messagePanel, "Center"); // Create a new KeyHandler to respond to key strokes in the // messageAreaOut. Add the KeyHandler as a keyListener to the // messageAreaOut. keyHandler = new KeyHandler(); OutTextArea.addKeyListener(keyHandler); buttonPanel = new Panel(); openButton = new Button("Open Port"); openButton.addActionListener(this); buttonPanel.add(openButton); closeButton = new Button("Stop"); closeButton.addActionListener(this); closeButton.setEnabled(false); buttonPanel.add(closeButton); Panel southPanel = new Panel(); GridBagLayout gridBag = new GridBagLayout(); GridBagConstraints cons = new GridBagConstraints(); cons.gridwidth = GridBagConstraints.REMAINDER; gridBag.setConstraints(buttonPanel, cons); cons.weightx = 1.0; gridBag.setConstraints(buttonPanel, cons); southPanel.add(buttonPanel); add(southPanel, "South"); parseArgs(args); SerialSettings = new SerialPanel(this); SerialSettings.setParameters(); info = new InfoDialog(); term = new SmsTerminal (this, SerialSettings.parameters, OutTextArea, InTextArea); Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize(); setLocation(screenSize.width/2 - WIDTH/2, screenSize.height/2 - HEIGHT/2); setSize(WIDTH, HEIGHT); setResizable(false); phoneno= new List(5,true); add(phoneno); phoneno.addActionListener(this); System.out.println("Peopletech"); try { System.out.println("Welcome To All"); Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/smsgateway", "user", "user"); st = conn.createStatement(); rs=st.executeQuery("select * from sample"); while(rs.next()) { name=rs.getString("name"); System.out.println("Name:"+name); address=rs.getString("address"); System.out.println("Address:"+address); mobileno=rs.getString("phoneno"); System.out.println("MobileNo:"+mobileno); phoneno.add(mobileno); } } catch(Exception e) { e.printStackTrace(); } } /** Responds to the menu items and buttons. */ public void actionPerformed(ActionEvent e) { String cmd = e.getActionCommand(); // Loads a configuration file. if (cmd.equals("Load Settings")) { FileDialog fd = new FileDialog(this, "Load Serial Port Configuration", FileDialog.LOAD); fd.setVisible(true); String file = fd.getFile(); if (file != null) { String dir = fd.getDirectory(); File f = new File(dir + file); try { FileInputStream fis = new FileInputStream(f); props = new Properties(); props.load(fis); fis.close(); } catch (FileNotFoundException e1) { System.err.println(e1); } catch (IOException e2) { System.err.println(e2); } loadParams(); } } // Saves a configuration file. if (cmd.equals("Save Settings")) { SerialSettings.setParameters(); FileDialog fd = new FileDialog(this, "Save Serial Port Configuration", FileDialog.SAVE); fd.setFile("SerialPort.settings"); fd.setVisible(true); String fileName = fd.getFile(); String directory = fd.getDirectory(); if ((fileName != null) && (directory != null)) { writeFile(directory + fileName); } } // Exits the program. if (cmd.equals("Exit")) { this.setVisible(false); try { term.close(); } catch (NullPointerException ex) { } } // Calls serial settings window if (cmd.equals("Serial Port Settings")) { SerialSettings.setVisible(true); SerialSettings.repaint(); } // Calls serial settings window if (cmd.equals("About")) { info.setVisible(true); info.repaint(); } // Opens a port. if (cmd.equals("Open Port")) { System.out.println("Open serial connection"); openButton.setEnabled(false); SerialSettings.setParameters(); try { term.openConnection(); closeButton.setEnabled(true); OutTextArea.setEditable(true); } catch (IOException e2) { AlertDialog ad = new AlertDialog(this, "Error Opening Port!", "Error opening port,", e2.getMessage() + ".", "Select new settings, try again."); openButton.setEnabled(true); return; } } // Closes a port. if (cmd.equals("Stop")) { try { term.close(); } catch (NullPointerException ex) { } openButton.setEnabled(true); closeButton.setEnabled(false); OutTextArea.setEditable(false); } } /** Writes the current parameters to a configuration file of the java.properties style. */ private void writeFile(String path) { Properties newProps; FileOutputStream fileOut = null; newProps = new Properties(); newProps.put("portName", (SerialSettings.parameters).getPortName()); newProps.put("baudRate", (SerialSettings.parameters).getBaudRateString()); newProps.put("flowControlIn", (SerialSettings.parameters).getFlowControlInString()); newProps.put("flowControlOut", (SerialSettings.parameters).getFlowControlOutString()); newProps.put("parity", (SerialSettings.parameters).getParityString()); newProps.put("databits", (SerialSettings.parameters).getDatabitsString()); newProps.put("stopbits", (SerialSettings.parameters).getStopbitsString()); try { fileOut = new FileOutputStream(path); } catch (IOException e) { System.out.println("Could not open file for writiing"); } try { newProps.store(fileOut, "Serial Port settings"); } catch (IOException e) { System.out.println("Could not write file"); } try { fileOut.close(); } catch (IOException e) { System.out.println("Could not close file for writiing"); } } /** Finds configuration file in arguments and creates a properties object from that file. */ private void parseArgs(String[] args) { if (args.length < 1) { return; } File f = new File(args[0]); if (!f.exists()) { f = new File(System.getProperty("user.dir") + System.getProperty("path.separator") + args[0]); } if (f.exists()) { try { FileInputStream fis = new FileInputStream(f); props = new Properties(); props.load(fis); fis.close(); loadParams(); } catch (IOException e) { } } } /** Set the parameters object to the settings in the properties object. */ private void loadParams() { (SerialSettings.parameters).setPortName(props.getProperty("portName")); (SerialSettings.parameters).setBaudRate(props.getProperty("baudRate")); (SerialSettings.parameters).setFlowControlIn(props.getProperty("flowControlIn")); (SerialSettings.parameters).setFlowControlOut(props.getProperty("flowControlOut")); (SerialSettings.parameters).setParity(props.getProperty("parity")); (SerialSettings.parameters).setDatabits(props.getProperty("databits")); (SerialSettings.parameters).setStopbits(props.getProperty("stopbits")); SerialSettings.setSerialPanel(); } // Handles closing down system. Allows application to be closed with window close box. class CloseHandler extends WindowAdapter { Frame sp; public CloseHandler(Frame sp) { this.sp = sp; } public void windowClosing(WindowEvent e) { sp.setVisible(false); try { term.close(); } catch (NullPointerException ex) { } System.out.println("Program End"); System.exit(0); } } private int detectComma(String text) { int i; for (i=0; i < text.length()-1; i++ ) { if (text.charAt(i)==',') break; } return i; } // parsing SMS commands public void parse_command(String at_command) { String temp; int comma; if ((at_command.toUpperCase()).startsWith("READSMS ")) { int index= Integer.parseInt(at_command.substring(8, 9), 10); term.ReadSMS(index); } if ((at_command.toUpperCase()).startsWith("DELETESMS ")) { int index= Integer.parseInt(at_command.substring(10, 11), 10); term.DeleteSMS(index); } else if ((at_command.toUpperCase()).startsWith("SENDSMS ")) { temp = at_command.substring(8, at_command.length()); comma = detectComma(temp); if (comma!=0) { if (temp.charAt(comma+1)==' ') temp=temp.substring(0,comma+1)+temp.substring(comma+2,temp.length()); term.SendMessage(temp.substring(0, comma), "", temp.substring(comma + 1, temp.length())); } } else if ((at_command.toUpperCase()).startsWith("WRITERXSMS ")) { temp = at_command.substring(11, at_command.length()); comma = detectComma(temp); if (comma!=0) { if (temp.charAt(comma+1)==' ') temp=temp.substring(0,comma+1)+temp.substring(comma+2,temp.length()); term.WriteRxMessage(temp.substring(0, comma), "", temp.substring(comma + 1, temp.length())); } } else if ((at_command.toUpperCase()).startsWith("WRITETXSMS ")) { temp = at_command.substring(11, at_command.length()); comma = detectComma(temp); if (comma!=0) { if (temp.charAt(comma+1)==' ' ) temp=temp.substring(0,comma+1)+temp.substring(comma+2,temp.length()); term.WriteTxMessage(temp.substring(0, comma), "", temp.substring(comma + 1, temp.length())); } } else // Ordinary AT-Commands { term.atCmd(at_command, 0, 500); } } // For typing AT Command in Input window class KeyHandler extends KeyAdapter { public KeyHandler() { } public void keyTyped(KeyEvent evt) { if ((int) evt.getKeyChar() == 10) { parse_command(at_command); at_command = ""; } else { at_command=at_command + evt.getKeyChar(); } } } }


please assist me to solve this problem.


Regards,
suganya.

Hi ujjwal soni,

Thanks for your reply.I worked this sample code and i got this output.Now i need to get the values from mysql database through combo box in applet java code.
Please guide me to get this output.

Regards,
Suganya.

Hi,

Thanks for your response.I got this output.Now i need to get the values from mysql database through combo box in applet java.Please guide me to get this output.




Regards,
Suganya

Hi,
I tried one small application in java applet.Now i need to connect database.Is it possible.
How can i integrate java applet and mysql database.Please give me sample code.



Regards,
Suganya.

Hi Ulf Dittmer,
Thanks for your reply.Please give me any sample code.That is very helpful to solve this problem.



Regards,
Suganya.

Hi,
I am using more database connection in my jsp coding so the cpu percentage will be automatically
increased(100%) and my server also very slow response.I need one global database connection in jsp
page and get the connection in my code.How can i solve this problem?Please assist me to solve this problem.



Regards,
Suganya

Hi,

Thanks for your response.I need to send SMS through SMS Gateway.How can i integrate Servlet with SMS Gateway.Actually i need send Modem AT commands through servlet.Please give any idea to continous this process.




Regards,
Suganya.

Hi,

I want send sms to any gsm mobile through java servlet, can any tell me about this ?I have planned send to SMS through GSM modem.How can i integrate Servlet with GSM modem.Please
give me sample code it is very helpful to continue this process.



Regards,
Suganya

Hi,

I need to check the difference between the time in database and system time.I am having both the times in yy:mm:dd hh:mm:ss format.please reply me how to do this .very urgent.I am getting both the time in string like

String calledtime=rs.getString("calledtime");
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss") ;
String currenttime = formatter.format (new Date()) ;




I am getting the output printed as
2008-05-02 16:52:17
2008-05-20 15:10:44


I need this output like this 00:00:00

00:00:01
00:00:02
00:00:03
00:00:04
00:00:05


Thanks.

Hi,

Thanks for your response. I need to check the difference between the time in database and system time.I am having both the times in yy:mm:dd hh:mm:ss format.please reply me how to do this .very urgent.I am getting both the time in string like

String calledtime=rs.getString("calledtime");
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss") ;
String currenttime = formatter.format (new Date()) ;




I am getting the output printed as
2008-05-02 16:52:17
2008-05-20 15:10:44


I need this output like this 00:00:00

00:00:01
00:00:02
00:00:03
00:00:04
00:00:05


Thanks.

Hi,

I need to check the difference between the time in database and system time.I am having both the times in yy:mm:dd hh:mm:ss format.please reply me how to do this .very urgent.I am getting both the time in string like



String calledtime=rs.getString("calledtime");
SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd HH:mm:ss") ;
String currenttime = formatter.format (new Date()) ;




I am getting the output printed as
2008-05-02 16:52:17
2008-05-20 15:10:44

How can i check particularly the seconds now?

Thanks.