随笔分类 - JDBC
摘要:package com.huawei.mysql;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class MySqlTest { public static void main(String[] args) throws SQLException { Connection conn = null; PreparedStatement..
阅读全文
摘要:package com.huawei.sqlserver;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class SqlTest { public static void main(String[] args) throws SQLException { Connection conn = null; PreparedStateme..
阅读全文
摘要:package com.huawei.oracle;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class OracleTest { public static void main(String[] args) throws SQLException { Connection conn = null; PreparedStateme..
阅读全文
摘要:import java.sql.*;public class TestJDBC { public static void main(String[] args) { ResultSet rs = null; Statement stmt = null; Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); //new oracle.jdbc.driver.OracleDriver(); conn = DriverManager.getConnection("j
阅读全文
摘要:package com.anllin.sqlserver;import java.sql.*;public class SqlserverTest{ public static void main(String[] args) { sqlsserver2005Test(); } public static void sqlsserver2005Test() { String connectionUrl = "jdbc:sqlserver://localhost:1433;databaseName=test;username=sa;password=123"; Connect
阅读全文
摘要:package com.anllin.mysqltest;import java.sql.*;public class MysqlTest{ public static void main(String[] args) { connetMysqlTest(); } public static void connetMysqlTest() { String connectionUrl = "jdbc:mysql://localhost:3306/mydata?user=root&password=123"; Connection conn = null; Statem
阅读全文

浙公网安备 33010602011771号