Java连接数据库

Java连接数据库

xiaohu

2024 年 11 月 04 日

266 次浏览

暂无评论

2523字数

### StuDAO
```java
package com.svse.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Scanner;

import com.svse.entity.StuEntity;

public class StuDAO {
	
	public static void main(String[] args) {
		Scanner sa=new Scanner(System.in);
		System.out.println("请输入学号：");
		int sid=sa.nextInt();
		System.out.println("请输入姓名：");
        String sname=sa.next();
        System.out.println("请输入性别：");
        String ssex=sa.next();
        System.out.println("请输入年龄：");
        int sage=sa.nextInt();
        System.out.println("请输入电话：");
        String stel=sa.next();
        //组装起来--放到实体类中
        StuEntity stu=new StuEntity();
        stu.setSid(sid);
        stu.setSname(sname);
        stu.setSsex(ssex);
        stu.setSage(sage);
        stu.setStel(stel);
        //连接数据库
        String driver="com.mysql.jdbc.Driver";
        String url="jdbc:mysql://localhost:3306/test";
        String user="root";
        String password="root";
        
        Connection conn=null;
        //注册并得到数据库的连接
        try {
			Class.forName(driver);
			conn=DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			e.printStackTrace();
		}
        //调用增加方法
        try {
        	String sql="insert into stuinfo values(?,?,?,?,?)";
            PreparedStatement pre=conn.prepareStatement(sql);
            pre.setInt(1, stu.getSid());
            pre.setString(2, stu.getSname());
            pre.setString(3,stu.getSsex());
            pre.setInt(4,stu.getSage());
            pre.setString(5,stu.getStel());
            //提交
            pre.executeUpdate();
            
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

```

### stuEntity 
```java
package com.xiaohu.entity;

public class stuEntity {
	private int sid;
	private String sname;
	private String ssex;
	private int sage;
	private String stel;
	public int getSid() {
		return sid;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public String getSsex() {
		return ssex;
	}
	public void setSsex(String ssex) {
		this.ssex = ssex;
	}
	public int getSage() {
		return sage;
	}
	public void setSage(int sage) {
		this.sage = sage;
	}
	public String getStel() {
		return stel;
	}
	public void setStel(String stel) {
		this.stel = stel;
	}
	
}

```

Java连接数据库