Inserting Records using the Prepared Statement : PreparedStatement « 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 » PreparedStatement Screenshots  Inserting Records using the Prepared Statement    import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; public class Main {   public static void main(String[] argv) throws Exception {     Class.forName("com.mysql.jdbc.Driver");     Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctutorial", "root",         "root");     String sql = "INSERT product VALUES(?,?)";     PreparedStatement prest = con.prepareStatement(sql);     prest.setString(1, "asdf");     prest.setInt(2, 2009);     int count = prest.executeUpdate();     System.out.println(count + "row(s) affected");     con.close();   } }             Related examples in the same category 1.  Using the Prepared Statement Twice 2.  PreparedStatement Set Array 3.  PreparedStatement Set Object 4.  Prepared Statement Batch Update 5.  Select Records Using PreparedStatement 6.  Update Records Using PreparedStatement 7.  Demo Prepared Statement Set BigDecimal 8.  Demo Prepared Statement Set BinaryStream 9.  Demo Prepared Statement Set Blob 10.  Demo PreparedStatement Set Boolean 11.  Demo PreparedStatement Set Bytes 12.  Demo PreparedStatement Set Clob 13.  Demo PreparedStatement Set Date 14.  Demo PreparedStatement Set Float And Double 15.  Demo PreparedStatement Set Integers 16.  Demo PreparedStatement Set Byte 17.  Demo PreparedStatement Set Short 18.  Demo PreparedStatement Set Long 19.  Demo PreparedStatement Set Null for char/string column 20.  Demo PreparedStatement Set Null for int value column 21.  Demo PreparedStatement Set Reference 22.  Demo PreparedStatement Set String 23.  Demo PreparedStatement Set Time 24.  Demo PreparedStatement Set Timestamp 25.  Demo PreparedStatement Set URL 26.  Delete Records Using PreparedStatement 27.  Insert Records Using PreparedStatement 28.  Count Records Using PreparedStatement 29.  DELETE data in a table 30.  Modify data in a table 31.  SELECT data from a table 32.  Count Records using the Prepared Statement 33.  Deleting Records using the Prepared Statement 34.  Use PreparedStatement Twice 35.  Rows affected when updating data in database table 36.  Inserting with a prepared statement that uses the various setXXX() methods.