hi Sandeep,
i am very new to this, so to be honest I dont understand,.
Let me put what i have done so far..
In my Class file
package PPickDomain;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class PickDomain {
String DDomain;
private String user;
private String pwd;
private String Domain;
//private Connection connection=null;
// private ResultSet rs = null;
// private Statement st = null;
Connection connection = null;
Statement st = null;
ResultSet rs = null;
ResultSet rs1 = null;
public PickDomain()
{
try {
DriverManager.registerDriver(
new oracle.jdbc.driver.OracleDriver());
String serverName = "localhost";
int port = 1521;
String user1 = "scott";
String password = "tiger";
String SID = "ORACLE";
String URL = "jdbc:oracle:thin:@" + serverName + ":" + port + ":" + SID;
connection = DriverManager.getConnection(URL, user1, password);
}
catch(Exception e)
{
System.out.println("Exception is ;"+e);
e.printStackTrace();
}
}
public void setDomain(String Domain)
{
this.Domain = Domain;
}
public String getDomian ()
{
return (this.Domain);
}
public String selectD()
{
try
{
Statement s = connection.createStatement();
rs=s.executeQuery("Select T_A_DOMAIN from BILL_DOMAIN");
//Not sure what to do next //
}
catch(Exception e)
{
System.out.println("Exception is ;"+e);
e.printStackTrace();
}
return DDomain;
}
}
in my JSP file..
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd" >
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<HTML>
<HEAD>
<TITLE>Adding ticket to Database Table </TITLE>
</HEAD>
<BODY bgcolor="#ffffcc">
<font size="+3" color="green"><br> Add the Ticket Details here</font>
<FORM action="addticket2.jsp" method="get">
<TABLE style="background-color: #ECE5B6;" WIDTH="30%" >
<TR>
<TH width="50%">Domain</TH>
<TD width="50%"><select name="Domain" size="1">
<option selected="selected">Select a Domain</option>
</select>
</FORM>
</body>
</html>
please help with this code.
thanks buddy...