package dchl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Session;
import com.leadlt.cms.entity.main.WpDc;
import com.leadlt.common.hibernate3.Finder;
import com.leadlt.common.hibernate3.HibernateBaseDao;
import com.mysql.jdbc.DatabaseMetaData;
public class Test extends HibernateBaseDao<WpDc, Integer>{
private static Session session;
public static void main(String[] args) throws Exception, Exception, Exception{
Connection con=null;
Statement st=null;
ResultSet rs=null;
/**
* 要执行的内容
* lixx
*/
try {
// 获得MySQL驱动的实例
Class.forName("com.mysql.jdbc.Driver").newInstance();
// 获得连接对象(提供:地址,用户名,密码)
con = DriverManager.getConnection("jdbc:mysql://192.168.1.139/parking","root", "leadlt213");
if (!con.isClosed())
System.out.println("Successfully connected ");
else
System.out.println("failed connected");
//建立一个Statement,数据库对象
st = con.createStatement();
// 运行SQL查询语句
rs = st.executeQuery("select * from jc_dc;");
// 读取结果集
while (rs.next()) {
System.out.println("id:"+rs.getInt(1));
System.out.println("parksysnum:"+rs.getString(2));
System.out.println("name:"+rs.getString(3));
System.out.println("dc_num:"+rs.getString(4));
System.out.println("dc_status:"+rs.getString(4));
}
// 关闭链接
con.close();
run();
} catch (InterruptedException e) {
// TODO Auto-generated catch block
System.err.println("Exception: " + e.getMessage());
e.printStackTrace();
}
}
/**
* 记时器
* lixx
*/
public static void run() throws InterruptedException {
int index = 0; // 开始
final int count = 3; // 结束
do {
} while (index < count);
}
@Override
protected Class<WpDc> getEntityClass() {
// TODO Auto-generated method stub
return WpDc.class;
}
}
原文:http://www.cnblogs.com/xinxin1994/p/5261313.html