Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
preparedstatement
- Page 1
Re: coversion of dates from java(jsp) to sql
Programming
Web Development
15 Years Ago
by jwenting
PreparedStatement
works the same way for whatever SQL statement you employ it. And if you're just getting started, best to get started doing things the right way instead of the wrong way which you are doing. Java code in JSP went out of vogue nearly a decade ago, use JSTL instead and put all the Java code in Servlets and their associated classes.
Re: time stamp
Programming
Software Development
14 Years Ago
by masijade
PreparedStatement
and setDate and setTimestamp [url]http://java.sun.com/docs/books/tutorial/jdbc/index.html[/url]
PreparedStatement()
Programming
Software Development
13 Years Ago
by ceyesuma
…; i < schoolofdbTables.length; i++) { boolean bCreatedTables = false;
PreparedStatement
ps = null; try { ps = (
PreparedStatement
) conn.prepareStatement( ModelUtils.getResource(schoolofdbTables[i])); ps.executeQuery…
PreparedStatement help
Programming
Software Development
13 Years Ago
by mcosta
…m trying to Select data from a database using a
PreparedStatement
and it isn't working for me. No errors…= null; try { String sqlQuery = "select * from audiotracks ";
PreparedStatement
ps = con.prepareStatement(sqlQuery); srs = ps.executeQuery(); System.out.println…
Re: PreparedStatement help
Programming
Software Development
13 Years Ago
by mcosta
I removed the call to close the
PreparedStatement
but still fail to get any data from the database. …
PreparedStatement - parameters from user combined with constants
Programming
Software Development
13 Years Ago
by liran
…web user - so I want it to be in a
PreparedStatement
. But x,y,... (Suppose there are many variables like…combine the two ways, something like:
PreparedStatement
preparedStatement
= ...
preparedStatement
.setString(1,userValue)
preparedStatement
.setString(2,passwordValue) execute(query,
preparedStatement
,new Object[]('valuex','valuey'...)) ? If…
Re: PreparedStatement - parameters from user combined with constants
Programming
Software Development
13 Years Ago
by liran
… user = ? AND password = ? AND x=? AND y=? ..."
PreparedStatement
preparedStatement
= ...
preparedStatement
.setString(1,userValue)
preparedStatement
.setString(2,passwordValue) execute(query,
preparedStatement
,new Object[]('valuex','valuey'...)) ?
Re: PreparedStatement - parameters from user combined with constants
Programming
Software Development
13 Years Ago
by liran
So it's pretty much like new Object[]{...} ? There is no significant performance different if I put many variables in the
PreparedStatement
?
PreparedStatement problem
Programming
Web Development
12 Years Ago
by rushhour2
… { private DBCon dbc; private Connection con; private Statement stmt; private
PreparedStatement
ps = null; public DataManager() { dbc = new DBCon(); con = dbc.getConnection…
PreparedStatement to insert user input to MySQL.
Programming
Web Development
10 Years Ago
by SoulofchaOs
… stmt = conn.createStatement(); String getsize = request.getParameter("Size");
PreparedStatement
pstmt; pstmt = conn.prepareStatement("INSERT INTO test_db (size) VALUES…
Re: PreparedStatement and subquery
Programming
Databases
13 Years Ago
by Ignatius88
How do I execute multiple queries in
PreparedStatement
? [CODE] pstmt = conn.prepareStatement("INSERT IGNORE INTO user (user_id) …
Re: PreparedStatement setString(), no char?
Programming
Software Development
11 Years Ago
by crownedzero
Sorry; in a
PreparedStatement
pstmt.setChar() or setString(). I was hoping to be able to pass either an int OR and wildcard _ or %.; I ended up using an overloaded method and determined the required method prior to calling it.
Re: PreparedStatement setString(), no char?
Programming
Software Development
11 Years Ago
by Taywin
… I see. If you want to add that functionality which
PreparedStatement
doesn't have, you could extend the class and add…
initalize a var for a preparedStatement
Programming
Software Development
13 Years Ago
by ceyesuma
… DerbyDAOFactory(); conn = ddf.getConnection(); if (conn != null) { ps = null; ps = (
PreparedStatement
) conn.prepareStatement( ModelUtils.getXMLResource("SelectStudent")); } System.out.println…
Re: initalize a var for a preparedStatement
Programming
Software Development
13 Years Ago
by ~s.o.s~
Use one of the setXXX methods of the
PreparedStatement
to set the value of your place holder.[code] ps = (
PreparedStatement
) conn.prepareStatement( ModelUtils.getXMLResource("SelectUserGroup")); ps.setString(1, user.getUserId()); ResultSet rs = ps.executeQuery();[/code]
Re: initalize a var for a preparedStatement
Programming
Software Development
13 Years Ago
by ceyesuma
…a clue yet. [code] if (conn != null) {
PreparedStatement
ps = null; conn = (Connection) ddf.getConnection(); String …null; studentUser.setStuUid(loginInfo.getUser()); ps = (
PreparedStatement
) conn.prepareStatement( ModelUtils.getXMLResource("SelectStudent")); } [/…
Cannot Update Database using PreparedStatement
Programming
Software Development
11 Years Ago
by taher_sk2000
…con=DriverManager.getConnection("JDBC:ODBC:HotelT");
PreparedStatement
st=null; if(room.getSelectedItem()=="Classic …quot; "; // exe=st.executeUpdate(b);
PreparedStatement
pst=con.prepareStatement("insert into Check_In values …
Re: initalize a var for a preparedStatement
Programming
Software Development
13 Years Ago
by ceyesuma
I didn't see your example. I'm still getting nullpointer so I'm still working with it 1. ps = (
PreparedStatement
) conn.prepareStatement( 2. ModelUtils.getXMLResource("SelectUserGroup")); 3. ps.setString(1, user.getUserId()); 4. ResultSet rs = ps.executeQuery();
Re: initalize a var for a preparedStatement
Programming
Software Development
13 Years Ago
by ceyesuma
… ConnectStudentDAO"); DerbyDAOFactory ddf = new DerbyDAOFactory(); conn = ddf.getConnection(); ps = (
PreparedStatement
) conn.prepareStatement( ModelUtils.getXMLResource("SelectUserGroup")); ps.setString(1…
Garbage collection and ResultSet, PreparedStatement, Connection
Programming
Software Development
14 Years Ago
by Xessa
Hello. I have a
PreparedStatement
/CallableStatement, a ResultSet and a Connection... Now after execution finishes, …
Why Use a Statement Instead of PreparedStatement
Programming
Software Development
13 Years Ago
by DoubleShot
I have read all sorts of positive reasons for using the
PreparedStatement
type in Java when working with SQL. Does anyone know of any reason why you'd ever choose the Statement type instead?
Re: Why Use a Statement Instead of PreparedStatement
Programming
Software Development
13 Years Ago
by DoubleShot
[QUOTE=masijade;1398320]When you have a query with no parameters that is not meant to be run multiple times in a row.[/QUOTE] But why not use the
PreparedStatement
anyway? It is supposed to be more efficient. Is there any use for a Statement type at all?
MySQL User-Defined Variables in PreparedStatement
Programming
Software Development
12 Years Ago
by velr
… two "statements" ending with ";"in one
PreparedStatement
. When i run the sql in phpMyAdmin it works but…
JSP database connectivity according to Model View Controller (MVC) Model 2
Programming
Web Development
15 Years Ago
by peter_budo
… UserBean(); Connection conn = getConnection(); if (conn != null) { ResultSet rs = null;
PreparedStatement
preparedStatement
= null; try { String strQuery = "SELECT u.uid, firstName, lastName…
Java and Web Services
Programming
Software Development
15 Years Ago
by peter_budo
…!= null) { ResultSet rs = null;
PreparedStatement
preparedStatement
= null; try { String strQuery = … null) { ResultSet rs = null;
PreparedStatement
preparedStatement
= null; Employee emp; try { String…
Using DAO structure No connection
Programming
Software Development
13 Years Ago
by ceyesuma
…private boolean bCreatedTables; /* private
PreparedStatement
stmtSaveNewRecord; private
PreparedStatement
stmtUpdateExistingRecord; private
PreparedStatement
stmtGetListEntries; private
PreparedStatement
stmtGetAddress; private
PreparedStatement
stmtDeleteAddress; * */ private DataSource dataSource…
Java problem
Programming
Software Development
7 Years Ago
by Alex_47
…;INSERT INTO students(pib, Speciality, date_of, adress, phone) VALUES(?,?,?,?,?)";
PreparedStatement
preparedStatement
; Connection connection; @Override public void actionPerformed(ActionEvent e) { try…
Re: derby embedded db stmt.execute sql error
Programming
Software Development
13 Years Ago
by ceyesuma
… ModelUtils.getXMLResource(schoolofdbTables[i])); ps = (
PreparedStatement
) conn.prepareStatement(ModelUtils.getXMLResource(schoolofdbTables[i].trim()));… System.out.println("table
preparedStatement
: " + ps); ps.execute(); bCreatedTables…
how to view 100 pages(previous, next)
Programming
Web Development
13 Years Ago
by baktha.thalapat
… view the pages 100 [code] <%
PreparedStatement
preparedStatement
= null;
PreparedStatement
preparedStatements = null; ResultSet rs4 = null,… = null; ResultSet rsRowCnt = null;
PreparedStatement
psPagination = null;
PreparedStatement
psRowCnt = null; int iShowRows =1000…
MySQL error java.sql.SQLException: Parameter index out of range (0 < 1 ).
Programming
Software Development
14 Years Ago
by dev18
…:926) at com.mysql.jdbc.
PreparedStatement
.checkBounds(
PreparedStatement
.java:3321) at com.mysql.jdbc.
PreparedStatement
.setInternal(
PreparedStatement
.java:3310) at com.mysql….jdbc.
PreparedStatement
.setString(
PreparedStatement
.java:4146) at org.Program…
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC