jdbc database connection example

to Oracle Database public class Orcaledbutil {public static final String DRIVER = "Oracle.jdbc.driver.OracleDriver";public static final String URL = "Jdbc:oracle:thin: @localhost: 1521:ORCL";public static final String USER = "dan_1";//Database namepublic static final String PWD = "1234567";//Passwordpublic static Connection Getoracleconnection () {

First, place the drive jar package in a Lib package in the server (e.g. Tomcat) directory to have the server automatically manage the database connectionB. In the Meta-inf folder in the project root, build the context.xml file, where you need to configure the data source1234Auth= "Container"5Type= "Javax.sql.DataSource"6 7Username= "Scott"8Password= "123"9Url= "Jdbc:oracle:thin: @localhost: 1521:orcl"TenDriverclassname = "Oracle.jdbc.drive

Tags: into count database meta Red pre CTI stat JDBCmanipulating databases through JDBC PackageHead18; Importjava.sql.Connection;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.SQLException; Importjava.sql.Statement; Importcom.mysql.jdbc.PreparedStatement; Public classJDBC { Public Static voidMain (string[] args) {//Load Driver Try{class.forname ("Com.mysql.jdbc.Driver"); Sy

= (address = (host = 192.168.60.132) (protocol = tcp) (port = 1521) (address = (host = 192.168.60.144) (protocol = tcp) (port = 1521) (load_balance = yes) (failover = yes) (connect_data = (service_name = oratest ))) However, tomcat reports the following error: Io Exception: NL Exception was generated; 2. google and baidu on the Internet. Although the n method is found, the error is always prompted; 3. In desperation, open the database tnsname.

Tags: /******************** test using temporary data source code ***************/string URL = "Jdbc:mysql://localhost:3306/test"; String username = "root"; String password = "root"; Connection con = drivermanager.getconnection (URL, username, password); /********************JDBC Connection Database Operation ******

'";// St.executeupdate (SQL); Additions and deletions are used this execution of the statement because of the update database String sql = "SELECT * from the person"; ResultSet rs=st.executequery (SQL); Query with this executive languageThe result of the sentence query is saved in the result set ResultSet class object Rs in while (Rs.next ()) { Rs.next () returns true if the result set RS has the

objectPanax Notoginseng stsm.executequery (); - the /** + * 6: Get the value of the output parameter A * Based on the index value, that is, the location of the output parameters in the precompiled SQL language the */ +String result = stsm.getstring (2); - System.out.println (Result); $ } $ Catch(Exception e) { - e.printstacktrace (); - Throw NewRuntimeException (e); the } - //7: Close the connectionWuyi

Importjava.sql.Connection;ImportJava.sql.DriverManager; Public classDbutil {PrivateString dburl= "Jdbc:mysql://localhost:3306/db_book";PrivateString dbusername= "Root";PrivateString dbpassword= "123456";PrivateString jdbcname= "Com.mysql.jdbc.Driver";/*** Get database connection *@return* @throwsException*/ PublicConnection Getcon ()throwsException{class.forname (jdbcname); Connectioncon=drivermanager.getco

Tags: get root connections col Drive path Ali Mys ResultSetJDBC Connection database Five steps: One, load drive Class.forName ("com.mysql.jdbc.Driver"); Second, establish the connection Connection conn = drivermanager.getconnection ("jdbc:mysql://localhost:8080/database name

);}}　　Package Cn.tree.dao;import Java.sql.connection;import Java.sql.drivermanager;import java.sql.resultset;import Java.sql.sqlexception;import Java.sql.statement;import Cn.tree.util.configmanager;public class MenuDao {// Query home directory public void Getmainlist () {Connection Connection = null; Statement st = null; ResultSet rs = null; String Driver = Configmanager.getinstance (). getString ("Jdbc.dri

(ClassNotFoundException e) {System.out.println ("Driver class not found, add to failure");E.printstacktrace ();}After a successful load, an instance of the driver class is registered in the Drivermanger class.2), provide the URL of the JDBC connectionThe connection URL defines the protocol, sub-protocol, and data source identity when the database is connected.Wr