Question: jsp-datagrid

Ads

 
 
 

Share on Google+Share on Google+

Ankit Kumar
jsp-datagrid
1 Answer(s)      4 years and 11 months ago
Posted in : Java Beginners

hello sir...i have one view page in which edit and delete option are there in a datagrid view and i want to show data in page wise(pagination)...with previous and next links....i am also attaching my code for your convience....plz look to it its very urgent....plz...??????

<body>
    <form method="post" name="form">

<table border="1"><a href=""></a>
        <table >
        <tr bgcolor="#E8E8E8">
        <td><b>ID</b></td>
        <td><b>Name</b></td>
        <td><b>Age</b></td>
        <td><b>Gender</b></td>
        <td><b>Address</b></td>
        <td><b>Phone</b></td>
        <td><b>Post</b></td>
        <td colspan="2"><b>Action</b></td>
        </tr>
        <%!                    ResultSet rs = null;

        %>
        <%

            try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sms", "root", "root");
            String query = "select * from post";
            Statement st;
            st = con.createStatement();
            ResultSet rs = st.executeQuery(query);
        %>
        <%
            while (rs.next()) {
        %>
        <tr bgcolor="#D8D8D8" >
            <td width='50'><%=rs.getString(1)%></td>
            <td width='50'><%=rs.getString(2)%></td>
            <td width='50'><%=rs.getString(3)%></td>
            <td width='50'><%=rs.getString(4)%></td>
            <td width='50'><%=rs.getString(5)%></td>
            <td width='50'><%=rs.getString(6)%></td>
            <td width='50'><%=rs.getString(7)%></td>




<td><input type="submit"  value="Edit" style="background-color:green;font-weight:bold;color:white;" onclick="editRecord(<%=rs.getString(1)%>)" ></a></td>
<td><input type="submit"  value="Delete" style="background-color:red;font-weight:bold;color:white;" onclick="deleteRecord(<%=rs.getString(1)%>)" ></a></td>
</tr>
<%
}
%>
<%
}
catch(Exception e){
e.printStackTrace();
}
%>



</table>
</form>
Ads
View Answers

June 11, 2012 at 4:21 PM


Have a look at the following link:

Visit Here


Ads









Related Tutorials/Questions & Answers:
jsp-datagrid
jsp-datagrid  hello sir...i have one view page in which edit and delete option are there in a datagrid view and i want to show data in page wise(pagination)...with previous and next links....i am also attaching my code for your
jsp-datagrid
jsp-datagrid  hello sir...i have one view page in which edit and delete option are there in a datagrid view and i want to show data in page wise(pagination)...with previous and next links....i am also attaching my code for your
Advertisements
jsp-datagrid
jsp-datagrid  hello sir...i have one view page in which edit and delete option are there in a datagrid view and i want to show data in page wise(pagination)...with previous and next links....i am also attaching my code for your
jsp-datagrid
jsp-datagrid  hello sir.....i have 20 records in my database and i am showing those data in datagrid view but now i want to show 10 data in one page... option in my datagrid view with 1,2 pages....plz help me...awaiting for your
jsp-datagrid
jsp-datagrid  hello sir.....i have 20 records in my database and i am showing those data in datagrid view but now i want to show 10 data in one page... option in my datagrid view with 1,2 pages....plz help me...awaiting for your
Tutorials   
Java Spring Hibernate Struts Training Apache Commons ioutils maven dependency Read/Convert an inputStream to a String What is the meaning of Java Platform? Why Java is a platform independent language? What is the benefits of learning Core Java? Which technology should I learn after Java? What is array in java with example? How to Convert ArrayList to Array? How to substring in Java? How to format number in Java? What is instance variable in Java? How to download MySQL JDBC driver? What is Calendar class in Java? Which is the best Java tutorials for beginners? How to rename a file in Java? How to delete file in Java code? How to get day from date in Java using Calendar? How to get day of week in Java? How to calculate Date Difference in Java? How to compare date in Java? How to declare array in Java? How to calculate average of array in Java? What is Array in Java? write a java program to find the summation of all the integers entered on command line Sum of two numbers using command line arguments in Java How to create and use Array in Java? How to pass command line arguments in Java? How to create Applet Hello World? Appending String efficiently in Java How to append String in Java? How to list even numbers between 1 and 100? How to add BigDecimal in Java? What is Abstraction In Java? Which is best Beginners Java Tutorial? What is java.util package? Create list from array in Java Filter collection in Java 8 What is the best way to filter a Java Collection? Easy way to transform Collection to Array? How to convert Collection to Array in Java? What are Basic Java Language Elements? Advanced Java Tutorials in 2017 Java brief history Best Reasons to learn Java Java Example Codes and Tutorials in 2017 How do I read a large file quickly in Java? Is learning Java worthwhile? How to create first Java Program? Retrieve database from the table dynamically in jsp from oracle using servlet What does core Java include?

Ads

 
Advertisement null

Ads