java/jsp等连接MYSQL数据库

最新推荐文章于 2023-01-06 22:06:44 发布

布吉

最新推荐文章于 2023-01-06 22:06:44 发布

阅读量273

点赞数

CC 4.0 BY-SA版权

分类专栏： MYSQL 文章标签： MYSQL

本文链接：https://blog.youkuaiyun.com/fighting_0808/article/details/84932916

MYSQL 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍如何在Java中使用JDBC连接MySQL数据库，包括创建数据库连接、执行查询和处理结果集的过程。同时，提供了具体的代码示例，展示了如何进行精确查询和模糊查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

将文件

https://download.youkuaiyun.com/download/fighting_0808/10839026

如果是java文件，则新建一个文件把数据库连接包夹放在里面，然后点击这个链接文件右击build path---->Add to build path会产生一个导入包，添加成功。

DBMS.java

package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBMS {	
	 static String url =null;
	 public  static Connection connection() {
		 Connection con = null;
	//驱动程序名	 
	String driver = "com.mysql.jdbc.Driver";
	//URL指向要访问的数据库名myfriend
	 String url = "jdbc:mysql://localhost:3306/myfriend"; 
     //MySQL配置时的用户名
     String user = "root";
      //MySQL配置时的密码
      String password = "123456";
      try {
		Class.forName(driver);
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	}
       
		try {
				con = DriverManager.getConnection(url,user,password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
        
		return con;
	 }
	}

链接文件

数据库操作

查询

Connection con=DBMS.connection();

Statement stat1= con.createStatement();

String sql="select myfriend.userid,myfriend.name,myfriend.sex,myfriend.age,myfriend.qq,myfriend.telephone,myfriend.email,myfriend.address from user,myfriend where myfriend.userid=user.userid and user.name='"+name1+"'";

ResultSet rs= stat1.executeQuery(sql);
           while(rs.next())
              {
               out.print("<tr>");
               out.print("<td align=center>"+"<input type='radio' name='update'>"+"</td>");
               out.print("<td align=center>"+"<input type='checkbox' name='delete'>"+"</td>");
               out.print("<td align=center>"+rs.getInt("userid")+"</td>");
               out.print("<td align=center>"+rs.getString("name")+"</td>");
               out.print("<td align=center>"+rs.getString("sex")+"</td>");
               out.print("<td align=center>"+rs.getInt("age")+"</td>");
               out.print("<td align=center>"+rs.getString("qq")+"</td>");
               out.print("<td align=center>"+rs.getString("telephone")+"</td>");
               out.print("<td align=center>"+rs.getString("email")+"</td>");
               out.print("<td align=center>"+rs.getString("address")+"</td>");
               out.print("</tr align=center>");
              }
          rs.close();
           con.close();
        }

模糊查询

      Statement stat2= con.createStatement();
      String sql2="select myfriend.userid,myfriend.name,myfriend.sex,myfriend.age,myfriend.qq,myfriend.telephone,myfriend.email,myfriend.address from user,myfriend where myfriend.userid=user.userid and user.name='"+name1+"' and myfriend.name like '"+select+"%'";
      ResultSet rs1= stat2.executeQuery(sql2);
      while(rs1.next())
      {
       out.print("<tr>");
       out.print("<td align=center>"+"<input type='radio' name='update'>"+"</td>");
       out.print("<td align=center>"+"<input type='checkbox' name='delete'>"+"</td>");
       out.print("<td align=center>"+rs1.getInt("userid")+"</td>");
        out.print("<td align=center>"+rs1.getString("name")+"</td>");
       out.print("<td align=center>"+rs1.getString("sex")+"</td>");
       out.print("<td align=center>"+rs1.getInt("age")+"</td>");
       out.print("<td align=center>"+rs1.getString("qq")+"</td>");
       out.print("<td align=center>"+rs1.getString("telephone")+"</td>");
       out.print("<td align=center>"+rs1.getString("email")+"</td>");
       out.print("<td align=center>"+rs1.getString("address")+"</td>");
       out.print("</tr align=center>");
       }
       rs1.close();
       con.close();
       }