Please Reply

View Answers

August 19, 2008 at 11:54 AM

Hi friend,

Code to solve your problem :

"vendmaster.jsp"

<html>
<head>

</head>
<body>

<form name="vendForm" method="post" action="vendmid.jsp">
<table>

<tr>
<td>Vend Id</td>
<td><input type="text" name="vend_id" value=""></td>
</tr>
<tr>
<td>Vend Name</td>
<td><input type="text" name="vend_name" value=""></td>
</tr>

<tr>
<td></td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>

</body>
</html>

August 19, 2008 at 11:55 AM

To insert vendmaster form "vendmid.jsp"

<%@ page language="java" import="java.sql.*;"%>
<%

// initialze the parameter form

String vend_id = "";
String vend_name = "";

// initialze the database connectivity
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "test";
String driver = "com.mysql.jdbc.Driver";
String username = "root";
String userPassword = "root";
String submit="";

if(request.getParameter("Submit")!=null)
{
vend_id = request.getParameter("vend_id");
vend_name = request.getParameter("vend_name");
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,username,userPassword);
Statement st = conn.createStatement();
String strQuery=null;

strQuery = "insert into vend_master set vend_id='"+vend_id+"',vend_name='"+vend_name+"'";
int rs = st.executeUpdate(strQuery);

System.out.println("Connected to the database");
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
}

%>

August 19, 2008 at 11:56 AM

To create a prodmaster form "prodmaster.jsp"

<%@ page language="java" import="java.sql.*;"%>
<html>
<head>

</head>
<body>

<form name="prodForm" method="post" action="prodmid.jsp">
<table>

<tr>
<td>Product Id</td>
<td><input type="text" name="prod_id" value=""></td>
</tr>
<tr>
<td>Product Name</td>
<td><input type="text" name="prod_name" value=""></td>
</tr>

<tr>
<td>Product Id</td>
<td><input type="text" name="prod_opstock" value=""></td>
</tr>
<tr>
<td>Product Name</td>
<td><input type="text" name="prod_excise" value=""></td>
</tr>

<tr>
<td>Product Id</td>
<td><input type="text" name="prod_vat" value=""></td>
</tr>
<tr>
<td>Product Name</td>
<td><input type="text" name="reorder_level" value=""></td>
</tr>
<tr>
<td>Product Id</td>
<td><input type="text" name="reorder_qty" value=""></td>
</tr>
<tr>
<td>Product Name</td>
<td><select name="vend_id">
<%
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "test";
String driver = "com.mysql.jdbc.Driver";
String username = "root";
String userPassword = "root";
String submit="";

try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,username,userPassword);
Statement st = conn.createStatement();
String strQuery=null;

strQuery = "select * from vend_master";
ResultSet rs = st.executeQuery(strQuery);
out.println(strQuery);
while(rs.next())
{
%>

<option value="<%=rs.getString(1)%>"><%=rs.getString(2)%></option>
<%
}

System.out.println("Connected to the database");
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}

%>
</select>
</td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>

</body>
</html>

August 19, 2008 at 11:58 AM

To save data prodmaster in database "prodmid.jsp"

<%@ page language="java" import="java.sql.*;"%>
<%

// initialze the parameter form

String prod_id = "";
String prod_name = "";
String prod_opstock = "";
String prod_excise = "";
String prod_vat = "";
String reorder_level = "";
String reorder_qty = "";
String vend_id = "";

// initialze the database connectivity
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "test";
String driver = "com.mysql.jdbc.Driver";
String username = "root";
String userPassword = "root";
String submit="";

if(request.getParameter("Submit")!=null)
{

prod_id = request.getParameter("prod_id");
prod_name = request.getParameter("prod_name");
prod_opstock = request.getParameter("prod_opstock");
prod_excise = request.getParameter("prod_excise");
prod_vat = request.getParameter("prod_vat");
reorder_level = request.getParameter("reorder_level");
reorder_qty = request.getParameter("reorder_qty");
vend_id = request.getParameter("vend_id");

out.println(vend_id);
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,username,userPassword);
Statement st = conn.createStatement();
String strQuery=null;

strQuery = "insert into prod_master set prod_id='"+prod_id+"',prod_name='"+prod_name+"',prod_opstock='"+prod_opstock+"',prod_excise='"+prod_excise+"',prod_vat='"+prod_vat+"',reorder_level='"+reorder_level+"',reorder_qty='"+reorder_qty+"',vend_id='"+vend_id+"'";

int rs = st.executeUpdate(strQuery);

System.out.println("Connected to the database");
conn.close();
System.out.println("Disconnected from database");
} catch (Exception e) {
e.printStackTrace();
}
}

%>

For read more information

http://www.roseindia.net/

Thanks

vineet