ＪＤＢＣ要怎么设置才能和ＭＹＳＱＬ数据库连接？？

daikin 2004-05-13 07:43:16

ＪＤＢＣ要怎么设置才能和ＭＹＳＱＬ数据库连接？

...全文

99 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

daikin 2004-05-13

打赏
举报

驱动程序怎么安装．CLASSPATH怎么设置???

away5678 2004-05-13

打赏
举报

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

String url ="jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"

前提是你有JDBC驱动....

rockaka 2004-05-13

打赏
举报

http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html

liyong33 2004-05-13

打赏
举报

//@author:Andy
//@version:1.0
//function:query data from databse coffeebreak,TABLE COFFEES
import java.sql.*;
public class Query
{
public static void main(String [] args)
{
String url = "jdbc:mysql://localhost/coffeebreak";
Connection con;
Statement stmt;
String qu = "select COF_NAME, PRICE from coffees where PRICE<9.0";
try
{
Class.forName("com.mysql.jdbc.Driver");//看起来虽然不顺眼，但是可以支持中文
}
catch(ClassNotFoundException e)
{
System.err.println("Class Not Found!");
System.err.println("e.getMessage()");

}
try
{
con = DriverManager.getConnection(url,"root","");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(qu);
System.out.println("Coffee Break Coffees and Prices:");
while(rs.next())
{
String name = rs.getString("COF_NAME");
float price = rs.getFloat("PRICE");
System.out.println("Coffee Name: "+name+" Price: "+price);
}

}
catch(SQLException e)
{
System.err.println("SQLException:"+e.getMessage());
}
}
}

daikin 2004-05-13