testconn.java~23~

来自「采用web2.0技术,采用动态标签,sql语句全部存储在数据库里面.开发速度快.」· JAVA~23~ 代码 · 共 55 行

package com.sztheater.framework;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;

public class TestConn {
    public TestConn() {
    }

    /** get Connection */
    public Connection getConnection() throws Exception
    {

       /*Connection conn = null;
       conn = DBManager.instance().getDBConn(myDSName);
       return conn;
      */
      String  driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
      String url = "jdbc:microsoft:sqlserver://202.103.69.210:1433;DatabaseName=newlifeivrdb";
      String user = "sa";
      String pwd = "newlifeappdb";
      Connection conn = null;
      conn =  DriverManager.getConnection(url,user,pwd);
      return conn;
    }
    public static void main(String args[])
    {
          String strSQL = "select 'aaaa' as a";
        try
        {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
            String url =
                    "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=SZTheater";
            //pubs为你的数据库的
            String user = "sa";
            String password = "";
            Connection conn = DriverManager.getConnection(url, user, password);
            Statement stmt = conn.createStatement();
            String sql = "select '11111' as a ";
            ResultSet rs = stmt.executeQuery(sql);
            while (rs.next())
            {
                System.out.println("1111111111111111111");
            }


        }
        catch(Exception ex)
        {
        ex.printStackTrace();
        }
    }
}