??????????? public boolean Check_DataBase_IsOpen(String fwqIP,String user,String password) {
????????????? boolean m_boo = true;
????????????? String url =? "jdbc:jtds:sqlserver:"+"http://"+fwqIP+":1433;DatabaseName=master;lastupdatecount=true;SelectMethod=cursor";
????????????? com.paiao.app.db.DbBase dbbase? =? com.paiao.app.db.DbBase.getInstance();
????????????? Connection con = this.con(url,user,password);
????????????? PreparedStatement pstm = null;
????????????? String sqls1 = "create database shebei_paiao ";
????????????? //String sqls1 = "select * from syscolumns ";
????????????? try {
??????????????? pstm = con.prepareStatement(sqls1);
??????????????? pstm.execute();
??????????????? m_boo = true;
????????????? }
????????????? catch (Exception e) {
??????????????? m_boo = false;
??????????????? System.out.println("您的mssqlserver數據庫沒有啟動!");
????????????? }
????????????? finally {
??????????????? dbbase.Release(pstm, con);
????????????? }
????????????? return m_boo;
??????????? }
posted on 2007-03-25 00:46
JJCEA 閱讀(303)
評論(0) 編輯 收藏 所屬分類:
學習日記