62,614
社区成员
发帖
与我相关
我的任务
分享
package net.icefish.bean;
import java.sql.*;
public class Conn{
//public Connection conn=null;
public static Connection Connection(){
//public conn(){
Connection conn=null;
try{
// request.setCharacterEncoding("gb2312");
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(Exception e){
System.out.print(e.toString());
}
try{
String url="jdbc:mysql://127.0.0.1:3306/icefish?useUnicode=true&characterEncoding=gb2312"; //数据库名统一为icefish,表名与字段名参照概要设计文档
String user="root"; //设置用户名
String password="root"; //设置密码
conn=DriverManager.getConnection(url,user,password);
}
catch(SQLException e){
System.out.print(e.toString());
}
return conn;
}
// public void close(){
// try{
// conn.close();
// }
// catch(SQLException e){
// System.out.print(e.toString());
// }
// }
}
package net.icefish.bean;
import java.sql.*;
import net.icefish.bean.Conn;
public class test{
public static void main(String[] args){
try{
Connection icefish=Conn.connection();
Statement stmt=icefish.createStatement();
ResultSet rs=stmt.executeQuery("select * from icefish_admin");
while(rs.next())
System.out.print(rs.getString(1)+" ");
icefish.close();
}catch(SQLException e){
System.out.print(e.toString());
}
}
}