package db;
import java.sql.*;
public class connectDB
{
private Connection conn;
private String url;
private DatabaseMetaData dbmd;
private String drivername;
private String databaseproduct_name;
private int maxLen;
private int maxcharliteralLength;
private int maxColumnsInTable;
private int maxRowsize;
private int maxConnections;
private int maxTablesInSelect;
public connectDB() throws Exception
{
Class.forName("com.mysql.jdbc.Driver");
//防止出现乱码
url="jdbc:mysql://localhost:3306/" +
"testforjdbc?useUnicode=true&characterEncoding=UTF-8";
conn = DriverManager.getConnection(url, "root", "1992123825");
dbmd = conn.getMetaData();
drivername = dbmd.getDriverName();
databaseproduct_name = dbmd.getDatabaseProductName();
maxLen = dbmd.getMaxIndexLength();
maxcharliteralLength = dbmd.getMaxCharLiteralLength();
maxColumnsInTable = dbmd.getMaxColumnsInTable();
maxRowsize = dbmd.getMaxRowSize();
maxConnections = dbmd.getMaxConnections();
maxTablesInSelect = dbmd.getMaxTablesInSelect();
}
public String getDriverName()
{
return drivername;
}
public String getDatabaseproduct_name()
{
return databaseproduct_name;
}
public String getUrl()
{
return url;
}
public int getMaxLen()
{
return maxLen;
}
public int getMaxcharliteralLength()
{
return maxcharliteralLength;
}
public int getMaxColumnsInTable()
{
return maxColumnsInTable;
}
public int getMaxrowSize()
{
return maxRowsize;
}
public int getMaxconnections()
{
return maxConnections;
}
public int getMaxTablesInselect()
{
return maxTablesInSelect;
}
}
testJDBC.rar_jdbc
版权申诉
125 浏览量
2022-09-14
20:31:44
上传
评论
收藏 6KB RAR 举报
周楷雯
- 粉丝: 80
- 资源: 1万+