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 密码为空 展开
数据库查询语言:
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 密码为空 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询