myeclipse mysql 未读消息_我用myEclipse连接mysql数据库查询，为什么结果集什么都不显示，新手。。。...

packageconnDB;importjava.sql.*;importjava.text.SimpleDateFormat;importjava.util.Date;publicclassconnect{//StringgetName="com.microsoft.jdbc.sqlserver.SQLSercerDriver";//S...

package connDB;

import java.sql.*;

import java.text.SimpleDateFormat;

import java.util.Date;

public class connect {

//String getName="com.microsoft.jdbc.sqlserver.SQLSercerDriver";

//String getUrl="jdbc.microsoft.sqlserver://localhost:1433;DatabaseName=dbName";

public static String driver=("com.mysql.jdbc.Driver");

public static String url="jdbc:mysql://localhost:3306/user";

public static String user="sa";

public static String password="jiahuime";

Connection conn=null;

Statement stat=null;

public void con(){

try{

Class.forName(driver);

conn=DriverManager.getConnection(url,"root","jiahuime");

stat=conn.createStatement();

}

catch(Exception e){

e.printStackTrace();

}

//System.out.println(conn);

try{

conn.close();

}

catch(SQLException se){

se.printStackTrace();

}

}

public String select(String s){

String str=null;

String sql="select * from userinfo";

try{

ResultSet rs=stat.executeQuery(sql);

while(rs.next()){

String name=rs.getString(1);

//String date=rs.getString(2);

//str=(str+rs.getString(1)+rs.getString(2));

System.out.println("jieguo"+name);

}

}

catch(SQLException se){

se.printStackTrace();}

return str;

}

public static void main(String args[]){

//Date date=new Date();

//String sql="insert into userinfo values(null,'123','"+date+"')";

}

}

展开