数据库:库名:me,表名:2006,字段:name(String),date(短日期型),gz(int)
我想以文本框所输入的数据为依据对数据库进行查询,查得的结果再显示到别的文本框中,但显示不出来,郁闷 Connection conn_1;
Statement stmt_1;
Connection conn_2;
Statement stmt_2;
ResultSet myResults;
ResultSetMetaData resultsMetaData; int gz_2;
String xm_2,rq1,rq2,s;
xm_2=xmText.getText().trim();
rq1=fromText.getText().trim();
rq2=toText.getText().trim();
gz_2=Integer.parseInt(gzText.getText().trim());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl_2 ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=me.mdb";//此为NO-DSN方式
//录入数据库
conn_2=DriverManager.getConnection(dburl_2);
//建立数据库查询对象
stmt_2=conn_2.createStatement();
//接收数据查询的信息
myResults=stmt_2.executeQuery("select sum(gz) from 2006 where Date >= '"+rq1+"' and Date <= '"+rq2+"' and name='"+xm_2+"'");
resultsMetaData =myResults.getMetaData();
int sum= resultsMetaData.getColumnCount();
s=""+sum;
answerText.setText(s);
我想以文本框所输入的数据为依据对数据库进行查询,查得的结果再显示到别的文本框中,但显示不出来,郁闷 Connection conn_1;
Statement stmt_1;
Connection conn_2;
Statement stmt_2;
ResultSet myResults;
ResultSetMetaData resultsMetaData; int gz_2;
String xm_2,rq1,rq2,s;
xm_2=xmText.getText().trim();
rq1=fromText.getText().trim();
rq2=toText.getText().trim();
gz_2=Integer.parseInt(gzText.getText().trim());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String dburl_2 ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=me.mdb";//此为NO-DSN方式
//录入数据库
conn_2=DriverManager.getConnection(dburl_2);
//建立数据库查询对象
stmt_2=conn_2.createStatement();
//接收数据查询的信息
myResults=stmt_2.executeQuery("select sum(gz) from 2006 where Date >= '"+rq1+"' and Date <= '"+rq2+"' and name='"+xm_2+"'");
resultsMetaData =myResults.getMetaData();
int sum= resultsMetaData.getColumnCount();
s=""+sum;
answerText.setText(s);
║ 免费的源码、工具网站,欢迎大家访问!║
║ http://www.j2soft.cn/ ║
╰═══════════════════╯