会的朋友请进来!问题解决大量散分。 网上有四种连接,不过现在没有给出例子,自己search下! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 告诉你我的MSN:[email protected] http://www.csdn.net/expert/topic/670/670716.xml?temp=.3571741 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 关于正则判断是否有表单元素,需要您的帮助 TOMCAT配置数据源有段话不明白---求教 新手学JAVA时碰到的问题:java.lang.NoSuchMethodError: main请各位好心大侠帮忙! 高手请进 java中的content-type是什么 求各JAVA前辈的建议!! Java怎样才能够完整的读出包含有汉字的文本文件 jdbc的小问题?大力散分了。 请教一个调用WINDOWS的telnet程序的问题? 希望大家讨论!希望大家畅所欲言! 我连上了 Oracle。可怎么不能取出数据????郁闷,求救!!!!!! 如何在客户端了解服务器程序里的id号
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