Á¬½ÓMySQLʱ³öÁËÎÊÌâ
ÎÒÊÇÓÃEclipseдµÄ£¬Çý¶¯ÒѾÕýÈ·µ¼ÈëÁË£¬ÎÒnewÁËÒ»¸öclassÎļþ¿ÉÒÔÕý³£ÔËÐÐ,µ«newÁËjspÎļþºó°Ñ¸Õ²ÅÄǸö¿ÉÒÔÔËÐеÄjavaÎļþÖеÄÊý¾Ý¿âÁ¬½Ó´úÂëcopy¹ýÀ´ºóÈ´ÔÚClass.forName("com.mysql.jdbc.Driver").newInstance();´¦±¨´í£¬²»ÖªµÀΪʲô£¬Ï£Íû¸÷λǰ±²¶à¶àÖ¸½Ì£¡
javaÎļþ´úÂëÈçÏ£º
import java.sql.*;
public class testMysql {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
ex.printStackTrace();
}
Connection conn =null;
Statement stmt = null;
ResultSet rs = null;
String name = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=");
stmt=conn.createStatement();
String sql = "select * from tb_user";
rs = stmt.executeQuery(sql);
if(rs.next()){
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
bas_car ±í ÓÐÁÐcarname £¬Òª½øÐÐÊý¾Ýͳ¼Æ£¬
select count(a.carname),a.carname from bas_car a,bas_car b where a.carid>=b.carid and a.carname=b.carname
group by a.carname
ÈçÉϲéѯ½á ......