test7.java

来自「struts+hibernate BBS mysql数据库 功能基本齐全」· Java 代码 · 共 29 行

package com.elan.forum.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.elan.db.ElHbnDB;

public class Test7 {
	public static void main(String [] args) throws Exception{
		//Session session = ElHbnDB.getSession();
		Class.forName("com.mysql.jdbc.Driver");
		String dbPath = "jdbc:mysql://localhost:3306/elannet";
		Connection conn = DriverManager.getConnection(dbPath, "root", "root");
		String  sql =  "select * from forumtopicreply";
		PreparedStatement pStmt = conn.prepareStatement(sql);
		ResultSet rs = pStmt.executeQuery(sql);
		rs.next();
		if(null != rs) {
			System.out.println(rs.getString("author"));
		}
		pStmt.execute();
		rs.close();
		pStmt.close();
		conn.close();
	}
}