🚀 go-pugleaf

��� javaBean ���ҵ�SQL��ݿ����Ӳ��ϡ������д?��

//temp.java

import java.sql.*;
public class temp{
        Connection conn;
        ResultSet rs;
        private Connection connect(){
            try{
                Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"
);
                conn = DriverManager.getConnection(
                "jdbc:microsoft:sqlserver://134.148.10.143:1433;" +  //134.1
48.10.143 is the ip of sql server
                "DatabaseName=ReUnion;user=zg;password=zg");
            }
            catch(Exception e){
                System.out.println("connect error");
                System.out.println(e);
            }
            return conn;
            }       
   public ResultSet getResult(){
        try{
            Connection conn = connect();
            Statement stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM reunion");
        }
        catch(Exception e){
            System.out.println("result error");
            System.out.println(e);
            }
        return rs;
    }
}
--
�� ��Դ:���Ұ��Ͽ�վ bbs.nankai.edu.cn��[FROM: 134.148.10.143]