会的朋友请进来！问题解决大量散分。

Question

网上有四种连接，不过现在没有给出例子，自己search下！

Answer 1

告诉你我的MSN：[email protected]

Answer 2

http://www.csdn.net/expert/topic/670/670716.xml?temp=.3571741

Answer 3

import java.sql.*;
import java.util.Properties;public class jdbcTest
{        public static void main(String [] args)
        {                //load driver class
///                      String driverName="sun.jdbc.odbc.JdbcOdbcDriver";
//                        String sourceURL="jdbc:odbc:User";//                       String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//                       String sourceURL="jdbc:microsoft:sqlserver://localhost:1433;Datebase=User" ;//String driverName ="weblogic.jdbc.mssqlserver4.Driver";
//String sourceURL = "jdbc:weblogic:mssqlserver4:usercenter@localhost:1433";
    String driverName =    "org.gjt.mm.mysql.Driver";
    String sourceURL =     "jdbc:mysql://cgc_game2.netfun.com:3306/netfundb_ch?user=cgc&password=cgc";    try{
      Driver mysqlDriver = (Driver)Class.forName(driverName).newInstance();      Connection conn = DriverManager.getConnection(sourceURL);
      System.out.println("Succeeed to connect to:" + sourceURL );
    }catch(Exception e){
      System.err.println("Mysql err occured:" + e.getMessage());
    }
                try
                {                        Class.forName(driverName);
                        Properties prop = new Properties();
                        prop.setProperty("user","sa") ;
                        prop.setProperty("password","pwd");                        //define the data source for chiver
// String sourceURL="jdbc:odbc:test";                        //create connection through the DriverManager
                       // Connection databaseConnection=DriverManager.getConnection(sourceURL);
                        Connection databaseConnection=DriverManager.getConnection(sourceURL,prop);
                        //databaseConnection.setCatalog("User");
                        System.out.println("Succeed to connect to database!!!");
                        System.out.println("The Driver is:" + driverName + " and \nthe URL is:" + sourceURL);
                        Statement statement=databaseConnection.createStatement();
                        String sLoginName;
                        String sPassword = "123456";
                        sLoginName = "aben";
                        ResultSet rsPlayer = statement.executeQuery("select * from AllUser where LoginName = '" + sLoginName + "' and Password = '" + sPassword + "'");
                       // ResultSet rsPlayer = statement.executeQuery("select max(netid) as latest, userid, name from member where active = 'A' or (active = 'U' and exp_date > now()) group by userid");
                        ResultSetMetaData metaData = rsPlayer.getMetaData();
                        System.out.println("Get Data!");
                        String sUid;
                      if( rsPlayer.next()) {
                          sUid = rsPlayer.getString(1);
                          sUid = "UID is : " + sUid;
                          System.out.println(sUid);
                      }
                      else{
                        System.out.println("User Not Found!");
                      }
/*                        ResultSet authorNames=statement.executeQuery(
                                "SELECT au_lname,au_fname FROM pubs.dbo.authors ORDER BY au_lname DESC,au_fname DESC");
                        ResultSetMetaData metaData=authorNames.getMetaData();
                        int columns=metaData.getColumnCount();
                        System.out.println("columns="+columns);                        int row=0;
                        while (authorNames.next())
                        {
                                System.out.print("\nRow"+(++row)+":");                                for (int i=1;i<=columns;i++)
                                        if (metaData.getColumnType(i)==Types.VARCHAR) //if it is char
                                                System.out.print(" "+authorNames.getString(i));
                        }
*/
                }
                catch (ClassNotFoundException cnfe)
                {
                        System.err.println(cnfe);
                }                catch (SQLException sqle)
                {
                        System.err.println(sqle);
                }
        }
}有点乱，不过我都是调试过了的，OK