import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mysql {
/**
* @param args
*/
private static Connection conn;
private static String driver="com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/mysql";
private static String user="root";
private static String pass="root";
public static Connection getConnection(){
try {
Class.forName(driver);
conn= DriverManager.getConnection(url,user,pass);
Statement st=conn.createStatement();
ResultSet rs=st.executeQuery("select * from stu");
while (rs.next()) {
System.out.println(rs.getInt(1)+rs.getString(2));
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if (conn!=null) {
System.out.println("数据库连接成功!!!!");
}
else {
System.out.println("数据库连接失败!!!");
}
return conn;
}
public static void main(String[] args) {
conn=mysql.getConnection();
}
}