package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
/**
* 数据库操作类
* @author huangshnagwen
* @version 1.0 2009-8-10
*
*/
public class DBControl {
//sql Information
private static String sqlusername="sa";// 用户名
private static String sqlpassword="sa";// 密码
private static String sqlipaddress="192.168.0.23";// IP地址
private static String sqlport="1433";// 数据库端口
private static String sqldataname="treeDB";//数据库名称
private static Connection sqlcon = null;
private static Statement sqlstm = null;
private static ResultSet sqlrs = null;
/**
* 获取SQL数据库连接
* @return Connection
*/
public static Connection GetSQLConnection() {
try {
String classname = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; //数据库驱动器
String sqlurl = "jdbc:microsoft:sqlserver://"+DBControl.sqlipaddress+":"+DBControl.sqlport+";"+"databaseName="+DBControl.sqldataname;// 数据库连接URL
Class.forName(classname);
sqlcon = DriverManager.getConnection(sqlurl, DBControl.sqlusername,DBControl.sqlpassword);
return sqlcon;
} catch (Exception ex) {
ex.printStackTrace();
return null;
}
}
/**
* 查询大类
*
*/
public static List getBigClassInfo() {
List<String> list = new ArrayList<String>();
try {
String sqlSQL = "select distinct(bigClassName) as bigClassName from bigClass ";
sqlcon = DBControl.GetSQLConnection();
sqlstm = sqlcon.createStatement();
sqlrs = sqlstm.executeQuery(sqlSQL);
while(sqlrs.next()){
String bigClassName = sqlrs.getString(1);
list.add(bigClassName);
}
} catch (Exception ex) {
ex.printStackTrace();
}
DBControl.releaseSource();
return list;
}
/**
* 查询小类
*
*/
public static List getSmallClassInfo(String bigClassName) {
List<String> list = new ArrayList<String>();
try {
String sqlSQL = "select distinct(smallClassName) as smallClassName from smallClass where bigClassName = '"+bigClassName+"'";
sqlcon = DBControl.GetSQLConnection();
sqlstm = sqlcon.createStatement();
sqlrs = sqlstm.executeQuery(sqlSQL);
while(sqlrs.next()){
String smallClassName = sqlrs.getString(1);
list.add(smallClassName);
}
} catch (Exception ex) {
ex.printStackTrace();
}
DBControl.releaseSource();
return list;
}
/**
* 查询本地语言
*
*/
public static List getLanguageInfo(String smallClassName) {
List<String> list = new ArrayList<String>();
try {
String sqlSQL = "select distinct(locallanguage) as language from language where samllClassName = '"+smallClassName+"'";
sqlcon = DBControl.GetSQLConnection();
sqlstm = sqlcon.createStatement();
sqlrs = sqlstm.executeQuery(sqlSQL);
while(sqlrs.next()){
String language = sqlrs.getString(1);
list.add(language);
}
} catch (Exception ex) {
ex.printStackTrace();
}
DBControl.releaseSource();
return list;
}
//释放资源
public static void releaseSource() {
try {
if(sqlrs!=null){
sqlrs.close();
}
if(sqlstm!=null){
sqlstm.close();
}
if(sqlcon!=null){
sqlcon.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Java 动态树 dhtmlxtree
5星 · 超过95%的资源 需积分: 16 76 浏览量
2009-11-11
10:15:49
上传
评论 2
收藏 538KB RAR 举报
huangshangwen
- 粉丝: 1
- 资源: 7
最新资源
- 基于spark和kafka的新闻案例+源代码+文档说明
- greenplum-cc-web-6.2.0-gp6-rhel7-x86-64.7z
- 电机控制霍尔传感器和反电动势的关系分析
- 计算机生产实习:OA后台管理(web前端+Java后端)压缩文件包
- greenplum6.10安装时缺失的fpm包
- 缺陷检测-轻量化PCB表面缺陷检测算法实现-工业视觉+六大缺陷检出-优质项目实战.zip
- JAVA 中的Spring框架介绍包括起源、体系结构、核心部分、特点等
- 2024年小米汽车产业链分析及新品上市全景洞察报告
- 基于Qt和C++实现的偏3D风格的异型窗体界面操作+源码(期末大作业&课设&项目开发)
- 基于yolov8的花卉分类系统,包含训练好的权重和推理代码,GUI界面,支持图片、视频、摄像头输入,支持检测结果导出
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
- 1
- 2
前往页