【原创】大叔经验分享(94)jdbc连接mysql、sqlserver、oracle
2024-09-05 03:21:53
Mysql
driver下载:https://mvnrepository.com/artifact/mysql/mysql-connector-java
import java.sql.*;
public class SqlServerTest {
public static void main(String []args) {
String driverName="com.mysql.jdbc.Driver";
String dbURL="jdbc:mysql://$ip:3306/$db";
String userName="$user";
String userPwd="$password";
try
{
Class.forName(driverName);
Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
Statement st = dbConn.createStatement();
ResultSet rs = st.executeQuery("select * from user");
while (rs.next()) {
System.out.println(rs.getString(1));
}
System.out.println("success!");
}
catch(Exception e)
{
e.printStackTrace();
System.out.print("fail!");
}
}
}
SqlServer
driver下载:https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4/4.0
import java.sql.*;
public class SqlServerTest {
public static void main(String []args) {
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL="jdbc:sqlserver://$ip:1433;DatabaseName=$db";
String userName="$user";
String userPwd="$password";
try
{
Class.forName(driverName);
Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
Statement st = dbConn.createStatement();
ResultSet rs = st.executeQuery("select * from sysobjects where xtype='U'");
while (rs.next()) {
System.out.println(rs.getString(1));
}
System.out.println("success!");
}
catch(Exception e)
{
e.printStackTrace();
System.out.print("fail!");
}
}
}
Oracle
driver下载:https://www.oracle.com/database/technologies/jdbc-drivers-12c-downloads.html
import java.sql.*;
public class SqlServerTest {
public static void main(String []args) {
String driverName="oracle.jdbc.driver.OracleDriver";
String dbURL="jdbc:oracle:thin:@//$ip:1521/$db";
String userName="$user";
String userPwd="$password";
try
{
Class.forName(driverName);
Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
Statement st = dbConn.createStatement();
ResultSet rs = st.executeQuery("select * from all_tab_comments");
while (rs.next()) {
System.out.println(rs.getString(1));
}
System.out.println("success!");
}
catch(Exception e)
{
e.printStackTrace();
System.out.print("fail!");
}
}
}
最新文章
- Unity3d uGUI适配
- SQL server 常用语句
- Python中setuptools做什么用的?
- 你真的了解UIWindow吗?
- js混淆工具
- position:sticky用法
- linux下查看串口信息
- JY05-JavsScript-JS基础01
- JavaScript的this详解
- 兼容不同浏览器的 CSS Hack 写法
- javascript页面间传递参数
- 快速配置vs2012+opencv
- java.sql.SQLException:Invalid value for getInt()-'zhangsan'
- python 中 dlib库的安装
- MySQL-ERROR 2003
- linux下目录的作用
- Asp.net:上传文件超过了最大请求长度
- c++ vector详解
- windows7环境下使用pip安装MySQLdb
- c# 多线程调用窗体上的控件 示例