Java variables within SQL statements to be sent
[240 byte] By [Bakumba84a] at [2007-10-2 17:44:59] 
Hi,Simple basic question really. Is it possible to send SQL statements through a JDBC setup which contain Java variables (say for the purpose of capturing text from a GUI component and loading it onto a database)?Thanks
Yes. I call this one the appropriate use of PreparedStatements. Bind the parameters based on user input at runtime.
Bakumba84a at 2007-7-13 19:02:44 >
Database Connectivity New Topic
Database Connectivity Hot Topic
- After ResultSet.close()
- multiple commits
- Urgent - Problem with ResultSet's next function
- Updatable ResultSet vs. Multiple Selects/Updates
- got problem of connecting to mysql database using JDBC
- ClassCasException when trying to update an oracle clob through Tomcat
- Real meaning of PooledConnection, ConnectionPoolDataSource etc.
- Strange problem retreiving string from database
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding