java resultset example

First, the preface In fact, the rewritten JDBC Data-source is run in the servlet, looking for a data source through Jndi. I use the Orion trial, the site of the "Java/jsp Learning series of six (MySQL page example)," a simple rewrite. Second, the configuration (1) Jdbc Need to use JDBC driver copy to [Orion]/lib directory (2) Data-source Add the following in the [Orion]/config/data-sources.xml file:

js|mysql| Page One, preface In fact, the rewritten JDBC Data-source is run in the servlet, looking for a data source through Jndi. I use the Orion trial, the site of the "Java/jsp Learning series of six (MySQL page example)," a simple rewrite. Second, the configuration (1) Jdbc Need to use JDBC driver copy to [Orion]/lib directory (2) Data-source Add the following in the [Orion]/config/data-sources.xm

Java code:Package procedure;Import java. SQL. CallableStatement;Import java. SQL. Connection;Import java. SQL. DriverManager;Import java. SQL. ResultSet;Import java. SQL. SQLException;I

// Name of the Java Bean file connecting to the database dbconn. javaPackage NinGoo;Import java. SQL .*;Public class dbconn {Public dbconn (){}// Declare variablePrivate Connection conn = null;ResultSet rs = null;Private String server = "127.0.0.1 ";Private String port = "3306 ";Private String db = "test ";Private String user = "root ";Private String pass = "pass

. SQL. *; public class testmysql {/*** @ Param ARGs */public static void main (string [] ARGs) {// todo auto-generated method stub try {class. forname ("com. mySQL. JDBC. driver "); connection Ct = drivermanager. getconnection ("JDBC: mysql: // localhost: 3306/yan1", "root", "123456"); statement ST = CT. createstatement (); resultset rs = st.exe cutequery ("select * from users "); While (RS. next () {system. out. println ("ID:" + Rs. getstring (1) + "

Learn Java friends should know that Java from the beginning of the platform to play a non-independent banner, said "write once, run everywhere", actually speaking of irrelevant, the Java platform has another irrelevant that is language-independent, to achieve the language of independence, Then the Java System class fil

simple as it is, for beginners, if there is no Code that can be successfully executed, really difficult to debug use access to create a database db1.mdb. There is a table named "Table1" with the fields "name" and "Age". just enter a few records, save it and create a system data source "Access2000" in ODBC to connect to this database then you can use the following code to display all records in the database database. java ------------------ Imp

performance of Java applications. In my experience, the file change notifier in Nio.2 is one of the most interesting (underrated) features of the new input/output API. Many enterprise applications need to do some special processing in the following situations: When a file is uploaded to an FTP folderWhen the definition in a configuration is modifiedWhen a draft document is uploadedWhen other file system events occurThese are examples of change noti

Java I/O interpretation and use example Abstract: This article describes how to interpret and use Java I/O.I. Basic concepts of I/O The full name of I/O is Input/Output, and Java I/O is the Input and Output operations of Java. Related interfaces and classes are stored in th

Java RMI distributed program development example Author: javaboy2012Email: yanek@163.comQQ: 1046011462 I. Server Side Interface Definition: note that the remote interface must be inherited. Package com. Yanek. RMI. server; Import java. RMI. Remote;Import java. RMI. RemoteException;Import

Although simple, for beginners, without a piece of code can be successfully executed for reference, it is difficult to debugFirst use access to build a database DB1. MDB, which has a table "table1" with Field "Name" and "age"Just fill in a few records, save to the ODBC to build a system data source "Access2000" connected to this databaseYou can then use the following code to display all the records in the database.Database.java------------------Import java.sql.*;Class Database {public static voi

. Insert:Connection conn = CreateConnection (); String sql = "INSERT into TMap (mapserviceid,mapid,mapname) VALUES (?,?,?)"; PreparedStatement pstmt=conn.preparestatement (SQL);p stmt.setstring (1, "1");p stmt.setstring (2, "7"); Pstmt.setstring (3, "Test1");p stmt.executeupdate ();p stmt.close (); Conn.close ();2. Enquiry String sql = "SELECT * from TMap"; PreparedStatement pstmt=conn.preparestatement (SQL); Resul