Java Programming Forums - The Java Community - JDBC & Databases

i want to konw database connectivity with sql

Kamakshi — Sat, 25 May 2013 09:43:59 GMT

i am trying to connect my code with database but can't .
pls help me to overcome this problem

SImpeJDBCinsert leads to memory leak

justyStepi — Wed, 22 May 2013 09:04:36 GMT

Hello,

I'm having issues with my code, I'm using simpleJDBCinsert in order to create new entry to mt db. But when I run my code, it freezes.

Thank you for your help.

Code :

 @Override
    public void createMission(Mission c) {
        SimpleJdbcInsert createMiss = new SimpleJdbcInsert(dataSource).withTableName("mission").usingGeneratedKeyColumns("id");
        Map parameters = new HashMap<>(5);
 
        parameters.put("Mission_Name", c.getName());
        parameters.put("Mission_Started", c.getStart());
        parameters.put("Location", c.getLocation());
        parameters.put("Mission_End", c.getEnd());
 
        Number id = createMiss.executeAndReturnKey(parameters);
        c.setId(id.longValue());
    }

here is my simplejdbc query

Code :

   btnAddMission.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
 
                System.out.print("Enter name of the mission: ");
                Scanner scan = new Scanner(System.in);
                String name = scan.nextLine();
 
                System.out.print("Enter the Date of the mission: ");
                String date = scan.nextLine();
                Date start = null;
                try {
                    start = new SimpleDateFormat("yyyy/MM/dd" ).parse(date);
                } catch (ParseException e1) {
                    e1.printStackTrace();  //
  }
 
                System.out.print("Enter the location: ");
                String location = scan.nextLine();
 
                System.out.print("Enter the exparation time: ");
                String end = scan.nextLine();
               Date endD = null;
                try {
                    endD = new SimpleDateFormat("yyyy/ MM/dd").parse(end);
                } catch (ParseException e1) {
                    e1.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
                }
 
 
                //Long id, String name, String location,Date start,Date end
                MissionManagerImpl miss = new MissionManagerImpl();
                Mission mission = new Mission((long) 0, name, location, start, endD);
 
                miss.createMission(mission);
            }
        });

DetachedCriteria

basoul83 — Tue, 21 May 2013 19:43:15 GMT

from user u, company c where c.name = u.name

how can do the same thing using DetachedCriteria, I did it using HQL. but thats not what I wanted ?

thnx in advance

Updating MySQL with user entered values

Talksin — Thu, 16 May 2013 15:13:23 GMT

The first jsp page (send1.jsp) displays all data from the MySQL database, and consists of an edit button for each row.

Once the user clicks on the edit button for a particular row, the size variable of that row will be passed to the next jsp page (receive1.jsp)

receive1.jsp will accept the value and then use the value for the Update PreparedStatement.

When the user clicks 'update' in the 2nd jsp page, the size value which the user typed will be stored into a variable and used for the Update PreparedStatement as well.

However after doing so, the UPDATE doesn't have any effect on the MYSQL database; nothing happens.

Thanks for any help rendered.

send1.jsp

Code :

    <%@ page import ="java.sql.*" %> 
    
    		
    	
 
    <%
 
    PreparedStatement pstmt;
 
    pstmt = conn.prepareStatement("Select * from shoe_db");
 
    ResultSet rs = pstmt.executeQuery();
 
    while(rs.next()){
       out.println("");
       out.println("");
       out.println("");
       out.println("");
       out.println("");
       out.println("");
    }
    String getmov3 ="";
    // check if Edit button is clicked
    if(request.getParameter("editm") != null) {
    	getmov3 = request.getParameter("hidden");
      // DEBUG
    	System.out.println("getmov3 is "+getmov3);
    response.sendRedirect("receive1.jsp?getmov3="+getmov3);
    }
    //conn.close();
    %>
    
    	
    	Size
    	Taste
    	
" + rs.getString("size") + " " + rs.getString("taste") + "   < input type='submit' name='editm' value='Edit'>

receive1.jsp

Code :

	<%@ page import ="java.sql.*" %> 
 
	
	<%
	//Register JDBC driver
	Class.forName("com.mysql.jdbc.Driver");
	//Define Connection URL
	String connURL = "jdbc:mysql://localhost/dumbs?user=root&password=rootlah213";
	//Establish connection to URL
	Connection conn =   DriverManager.getConnection(connURL); 
	%>
 
	
		
		
		Enter Size to be changed to: 
		
		
		
		
		
		
 
 
	<%
	String sizeg = request.getParameter("getmov3");
	System.out.println("sizeg is "+sizeg);
 
	String getsize = "";
	// check if Update button is clicked
	if(request.getParameter("Updatebutton") != null) {
		// get what user enterd in Size text box
		getsize = request.getParameter("gs");
		// DEBUG
		System.out.println("getsize is "+getsize);
		PreparedStatement pstmt4;
 
		pstmt4 = conn.prepareStatement("UPDATE shoe_db SET size=? WHERE size=?");
		pstmt4.setString(1,getsize);
		pstmt4.setString(2,sizeg);
		pstmt4.executeUpdate();
	}
 
	%>

Re: Import Data from Excel to Mysql Database

piya — Thu, 09 May 2013 15:59:37 GMT

hello venu..
can u pls give me ur code for extracting data from mysql db and putting it into excel worksheet using swing.. i m in urgent need of it.. pls reply.. thnx

problem incrementing field in sql with java

nachos — Mon, 06 May 2013 14:42:13 GMT

interesting... seems my logic actually works when i set the wins field to 1 before using this. when i queried the db it said that wins == 0 though... is it returning 0 as a place holder when that value was actually undefined?

--- Update ---

you can close this... somehow my original question text got deleted but i figured it out

RFID Tracking using Java and Sql Databases

rahulraina7 — Thu, 02 May 2013 13:51:14 GMT

So I am building this RFID tracking system, which essentially consists of a RFID reader and tags. So I have programmed the Tags and connected the reader through RS-232 port of my computer.I open the hyper terminal or the console for the serial communication. Whenever the tag is detected the some ID shows up in the Hyper Terminal. That means everything is fine.

Now to achieve the same in java, i.e Serial Communication. I am using javax.comm API for serial communication which is achieved from this code.

Code :

import java.io.*;
import java.util.*;
 
import javax.comm.*;
 
public class SimpleRead implements Runnable, SerialPortEventListener {
static CommPortIdentifier portId;
static Enumeration portList;
 
InputStream inputStream;
SerialPort serialPort;
Thread readThread;
 
public static void main(String[] args) {
    portList = CommPortIdentifier.getPortIdentifiers();
 
    while (portList.hasMoreElements()) {
        portId = (CommPortIdentifier) portList.nextElement();
        if (portId.getPortType() == CommPortIdentifier.PORT_SERIAL) {
             if (portId.getName().equals("COM1")) {
        //                if (portId.getName().equals("/dev/term/a")) {
                SimpleRead reader = new SimpleRead();
            }
        }
    }
}
 
public SimpleRead() {
    try {
        serialPort = (SerialPort) portId.open("SimpleReadApp", 2000);
    } catch (PortInUseException e) {System.out.println(e);}
    try {
        inputStream = serialPort.getInputStream();
    } catch (IOException e) {System.out.println(e);}
try {
        serialPort.addEventListener(this);
} catch (TooManyListenersException e) {System.out.println(e);}
    serialPort.notifyOnDataAvailable(true);
    try {
        serialPort.setSerialPortParams(9600,
            SerialPort.DATABITS_8,
            SerialPort.STOPBITS_1,
            SerialPort.PARITY_NONE);
    } catch (UnsupportedCommOperationException e) {System.out.println(e);}
    readThread = new Thread(this);
    readThread.start();
}
 
public void run() {
    try {
        Thread.sleep(20000);
    } catch (InterruptedException e) {System.out.println(e);}
}
 
public void serialEvent(SerialPortEvent event) {
    switch(event.getEventType()) {
    case SerialPortEvent.BI:
    case SerialPortEvent.OE:
    case SerialPortEvent.FE:
    case SerialPortEvent.PE:
    case SerialPortEvent.CD:
    case SerialPortEvent.CTS:
    case SerialPortEvent.DSR:
    case SerialPortEvent.RI:
    case SerialPortEvent.OUTPUT_BUFFER_EMPTY:
        break;
    case SerialPortEvent.DATA_AVAILABLE:
        byte[] readBuffer = new byte[20];
 
        try {
            while (inputStream.available() > 0) {
                int numBytes = inputStream.read(readBuffer);
            }
            System.out.print(new String(readBuffer));
        } catch (IOException e) {System.out.println(e);}
        break;
    }
}}

So what i need to achieve is that whenever the tag is swapped with the reader, the tagid that is recieved by us from COM port, would go into a database along with its time stamp.

So I created this database by :

Quote:

create table track(
tagid number(8),
timet timestamp
);

So what should I do so that whenever a card is swiped this table gets entered by the tag id (received by COM port) and the time and date of the swipe (Timestamp of the swipe).

Any help would be appreciated.

error

game06 — Thu, 02 May 2013 04:48:24 GMT

i am using jdbc and getting a error:

SQLException: Incorrect integer value: 'score' for column 'Score' at row 1
SQLException: 1366

Code :

sqlState.executeUpdate("insert into Score values(id, userNameTemp, score)");

id, userNameTemp, score are variables.

Size	Taste
" + rs.getString("size") + "	" + rs.getString("taste") + "	< input type='submit' name='editm' value='Edit'>