javaee.zip

package javabean;

import java.sql.*;
public class DBConn {
	private Connection conn=null;
	 private String driverurlusernamepassword;
	 String connectionUrl =“jdbc:mysql://localhost:3306;databaseName=test;user=root;password=meng2313011;“;
	 public DBConn（）{
	  this.driver=“com.mysql.jdbc.Driver“;
	  this.url=“jdbc:mysql://127.0.0.1:3306/test“;
	  this.username=“root“;
	  this.password=“meng2313011“;
	  try {
	   Class.forName（driver）;
	   conn=DriverManager.getConnection（urlusernamepassword）;
	  } catch （ClassNotFoundException e） {
	   System.out.println（“不能加载数据库驱动。“）;
	   e.printStackTrace（）;
	  } catch （SQLException e） {
	   System.out.println（“不能建立数据库连接。“）;
	   e.printStackTrace（）;
	  } 
	 }
	 
	 public boolean update（int idString usernameString password
	            String realnameString sexString email）{
	  boolean temp=false;
	  PreparedStatement stmt=null;
	  String sql=“update reginfor “ +
	       “set username=?password=?realname=?“ +
	       “sex=?email=? where id=?“;
	  try {
	   stmt=conn.prepareStatement（sql）;
	   stmt.setString（1username）;
	   stmt.setString（2password）;
	   stmt.setString（3realname）;
	   stmt.setString（4sex）;
	   stmt.setString（5email）;   
	   stmt.setInt（6id）;
	   stmt.execute（）;
	   temp=true;
	  } catch （SQLException e） {
	   System.out.println（“更新异常．“）;
	   e.printStackTrace（）;
	  }
	  return temp;
	 }
	 
	 public static void print（ResultSet rs）{
	  System.out.print（“ID“+“	“）;
	  System.out.print（“用户名“+“	“）;
	  System.out.print（“密　码“+“	“）;
	  System.out.print（“姓　名“+“	“）;
	  System.out.print（“性　别“+“	“）;
	  System.out.println（“邮　箱“+“	“）;
	  try {
	   while（rs.next（））{
	    System.out.print（rs.getString（“id“）+“	“）;
	    System.out.print（rs.getString（“username“）+“	“）;
	    System.out.print（rs.getString（“password“）+“	“）;
	    System.out.print（rs.getString（“realname“）+“	“）;
	    System.out.print（rs.getString（“sex“）+“	“）;
	    System.out.println（rs.getString（“email“）+“	“）;
	   }
	  } catch （SQLException e） {
	   System.out.println（“输出异常．“）;
	   e.printStackTrace（）;
	  }
	 }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2020-05-07 20:16  javaee
     文件        1032  2019-10-16 18:00  javaee.classpath
     文件         906  2019-10-02 11:52  javaee.project
     目录           0  2020-05-07 20:16  javaee.settings
     文件         567  2019-10-02 11:52  javaee.settings.jsdtscope
     文件         358  2019-10-02 11:52  javaee.settingsorg.eclipse.jdt.core.prefs
     文件         470  2019-10-02 11:52  javaee.settingsorg.eclipse.wst.common.component
     文件         303  2019-10-02 11:52  javaee.settingsorg.eclipse.wst.common.project.facet.core.xml
     文件          49  2019-10-02 11:52  javaee.settingsorg.eclipse.wst.jsdt.ui.superType.container
     文件           6  2019-10-02 11:52  javaee.settingsorg.eclipse.wst.jsdt.ui.superType.name
     目录           0  2020-05-07 20:16  javaeeuild
     目录           0  2020-05-07 20:16  javaeeuildclasses
     目录           0  2020-05-07 20:16  javaeeuildclassesjavabean
     文件        3354  2019-12-19 22:06  javaeeuildclassesjavabeanDBConn.class
     文件         267  2019-12-19 22:06  javaeeuildclassesjavabeanDBHelper.class
     目录           0  2020-05-07 20:16  javaeelayui
     目录           0  2020-05-07 20:16  javaeelayuicss
     文件       69524  2019-10-02 14:31  javaeelayuicsslayui.css
     文件        9885  2019-10-02 14:31  javaeelayuicsslayui.mobile.css
     目录           0  2020-05-07 20:16  javaeelayuicssmodules
     文件        1063  2019-10-02 14:31  javaeelayuicssmodulescode.css
     目录           0  2020-05-07 20:16  javaeelayuicssmoduleslaydate
     目录           0  2020-05-07 20:16  javaeelayuicssmoduleslaydatedefault
     文件        7537  2019-10-02 14:31  javaeelayuicssmoduleslaydatedefaultlaydate.css
     目录           0  2020-05-07 20:16  javaeelayuicssmoduleslayer
     目录           0  2020-05-07 20:16  javaeelayuicssmoduleslayerdefault
     文件        5911  2019-10-02 14:31  javaeelayuicssmoduleslayerdefaulticon-ext.png
     文件       11493  2019-10-02 14:31  javaeelayuicssmoduleslayerdefaulticon.png
     文件       14425  2019-10-02 14:31  javaeelayuicssmoduleslayerdefaultlayer.css
     文件        5793  2019-10-02 14:31  javaeelayuicssmoduleslayerdefaultloading-0.gif
     文件         701  2019-10-02 14:31  javaeelayuicssmoduleslayerdefaultloading-1.gif
............此处省略193个文件信息