
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 密码为空 展开
2个回答
展开全部
首先你利用java swing进行页面的编辑,首先定义面板,将面板设置城表格布局(BorderLayout)然后将组建比如按钮和文本框添加到面板上,将按钮添加到North,将文本框添加到Center,然后将此面板添加到窗体中。对按钮添加事件监听器,里面指定你处理数据库的方法,例如:数据库的驱动连接,里面处理细节的方法,记住此方法返回一个字符串,然后将此方法返回的内容设置成你文本框的内容,这样就能实现你所要求的目的!
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询