java 怎么获取数据库的编码以及配置信息?
答案:2 悬赏:10 手机版
解决时间 2021-01-28 03:04
- 提问者网友:你给我的爱
- 2021-01-27 14:14
例如mysql里面my.ini里面的信息,port、default-character-set等等,不用io流读取文件的形式
最佳答案
- 五星知识达人网友:逃夭
- 2021-01-27 15:00
Java也可以执行Mysql命令,你可以使用sql 语句,如下:
mysql> SHOW VARIABLES LIKE '%char%set%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /u01/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------+
8 rows in set
mysql> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set
你如果想获取所有配置信息可以使用: SHOW VARIABLES命令。
mysql> SHOW VARIABLES LIKE '%char%set%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /u01/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------+
8 rows in set
mysql> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set
你如果想获取所有配置信息可以使用: SHOW VARIABLES命令。
全部回答
- 1楼网友:佘樂
- 2021-01-27 15:43
1.jdbc.properties
driver=com.microsoft.jdbc.sqlserver.sqlserverdriver
url=jdbc:microsoft:sqlserver://ip地址:1433;databasename=test
user=test
password=test
2.一个servlet
import java.io.printstream;
import java.sql.*;
import java.util.resourcebundle;
public class dboperator
{
public dboperator()
{
}
public static void main(string args[])
{
connection con = getconnection();
system.out.println("connection success");
closeconnection(con);
system.out.println("close success");
}
public static connection getconnection()
{
try
{
return drivermanager.getconnection(url, user,
password);
}
catch(sqlexception e)
{
e.printstacktrace();
}
return null;
}
public static void closeconnection(connection con)
{
try
{
if(con != null)
con.close();
}
catch(sqlexception e)
{
e.printstacktrace();
}
}
private static string url;
private static string user;
private static string password;
static
{
resourcebundle bundle = resourcebundle.getbundle("路径");
try
{
class.forname(bundle.getstring("driver"));
}
catch(classnotfoundexception e)
{
e.printstacktrace();
}
url = bundle.getstring("url");
user = bundle.getstring("user");
password = bundle.getstring("password");
}
}
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯