QuestionAsk Questions?
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>
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();
}
}
%>
<%@ 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>
<%@ 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
<%@ 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
Related Pages:
- Checking if a file or directory exist
- How to get New Gmail Inbox?
- What is License Terms for using your code
- Difference between equals() and == ?
- Assignment operator in java
- Hibernate Video Tutorial
- Conditional operator in java
- jQuery Tutorial For Beginners
- Show pdf's in web browser by using jsp?
- Google says Start Searching India
