eclipse连接MYSQL问题

阳光明媚就出去走走 2013-06-03 11:52:19

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;

class query{
Scanner reader=new Scanner(System.in);
Connection conn;
java.sql.PreparedStatement sql;
static{
try {
System.out.println("加载数据库驱动程序");
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void select(){
String sno;
System.out.println("请输入要查询的学生的学号：");
sno=reader.next();
String URL = "jdbc:mysql://127.0.0.1:3306/lqz";
String USERNAME = "root";
String PASSWORD = "";
ResultSet rs;
//Connection conn = null;
try {
conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
sql=conn.prepareStatement("select * from student where sno=?");
sql.setString(1, sno);
rs=sql.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1)+'\t'+rs.getString(2)+'\t'+rs.getString(3));
}
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
}
public class first {

/**
* @param args
*/
public static void main(final String[] args) {
// TODO Auto-generated method stub
query qr=new query();
qr.select();
}

}
以下是运行结果：
<ConnectionProperties>
<PropertyCategory name="Connection/Authentication">
<Property name="user" required="No" default="" sortOrder="-2147483647" since="all versions">
The user to connect as
</Property>
<Property name="password" required="No" default="" sortOrder="-2147483646" since="all versions">
The password to use when connecting
</Property>
<Property name="socketFactory" required="No" default="com.mysql.jdbc.StandardSocketFactory" sortOrder="4" since="3.0.3">
The name of the class that the driver should use for creating socket connections to the server. This class must implement the interface 'com.mysql.jdbc.SocketFactory' and have public no-args constructor.
</Property>
<Property name="connectTimeout" required="No" default="0" sortOrder="9" since="3.0.1">
Timeout for socket connect (in milliseconds), with 0 being no timeout. Only works on JDK-1.4 or newer. Defaults to '0'.
</Property>
<Property name="socketTimeout" required="No" default="0" sortOrder="10" since="3.0.1">
Timeout on network socket operations (0, the default means no timeout).
[color=#FF0000]求哪位好心人帮忙解决，不胜感激！本人一点点都不知道运行结果是什么意思！[/color]

...全文