Connectivity Through Java Program
Here i want to save a data from textbox to database through java program by clicking submit button here i attached a java connectivity program but i dont know to pass a data to the particular program .kindly help me on the above things
Thank you
ag_rajkumar@yahoo.com
-
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<SCRIPT type=text/javascript>
function formValidator(){
// Make quick references to our fields
var partycode = document.getElementById('partycode');
var partyname = document.getElementById('partyname');
var partyaddress = document.getElementById('partyaddress');
var city= document.getElementById('city');
var tinno = document.getElementById('tinno');
var tngstno = document.getElementById('tngstno');
var phoneno = document.getElementById('phoneno');
var contactpersonname = document.getElementById('contactpersonname');
var contactpersonnumber = document.getElementById('contactpersonnumber');
// Check each input in the order that it appears in the form!
if(isAlphanumeric(partycode,"Dont enter special characters"))
{
if(isAlphabet(partyname,"Enter Party Name"))
{
if(isAlphanumeric(partyaddress,"Dont Enter Special Characters in Address"))
{
if(isAlphabet(city,"Enter Valid City Name"))
{
if(isAlphanumeric(tinno,"Enter Valid Tinno"))
{
if(isAlphanumeric(tngstno,"Enter Valid TNGSTNO"))
{
if(isNumeric(phoneno,"Enter Valid Phone Number"))
{
if(isAlphabet(contactpersonname,"Enter Contact Person Name"))
{
if(isNumeric(contactpersonnumber,"Enter Valid Phone Number in CPN"))
{
return true;
}
}
}
}
}
}
}
}
}
return false;
}
function isAlphabet(elem, helperMsg){
var alphaExp = /^[a-zA-Z ./]+$/;
if(elem.value.match(alphaExp)){
return true;
}else{
alert(helperMsg);
elem.value = "";
elem.focus();
return false;
}
}
function isAlphanumeric(elem, helperMsg){
var alphaExp = /^[0-9a-zA-Z, ./-]+$/;
if(elem.value.match(alphaExp)){
return true;
}else{
alert(helperMsg);
elem.value = "";
elem.focus();
return false;
}
}
function isNumeric(elem, helperMsg){
var numericExpression = /^[0-9.]+$/;
if(elem.value.match(numericExpression)){
return true;
}else{
elem.value = "";
alert(helperMsg);
elem.focus();
return false;
}
}
function isEmpty(elem, helperMsg){
if(elem.value.length == 0){
alert(helperMsg);
elem.value = "";
elem.focus(); // set the focus to this input
return true;
}
return false;
}
</SCRIPT>
<META content="MSHTML 6.00.2800.1555" name=GENERATOR></HEAD>
<BODY bgColor=#91858f><!--BackGround Colour--><!--H1 Means Header Text ALIGN CEntered With Text-->
<H1 align=center><U><B><I>Customer Details<I><B></U></H1>
<P align=center><A
href="file:///D:/rajkumar/project/textile%20projects/purchase.html"><IMG
height=38 src="customerdetails_files/purchase.jpg" width=65 border=1> Purchase
order </A><A
href="file:///D:/rajkumar/project/textile%20projects/customerdetails.html"><IMG
height=38 src="customerdetails_files/sales.jpg" width=65 border=1> Customer
Details </A><A
href="file:///D:/rajkumar/project/textile%20projects/sales.html"><IMG height=38
src="customerdetails_files/expence.jpg" width=65 border=1> sales </A><A
href="file:///D:/rajkumar/project/textile%20projects/payment.html"><IMG
height=38 src="customerdetails_files/payment.jpg" width=65 border=1> payment
</A><A href="file:///D:/rajkumar/project/textile%20projects/report.html"><IMG
height=38 src="customerdetails_files/collection.jpg" width=65 border=1> Report
</A></P><!--Linking Section Ends Here-->
<TABLE borderColor=#13 cellSpacing=0 width=81 align=center border=6>
<FORM>
<TBODY>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>Party
Code</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=partycode size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>Party
Name</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=partyname size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>Party
Address</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=partyaddress size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>City</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=city size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>Tin No</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=tinno size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>TNGST
No</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=tngstno size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>Phone
No</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=phoneno size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>Contact Person
Name</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=contactpersonname size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><SPAN class=bold>Contact Person
Number</SPAN></TD>
<TD class=subcolor colSpan=6><INPUT id=contactpersonnumber size=21> <SPAN
class=normal></SPAN></TD></TR>
<TR>
<TD class=subcolor width=233 colSpan=14><INPUT onclick=javascript:formValidator(); type=button value=" Submit " name=submit>
<TD class=subcolor width=233 colSpan=14><INPUT type=reset value="Reset" name=Reset>
</TD></TR></FORM></TBODY></TABLE></B></I></I></B></BODY></HTML>
--
import java.sql.*;
public class TestConnection {
public static void main(String args[]) {
Connection connection = null;
try {
//System.out.println("Loading class");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//System.out.println("Loaded class");
connection = DriverManager.getConnection("jdbc:odbc:sample","sa","pwd");
//System.out.println("Connection established");
Statement st = connection.createStatement();
int rr =st.executeUpdate ("INSERT INTO Cust_details(party_code,party_name,party_address,city,tinno,tngstno,phoneno,cpname,cpnno ) "
+ "VALUES ('a101','rajkumar')");
ResultSet rs = st.executeQuery("select * from cust_details");
while(rs.next())
{
System.out.print(rs.getString(1));
System.out.print(""+rs.getString(2));
System.out.print(""+rs.getString(3));
System.out.print(""+rs.getString(4));
System.out.println(" ");
}
rs.close();
st.close();
connection.close();
System.out.println("Connection Established " + connection);
}
catch (Exception e) {
System.out.println(e);
}
}
}
