i have a page where username is displayed...i want to uodate my table based on the page value i. e username..how can this be done
String sql;
sql = "UPDATE test SET username=? WHERE password=?";
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, "jumbomail@com");
statement.setString(2, "password");
So, first i search the id from table and all the fields are filled as in the screenshot. then i modify in the text boxes and click on button modify but exception comes-too few parameters. expected 6.
here is the code:
try
{
JOptionPane.showMessageDialog(null,"Record succefully modified!
ID is "+id.getText()+" Password is "+lname.getText());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:Employe eDB");
String str0=id.getText();
[Code] ....
How to embed jsp into html page?
View Replies View Relatedi am trying to move from html to jsp in html it is simple code and in jsp there is database connection . but from html it is not going on the page of jsp. i put correct address in the form action attribute in html file.i am attaching both my files... following is my html code :-
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h3>ok its running fine</h3>
<form action="/ADMIN/add_material.jsp" method="post">
<div>
[code]....
i have this code
////////////////////////////////////////////
<form name="myform" action="http://localhost:8080/EASYPAY.COM/faces/newxhtml.xhtml"method="post">
amount
<input type="text" name="amount"value="">
<input type="submit" >
</form>
[code]...
when i submit the html form the value of amount does not appear in the second jsf page new.xhtml what might be the problem
I am creating a JSP page with a html table to display employee directory. This is scriptlet :
<%
List<Employee> list = new ArrayList<Employee>();
PhoneListController controller = new PhoneListController();
list = controller.getAllContacts();
for (Employee eachEmp : list) {
%>
and then i display the table rows and columns for each employee object(PS: I know scriptlets are bad and obsolete but this is my first individual project.)
I would like to change the background color of certain rows based on value of one particular value(based on eachEmp.getManagerCode).
How can i achieve that by using javascript? I tried to call a js function by calling onload event on . But as I need to check for each row that is not the possible solution. I have not tried jquery yet as I am very new to jquery and I didnt quite understand how to do it in jquery.
I have designed a login page for my project....which has username and password box....I have created a Table in Teradata which has username and password information....now i need to connect this html login page to Teradata database to validate the username and password.
View Replies View Relatedi have one html page ,inside html radio button and 3 textboxes and one submit button ->action->SampleServlet.java-> from here again come back to html page with checked radio buttton value and text box value. I dont want to click back button in this case, html page to servlet->here i have to call back to my html page with checked radio button and text box value .
I tried response.redirect(original.html)-->i cant able to display checked radio button and textbox value also tried requestdispatcher forward/include,html page comes newly from starting but i dont want it,i want to view in html page with checked radio button and text box value.
Problem code:
JSP 1:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*;" %>
<%!Connection con;%>
<%!Statement stmt = null;%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[URL]...">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
[Code]...
I get this error when I load a HTML page with WebEngine. The HTML is getting generated by an own (Java-)ServerSocket. How can I figure out where the problem is? I can load the HTML file successfully when loading the(same) generated HTML file from the local filesystem. Maybe the http headers causing these problems ? On the other hand I can load the page without problems in Firefox. How to get more information ?
View Replies View RelatedI am making a shopping cart app in JSP and servlets to bring it all together. Finally.
I have a registration servlet (c1), a registration form jsp (c2), a login jsp (c3). c1 checks if a username is in the database or not.
If the username is not there, then register the user and send them to c3. I want c3 to display a "registration successful" message if a user has just registered successfully and is coming from c1. ELSE, take the user back to c2 with a message which tells them to choose a different username or password etc.
How do I implement the logic of showing a message depending on where a user is coming from ? The servlets and jsps are ready and I only need to add this logic for a custom message. Of course, I could make a JSP for Registration Successful and one for Registration Failure. But, that seems to be unnecessary.
calling a parameterized stored procedure in java jdbc from sql server.The stored procedure goes like this in sql
create proc patientreg
@id int
as
begin
select [patient_id],[Psurname], [pFirstname], [pMiddlename], [reg_date], [DOB], [Sex], [Phone_num], [Addr],[Email],[dbo].[fncomputeage](DOB) from [dbo].[Patient_registration] where [patient_id] = @id
end
please note dbo.fncompute(DOB) is a function
To call it in jdbc it goes like this
try{
String str = "{call patientreg(?)}";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbcdbc:GeneralHospit al");
cstmt = con.prepareCall(str);
cstmt.setInt(1, Integer.parseInt(t.getText()));
[code]....
after doing it this way it throwing an exception: Error:java.sql.SQLException: Parameter 1 is not an OUTPUT parameter.
I am trying to create an array list without using the built in arrayList class that java has. I need to start the array being empty with a length of 5. I then add objects to the array. I want to check if the array is full and if not add a value to the next empty space. Once the array is full I then need to create a second array that starts empty and with the length of the first array + 1.
The contents of the first array are then copied into the new array without using the built in copy classes java has and then the new array ends up containing 5 elements and one null space the first time round. The first array is then overwritten with the new array containing the 5 elements and the null space. The process then starts again adding values until the array is full which will be 1 more value then recreating the second array empty and the length of the first array + 1. This is my attempt at creating this but I have run into multiple problems where I get only the last value I added and the rest of the values are null:
public class MyArrayList {
public Object arrayList[];
public MyArrayList(Object[] arrayList) {
this.arrayList = arrayList;
[code]...
I have a strange behaviour when trying to update a bean. Here is the edit page:
<h3>Edit Post</h3>
<div class="row">
<h:form>
<div class="small-3 columns">
<label for="right-label" class="right inline">Title</label>
[Code] ....
Here is the bean class:
package com.airial.controllers;
import com.airial.domain.Post;
import com.airial.service.PostService;
import com.ocpsoft.pretty.faces.annotation.URLMapping;
import com.ocpsoft.pretty.faces.annotation.URLMappings;
import org.springframework.beans.factory.annotation.Autowired;
[code]...
postToUpdatet is always NULL. Why the title property is not binded ? What is wrong here ?
I have to implement a system where I have to do almost same processing on a jsp page. The slight differences on the present page is based on whether the current page came from page 1 or page 2. So how can I do this?
View Replies View RelatedI have a xhtml file that initialization it with ui:repeat tag in realtime.all tags of this page placed under ui:fragment tag.
<edges>
<ui:repeat value="#{graphInfoBean.edges}" var="edge" varStatus="indexVar">
<edge id="#{indexVar.index}" source="#{edge.source}" target="#{edge.target}"
weight="#{edge.weight}">
[Code] ....
When i access to this page and save it as xml in realtime, the tags in xml file saved is empty while it is initialized and everything is working properly.
<edges>
</edges>
How can i access to content of this xhtml page and save it on disk?
I have two jsp page one is demo1.jsp and other is demo2.jsp on a click of a particular link on demo1.jsp I want to opwn demo2.jsp inside demo1.jsp without changing layout of demo1.jsp..I tried to use <jsp;include but that doesn't work for me.But how to do this simply on a single link click on a big page?
View Replies View Relatedpublic class StudentJDBCTemplate implements StudentDao
above class giving error as
The type StudentJDBCTemplate must implement the inherited abstract method
StudentDao.listStudents()
Interface is as below
import java.util.List;
import javax.sql.DataSource;
public interface StudentDao {
public void setDataSource(DataSource ds);
public void Create(String Name,Integer age);
public void getStudent(Integer id);
public List<Student>listStudents();
public void delete(Integer id);
public void update(Integer id,Integer age);
}
I'm trying to understand the relationship between JAAS and JDBC..In WebSphere, when setting up a Dynamic cluster I have to first define the JAAS..Then, the datasource..The JAAS has one account/password and the datasource another..I'm not getting the relationship between needing both JAAS and JDBC docs.oracle.com/cd/E19225-01/820-5594/ahteo/index.html
View Replies View RelatedI wish to retrieve just one value from db;
so I use this code:
@Transactional
public long getSequenceSedeB(Long id) {
BigDecimal seqValue = nu
String sql = "SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id";
SQLQuery query = getSession().createSQLQuery(sql);
[Code] ....
But it do not works; this is the log.
type.NullableType (NullableType.java:182) - could not read column value from result set: ID; Invalid column name
2014-11-25 14:45:14,476 WARN [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:77) - SQL Error: 17006, SQLState: null
2014-11-25 14:45:14,478 ERROR [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:78) - Invalid column name
But in the database the query
SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id
run correctly;
Also I need to rewrite the statement
query.setParameter("id", 923);
in this way
query.setParameter("id", AAA);
where AAA is gotten from out of the procedure;
I'm having problem with my code when it comes to Restore Database in Java. This is my code:
public boolean restoreDB(String dbUserName, String dbPassword, String source) {
String[] executeCmd = new String[]{"C:Program Files (x86)MySQLMySQL Server 5.1inmysqldump ", "--user=" + "root", "--password=" + "1234" + source};
Process runtimeProcess;
try {
runtimeProcess = Runtime.getRuntime().exec(executeCmd);
int processComplete = runtimeProcess.waitFor();
[Code] ....
To insert 500 records into oracle my code is taking more than 1 minute.
I am using the below:
1) dbcp connection pool
2) Jdbc, autocommit off
3) preparestatment
4) batchupdate
5) deployed in fuse servicemix
Important thing : Table doesnot have index.
How to improve the performance. Below is the code snippet..
// Added for Transaction
conn.setAutoCommit(false);
conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
PreparedStatement dataStmt= null;
dataStmt= conn.prepareStatement("insert statement");
for (Value value : valueList){
[Code] .....
I have a batch process which does Bulk UPDATE statement.
After implementing batch support using Spring JDBC 4.1.6 and Oracle Jdbc Driver (ojdbc7 and ucp), the number of records affected for individual update requests (in the batch) are always retrieved as -2 (Statement.SUCCESS_NO_INFO).
Is there any way to know the rows affected for individual cases, as I have to retry the same argument with an INSERT statement after this. Technically trying to develop this as an UPSERT implementation
I tried this batch update in Three Different Ways, and in all three methods the results are same -- (It just tells me Statement.SUCCESS_NO_INFO (-2) )
Method 1 -- Direct UCP Connection and PreparedStatement
connectionPoolMgr.startConnectionPool("mgr_pool");
Connection connection = pds.getConnection();
PreparedStatement pstmt = connection.prepareStatement(dmlSQL);
pstmt.setInt(1, pkId);
pstmt.setInt(2, idx * 10);
pstmt.addBatch();
[Code] .....
What I have in my tnsnames.ora and verify it all works via sqlplus
CDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cdb1)
[Code] ....
I am trying to get RJDBC to work so I can connect to Oracle from R doing some data analysis..
This connection string works for my local db which I have it running in my Virtual Box
con <- dbConnect(drv, "jdbc:oracle:thin:@//localhost:1521/orcl", "demo", "demo")
However, it does not work when I do it for the remote db that I really need to pull data from...
> con <- dbConnect(drv, "jdbc:oracle:thin:@//ymsdbppr-scan:1522/YMQCTPRD", "user_read", "user_read")
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1], :
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS: listener does not currently know of service requested in connect descriptor
I am using a static initialization block to register the driver and a static synchronized method to get a connection. The problem is I need to run 15 threads but always only two threads get the connection. I want to know if there is a default maximum number of concurrent connections a DriverManager can provide or is it my threading logic that may be faulty.
CODE:
static {
try {
Class jdbcDriverClass = Class.forName( JDBC_DRIVER );
driver = (Driver) jdbcDriverClass.newInstance();
DriverManager.registerDriver( driver );
[Code] ....
Trying to bind the value Double.POSITIVE_INFINITY in a prepared statement causes an IllegalArgumentException using ojdbc6 11.2.0.4.0 but it works fine in version 11.2.0.3.0:
Exception in thread "main" java.lang.IllegalArgumentException: Overflow
at oracle.jdbc.driver.OraclePreparedStatement.setDoubleInternal(OraclePreparedStatement.java:7605)
at oracle.jdbc.driver.OraclePreparedStatement.setDouble(OraclePreparedStatement.java:7513)
at
[Code]....
The database used is 'Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production'. I don't see any mention regarding changes to this in the 11.2.0.4.0 change log. Is this a bug in the driver or is there some other explanation?