posts - 46,comments - 38,trackbacks - 0
            public boolean Check_DataBase_IsOpen(String fwqIP,String user,String password) {
              boolean m_boo = true;
              String url =  "jdbc:jtds:sqlserver:"+"//"+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 我的java生涯 阅读(75) 评论(0)  编辑  收藏 所属分类: 学习日记

标题  
姓名  
主页
验证码 *  
内容(请不要发表任何与政治相关的内容)  
  登录  使用高级评论  新用户注册  返回页首  恢复上次提交      
 
 
相关链接:
网站导航: