spring练习1

news/2024/11/9 2:37:10/

1、练习网站案例

1、建好相应的java类

package spring;public class Player {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 String getPosition() {return position;}public void setPosition(String position) {this.position = position;}private int id;private String name;private String position;
}

2、准备好xml文件配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.0.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.0.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.0.xsdhttp://www.springframework.org/schema/context     http://www.springframework.org/schema/context/spring-context-3.0.xsd"><bean name="" class="spring.Player"><property name="name" value="niko" /><property name="position" value="步枪手" /></bean></beans>

3、准备好测试类

package text;import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;import spring.Player;public class Test {public static void main(String[] args) {ApplicationContext context = new ClassPathXmlApplicationContext(new String[] { "applicationContext.xml" });Player c = (Player) context.getBean("s");System.out.println(c.getName() + " " + c.getPosition());}
}

没问题：

 1、来个队伍类

public class Team {private String teamname;private String game;public String getTeamname() {return teamname;}public void setTeamname(String teamname) {this.teamname = teamname;}public String getGame() {return game;}public void setGame(String game) {this.game = game;}
}

 2、配置文件作出相应修改，写一个能创建Team类的bean并在创建Player类的bean中调动他

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.0.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.0.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.0.xsdhttp://www.springframework.org/schema/context     http://www.springframework.org/schema/context/spring-context-3.0.xsd"><bean name="s" class="spring.Player"><property name="name" value="niko" /><property name="position" value="步枪手" /><property name="team" ref="t" /></bean><bean name="t" class="spring.Team"><property name="teamname" value="G2" /><property name="game" value="csgo" /></bean></beans>

3、测试类

package text;import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;import spring.Player;public class Test {public static void main(String[] args) {ApplicationContext context = new ClassPathXmlApplicationContext(new String[] { "applicationContext.xml" });Player c = (Player) context.getBean("s");System.out.println(c.getName() + " " + c.getPosition() + " " + c.getTeam().getTeamname() + " " + c.getTeam().getGame());}
}

没问题

 1、修改配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.0.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.0.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.0.xsdhttp://www.springframework.org/schema/context     http://www.springframework.org/schema/context/spring-context-3.0.xsd"><context:annotation-config/><bean name="s" class="spring.Player"><property name="name" value="niko" /><property name="position" value="步枪手" /></bean><bean name="t" class="spring.Team"><property name="teamname" value="G2" /><property name="game" value="csgo" /></bean></beans>

2、为player加上注解

package spring;import org.springframework.beans.factory.annotation.Autowired;public class Player {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 String getPosition() {return position;}public void setPosition(String position) {this.position = position;}private int id;private String name;private String position;public Team getTeam() {return team;}public void setTeam(Team team) {this.team = team;}@Autowiredprivate Team team;
}

 没问题

 试试对bean的注解：

1、修改xml，注意这里指个包名就可以了，不要指明类名

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.0.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.0.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.0.xsdhttp://www.springframework.org/schema/context     http://www.springframework.org/schema/context/spring-context-3.0.xsd"><context:component-scan base-package="spring"/></beans>

 2、添加相关注释

package spring;import org.springframework.stereotype.Component;@Component("T")
public class Team {private String teamname = "navi";private String game = "csgo";public String getTeamname() {return teamname;}public void setTeamname(String teamname) {this.teamname = teamname;}public String getGame() {return game;}public void setGame(String game) {this.game = game;}
}
package spring;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;@Component("P")
public class Player {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 String getPosition() {return position;}public void setPosition(String position) {this.position = position;}private int id;private String name = "s1mple";private String position = "狙击手";public Team getTeam() {return team;}public void setTeam(Team team) {this.team = team;}@Autowiredprivate Team team;
}

 没毛病：

2、教材练习 

setter注入之前已经用过，现在试试构造器注入

1、给team类加个带参构造方法

package spring;import org.springframework.stereotype.Component;public class Team {private String teamname;private String game;public Team(String teamname ,String game){this.teamname = teamname;this.game = game;}public String getTeamname() {return teamname;}public void setTeamname(String teamname) {this.teamname = teamname;}public String getGame() {return game;}public void setGame(String game) {this.game = game;}
}

 2、创建相应xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:context="http://www.springframework.org/schema/context"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.0.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-3.0.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.0.xsdhttp://www.springframework.org/schema/context     http://www.springframework.org/schema/context/spring-context-3.0.xsd"><bean name="t" class="spring.Team"><constructor-arg><value>faze</value></constructor-arg><constructor-arg><value>csgo</value></constructor-arg></bean></beans>

3、测试类

package text;import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;import spring.Player;
import spring.Team;public class Test {public static void main(String[] args) {ApplicationContext context = new ClassPathXmlApplicationContext(new String[] { "applicationContext.xml" });Team c = (Team) context.getBean("t");System.out.println(c.getTeamname() + " " + c.getGame());}
}

 没毛病

接下来我们试试教材dao模式操作

 1、类还是用我们之前的Player类

package spring;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;public class Player {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 String getPosition() {return position;}public void setPosition(String position) {this.position = position;}private int id;private String name;private String position;}

 2、来一个接口，这个接口可以不止抽象定义一种方法，后面可以按照需求定义多个方法，在这里只是尝试一个方法。

package impl;import spring.Player;public interface Playerdaoimpl {public void inserplayer(Player p);
}

3、定义一个dao类。这里用到了try。。。finally异常处理方法，这种方式简单来说就是尝试try中的代码，不管是否成功，最终都要执行finally中的代码

package dao;import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;import javax.sql.DataSource;import impl.Playerdaoimpl;
import spring.Player;public class Playerdao implements Playerdaoimpl{private DataSource dataSource;//注入DataSourcepublic DataSource getDataSource() {return dataSource;}public void setDataSource(DataSource dataSource) {this.dataSource = dataSource;}public void inserplayer(Player p){String name = p.getName();String position = p.getPosition();Connection conn = null;Statement stmt = null;try {conn = dataSource.getConnection();//获取数据库连接stmt = conn.createStatement();stmt.execute("insert into player (name,position) " + "values('"+name+"','" + position + "')");} catch (SQLException e) {e.printStackTrace();}finally {if(stmt != null) {try {stmt.close();//关闭Statement对象}   catch(SQLException e) {e.printStackTrace();}}if(conn != null) {try {conn.close();//关闭数据库连接}catch(SQLException e) {e.printStackTrace();}}}}
}

4、配置文件，注意对应好自己的数据库相关信息

<?xml version="1.0" encoding="UTF-8"?>
<beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"><!-- 配置数据源 --><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property><property name="url"><value>jdbc:mysql://localhost:3306/test</value></property><property name="username"><value>root</value></property><property name="password"><value>123456</value></property></bean><bean id="userDAO" class="com.mr.dao.UserDAO"><property name="dataSource"><ref local="dataSource"/></property></bean>
</beans>

 5、创建好相应的数据库

CREATE TABLE player (id INT NOT NULL AUTO_INCREMENT,name VARCHAR(50) NOT NULL,position VARCHAR(50),PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

6、创建测试类

package text;import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;import dao.Playerdao;
import spring.Player;public class Test {public static void main(String[] args) {ApplicationContext context = new ClassPathXmlApplicationContext(new String[] { "applicationContext.xml" });Player p = new Player("simple" ,"狙击手");Playerdao dao = (Playerdao) context.getBean("playerdao");dao.inserplayer(p);System.out.println("成功");}
}

报了个错，是字符编码问题

java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2412)at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4139)at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)at com.mysql.jdbc.Connection.<init>(Connection.java:1555)at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)at java.sql.DriverManager.getConnection(DriverManager.java:664)at java.sql.DriverManager.getConnection(DriverManager.java:208)at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:173)at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:164)at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)at dao.Playerdao.inserplayer(Playerdao.java:26)at text.Test.main(Test.java:15)

 我们修改xml文件中url为

<property name="url"><value>jdbc:mysql://localhost:3306/how2java?useUnicode=true&amp;characterEncoding=UTF-8</value></property>

再次运行，没问题

 最后用用JdbcTemple：

1、配置xml

<?xml version="1.0" encoding="UTF-8"?>
<beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"><!-- 配置数据源 --><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="url"><value>jdbc:mysql://localhost:3306/how2java?useUnicode=true&amp;characterEncoding=UTF-8</value></property><property name="username"><value>root</value></property><property name="password"><value>123456</value></property></bean><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource"><ref local="dataSource"/></property></bean>
</beans>

package text;import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;import dao.Playerdao;
import spring.Player;public class Test {public static void main(String[] args) {JdbcTemplate jtl = null;ApplicationContext factory = new ClassPathXmlApplicationContext("applicationContext.xml");//获取配置文件jtl =(JdbcTemplate)factory.getBean("jdbcTemplate");String sql = "insert into player(name,position) values ('niko' ,'步枪手')";jtl.update(sql);System.out.println("添加操作执行成功");}
}

没问题


http://www.ppmy.cn/news/85137.html

相关文章

Jmeter连接不同类型数据库语法

Jmeter连接不同类型数据库语法

Jmeter连接不同类型数据库语法 添加&#xff1a;配置原件->JDBC Connection Configuration variable name for created pool&#xff1a;自定义一个线程池变量名database Connection Configuration database URL: 填写数据库ip、端口、dbname等&#xff0c;但是不同数据库…
阅读更多...
分享50个AI绘画prompt的关键词，让你的AI绘画更贴近想法

分享50个AI绘画prompt的关键词，让你的AI绘画更贴近想法

我们在使用AI绘画工具时&#xff0c;最关键的就是prompt,但是我们不能总是拾人牙慧&#xff0c;总是用别人写出的现成的prompt,那样的话&#xff0c;最终画出来的画&#xff0c;也是别人画出来的&#xff0c;并不能完全生成自己想要的效果。所以&#xff0c;我们需要学习编写pr…
阅读更多...
20道python面试题，学python的你，快看一下，你会多少

20道python面试题，学python的你，快看一下，你会多少

请问Python中列表（list）和元组（tuple）的区别是什么？ 答：列表可变（mutable），而元组不可变（immutable）。这意味着创建元组后不能更改其值，而列表可以添加、删除和修改元素。PEP 8是什么？ 答：PEP 8是一组Python编程风格和最佳实践指南。其覆盖的主题包括命名规范、空…
阅读更多...
数据库+Python----------Python操作MySQL

数据库+Python----------Python操作MySQL

目录 1.在Python中安装pymysql 2.创建数据 1.连接数据库&#xff0c;创建一个数据库对象 2.开启游标功能&#xff0c;创建游标对象 3.发送指令 获取查询结果集的方法 4.实操 5.注意 不可以&#xff01;&#xff01;&#xff01; 正确写法 6.用户输入数据 3.查询数…
阅读更多...
kali安装ARL灯塔过程

kali安装ARL灯塔过程

&#xff08;一&#xff09;安装docker环境 1、检查是否存在docker环境 docker 2、如果没有docker&#xff0c;就先安装docker apt install docker.io 出现 unable to locate package docker.io这些&#xff0c;这是因为没有跟新 输入跟新命令&#xff1a; apt-get update 在…
阅读更多...
Hotbit交易平台停运，百万用户待清退，币圈危机再度蔓延

Hotbit交易平台停运，百万用户待清退，币圈危机再度蔓延

“币圈”的危机似乎还没有走到尽头。5月22日&#xff0c;加密货币交易平台Hotbit发文宣布&#xff0c;决定从世界标准时间当日4:00停止所有CEX&#xff08;中心化交易所&#xff09;操作&#xff0c;希望所有用户在6月21日4:00之前提取剩余资产。据悉&#xff0c;该平台在其任期…
阅读更多...
Netty服务如何使用Nginx代理转发请求并获得原始IP

Netty服务如何使用Nginx代理转发请求并获得原始IP

Nginx配置 Nginx启用stream模块&#xff0c;示例如下&#xff1a; stream {upstream netty{server remote:8080;}server {listen 8080;proxy_pass netty;proxy_protocol on;} }示例&#xff0c;代理远端8080的netty服务。 注意&#xff0c;获得原始客户端的IP关…
阅读更多...
【阿里云】文本转语音方言— 阿里云语音合成，文本转语音方言工具类

【阿里云】文本转语音方言— 阿里云语音合成，文本转语音方言工具类

目录 一、导入SDK坐标 二、文本转语音方言 —步骤和工具类 1.登录阿里云账号&#xff0c;创建一个语音合成项目和创建用户并设置权限。 2.获取appKey、accessKeyId、accessKeySecret在相应位置进行填写。 3.相应位置填写自己需要保存的本地路径。意思就是说&#xff0c;自…
阅读更多...
最新文章

Copyright @ 2022~2023