java写一个窗体并连接MySQL_java建立一个窗口，上面是一个按钮，下面是一个文本框，点击按钮之后，将连接SQL 数据库...

java建立一个窗口，上面是一个按钮，下面是一个文本框，点击按钮之后，将连接SQL数据库，将相关查询结果输出到文本框当中。文本框要做的大些，输出内容会比较多，急求，谢谢！！！数据...

java建立一个窗口，上面是一个按钮，下面是一个文本框，点击按钮之后，将连接SQL 数据库，将相关查询结果输出到文本框当中。文本框要做的大些，输出内容会比较多，急求，谢谢！！！

数据库查询语言：

SELECT Qcontent FROM (SELECT TOP 1 *, NewId() As RandomX FROM Q Where (K1='jx')AND(QTypeName='xz')AND(QDifficulty='1') Order By RandomX) A

UNION ALL

SELECT Qcontent FROM (SELECT TOP 3 *, NewId() As RandomX FROM Q Where (K1 NOT IN('jx'))AND(QTypeName='xz')AND(QDifficulty='1') Order By RandomX) B

UNION ALL

SELECT Qcontent FROM (SELECT TOP 6 *, NewId() As RandomX FROM Q Where (K1 NOT IN('jx'))AND(QTypeName='xz')AND(QDifficulty='2') Order By RandomX) C

UNION ALL

SELECT Qcontent FROM (SELECT TOP 1 *, NewId() As RandomX FROM Q Where (K1 NOT IN('jx'))AND(QTypeName='tk')AND(QDifficulty='1') Order By RandomX) D

UNION ALL

SELECT Qcontent FROM (SELECT TOP 4 *, NewId() As RandomX FROM Q Where (K1 NOT IN('jx'))AND(QTypeName='tk')AND(QDifficulty='2') Order By RandomX) E

UNION ALL

SELECT Qcontent FROM (SELECT TOP 1 *, NewId() As RandomX FROM Q Where (K1 NOT IN('jx'))AND(QTypeName='jd')AND(QDifficulty='2') Order By RandomX) F

UNION ALL

SELECT Qcontent FROM (SELECT TOP 4 *, NewId() As RandomX FROM Q Where (K1 NOT IN('jx'))AND(QTypeName='tk')AND(QDifficulty='3') Order By RandomX) G

急求急求，谢谢！

数据库是SQL sever 2000 数据库名称是 多层次试题库，登录名是sa 密码为空

展开