67,513
社区成员
发帖
与我相关
我的任务
分享
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class MyTest{
private static String drive = "org.gjt.mm.mysql.Driver";// 这里是驱动字符 串
private static String url = "jdbc:mysql://localhost:3306/a";// 这里是连接地址
private static Connection conn=null;
/**
* 得到数据库连接
*
* @return Connection
*/
public Connection getconn() {
try {
// 加载驱动
Class.forName(drive);
conn = DriverManager.getConnection(url, "root", "root");
} catch (ClassNotFoundException e) {
System.out.println(e.getMessage());
} catch (SQLException e) {
System.out.println(e.getMessage());
}
return conn;
}
public void test() {
this.conn=getconn();
if(conn==null){
System.out.println("数据库连接失败");
}
try {
String sql ="你的SQL语句";
int i = 1;
Statement state = conn.createStatement();//创建一个 Statement 对象来将 SQL 语句发送到数据库。
ResultSet rs = state.executeQuery(sql);//执行给定的 SQL 语句,该语句返回单个 ResultSet 对象
while (rs.next()) {
i++;
System.out.println("第" + i + "行记录");
System.out.println("你的字段:" + rs.getString(1));
System.out.println("你的字段:" + rs.getString(1));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
MyTest test= new MyTest();
test.test();
}
}
<%="用户的id为:"+rs.getString("id") + ", 姓名为:"+ rs.getString("name") +",时间为: " + rs.getString("datetime")%>