Sum of Column in a Database Table : Column « Database SQL JDBC « Java

Java 1.  2D Graphics GUI 2.  3D 3.  Advanced Graphics 4.  Ant 5.  Apache Common 6.  Chart 7.  Class 8.  Collections Data Structure 9.  Data Type 10.  Database SQL JDBC 11.  Design Pattern 12.  Development Class 13.  EJB3 14.  Email 15.  Event 16.  File Input Output 17.  Game 18.  Generics 19.  GWT 20.  Hibernate 21.  I18N 22.  J2EE 23.  J2ME 24.  JDK 6 25.  JNDI LDAP 26.  JPA 27.  JSP 28.  JSTL 29.  Language Basics 30.  Network Protocol 31.  PDF RTF 32.  Reflection 33.  Regular Expressions 34.  Scripting 35.  Security 36.  Servlets 37.  Spring 38.  Swing Components 39.  Swing JFC 40.  SWT JFace Eclipse 41.  Threads 42.  Tiny Application 43.  Velocity 44.  Web Services SOA 45.  XML Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java » Database SQL JDBC » Column Screenshots  Sum of Column in a Database Table    import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Main {   public static void main(String[] argv) throws Exception {     int sum = 0;     Class.forName("com.mysql.jdbc.Driver");     Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctutorial",         "root", "root");     Statement st = con.createStatement();     ResultSet res = st.executeQuery("SELECT SUM(col) FROM mytable");     while (res.next()) {       int c = res.getInt(1);       sum = sum + c;     }     System.out.println("Sum of column = " + sum);   } }             Related examples in the same category 1.  Get Column Corresponding Class Name 2.  Get Column Detail Information 3.  Get Column Display Size.zip 4.  Get Column Label 5.  Get Column Name 6.  Use DatabaseMetaData to get table column names 7.  Get Column Name And Type For A Table 8.  Get Column Name From ResultSet Metadata 9.  Get Column Number Of Digits To Right Of The Decimal Point 10.  Get Column Number Of Presions Number Of Decimal Digits 11.  Get Column ORDINAL POSITION 12.  Get Column Privileges 13.  Get Column Size 14.  Get Column Sql Data Type 15.  Get Column SQL Type Name 16.  Get Column Type 17.  Get Table Optimal Set Of Columns 18.  Is Column A Cash Value 19.  Is Column Auto Increase 20.  Is Column Case Sensitive 21.  Is Column Definitely Writable 22.  Is Column Nullable 23.  Is Column Nullable From ResultSet Metadata 24.  Is Column Readonly 25.  Is Column Searchable 26.  Is Column Signed Number 27.  Is Column Writable 28.  Make Unique Column in Database Table 29.  Remove Unique Column in Database Table 30.  Arrange a Column of Database Table 31.  Change Column Name of a Table 32.  Delete a Column from a Database Table 33.  Adding a New Column Name in Database Table 34.  Designated column's table name 35.  If a table column can have a null value or not? 36.  If a table column value is auto-increment? 37.  Get Column Names From ResultSet for MySQL