javawe项目简单连接mysql

末蓝、 2023-06-05 11:19 3阅读 0赞

1.创建javaweb项目 JavaWebMySql  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70]  
2.把mysql-connector-java-5.1.7-bin.jar在lib下

3.在src创建com.xf.Test包,在该包下创建MysqlTest和User类

MysqlTest.java

package com.xf.Test;
    
    import java.sql.*;
    import java.util.ArrayList;
    
    public class MysqlTesst { 
    	
    	//驱动名称
        private static final String driverName="com.mysql.jdbc.Driver";
        //数据库的地址(通过端口和SID找到对应的数据库)
        private static final String URL="jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
        //数据库登录用户名
        private static final String userName="root"; 
        //数据库登录密码
        private static final String pwd="123456";
        
        
        public void getConnection() { 
        	// 创建一个数据库连接
    	    Connection connection = null;
    	    // 创建预编译语句对象
    	    PreparedStatement pstat = null;
    	    // 创建结果集对象
    	    ResultSet rs = null;
    	    
    	    ArrayList<User> list = new ArrayList<User>();
            try { 
                //加载oracle驱动
                Class.forName(driverName);
                //通过驱动获取数据库的连接
                connection = DriverManager.getConnection(URL,userName,pwd);
                //下面是查询操作
                String sql = "select * from user";
                pstat = connection.prepareStatement(sql);
                rs = pstat.executeQuery();
                while (rs.next()) { 
                    User item = new User();
                    item.setAge(rs.getInt("age"));
                    item.setName(rs.getString("name"));
                    item.setId(rs.getInt("id"));
                    list.add(item);
                    
                    System.out.println(rs.getInt("age")+rs.getString("name"));
                }
                System.out.println("连接成功");
            } catch (Exception e) { 
            	System.out.println("连接失败");
                e.printStackTrace();
            }
        }
        
    
    	public static void main(String[] args) { 
    		
    		MysqlTesst mysqlTesst=new MysqlTesst();
    		mysqlTesst.getConnection();
    	}
    }

User.java

package com.xf.Test;
    
    public class User { 
    	private int id;
    	private String name;
    	private int age;
    	
    	public int getId() { 
    	    return id;
    	}
    	public void setId(int id) { 
    	    this.id = id;
    	}
    	public String getName() { 
    	    return name;
    	}
    	public void setName(String name) { 
    	    this.name = name;
    	}
    	public int getAge() { 
    	    return age;
    	}
    	public void setAge(int age) { 
    	    this.age = age;
    	}
    }

4.创建数据库jdbc和User表，如下

![在这里插入图片描述][20191008233140637.png]

6.运行方式：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 1]

参考资料：[https://blog.csdn.net/williamchew/article/details/51951551][https_blog.csdn.net_williamchew_article_details_51951551]

[https://blog.csdn.net/wcc27857285/article/details/82287205][https_blog.csdn.net_wcc27857285_article_details_82287205]

[https://blog.csdn.net/weixin\_42950079/article/details/86706989][https_blog.csdn.net_weixin_42950079_article_details_86706989]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70]: /images/20230601/667d3c93efc34080b33c87b28e25e001.png
[20191008233140637.png]: /images/20230601/676b7506723544559a152c73f790ddef.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mjg0NzYyNg_size_16_color_FFFFFF_t_70 1]: /images/20230601/87d6e656ce7d49dbb59e333d94f2b3d6.png
[https_blog.csdn.net_williamchew_article_details_51951551]: https://blog.csdn.net/williamchew/article/details/51951551
[https_blog.csdn.net_wcc27857285_article_details_82287205]: https://blog.csdn.net/wcc27857285/article/details/82287205
[https_blog.csdn.net_weixin_42950079_article_details_86706989]: https://blog.csdn.net/weixin_42950079/article/details/86706989